https://dagster.io/ logo
#dagster-support
Title
# dagster-support
a

Andrew Smith

08/11/2022, 12:05 AM
Basic question from someone just moving to Dagster. When defining the postgres database in
dagster.yaml
, how would I actually define a remote postgres server? The documentation shows the example below, but if I had a server
<http://postgres.myco.com|postgres.myco.com>
with a database named
dagster
hosted on it, is there a a string I should create to contain both those pieces of information or is there another key I should be using that isn't shown?
Copy code
event_log_storage:
  module: dagster_postgres.event_log
  class: PostgresEventLogStorage
  config:
    postgres_db:
      username: { username }
      password: { password }
      hostname: { hostname }
      db_name: { db_name }
      port: { port }
a

alex

08/11/2022, 3:05 PM
https://docs.dagster.io/deployment/dagster-instance the server would be
hostname
and the
db_name
dagster
Copy code
storage:
  postgres:
    postgres_db:
      username: { DAGSTER_PG_USERNAME }
      password: { DAGSTER_PG_PASSWORD }
      hostname: <http://postgres.myco.com|postgres.myco.com>
      db_name: dagster
you can also pass the connection url string directly if you prefer
Copy code
storage:
  postgres:
    postgres_url: ...
a

Andrew Smith

08/11/2022, 3:17 PM
.... I think I was looking at the docs for too long yesterday. No idea how hostname was hiding from me. 😳
Thanks