search

dbos-inc / dbos-transact

The TypeScript framework for backends that scale
https://docs.dbos.dev
MIT License
335 stars 22 forks source link

warning: choosing postgres user "dbos" is a bad idea #410

Closed alexbodn closed 3 months ago

alexbodn commented 3 months ago

everything worked fine but on a later installation I had the bad inspiration to choose this name for the postgres role/user, and postgres confused the user name with the schema name dbos. thank you very much!

apoliakov commented 3 months ago

Thanks @alexbodn ! We'll see if it makes sense to make it a doc change or fix it another way

kraftp commented 3 months ago

Good catch! Unfortunately the conflict with the schema name seems pretty baked into Postgres, so I added a configuration schema validation rule that disallows the dbos database username so users will see this issue early. https://github.com/dbos-inc/dbos-transact/pull/412

kraftp commented 3 months ago

Addressed in https://github.com/dbos-inc/dbos-transact/pull/412