[GH-ISSUE #112] bug: does not work without write permissions: `permission denied for schema ctgov (SQLSTATE 42501)` is crashing the container #93

New issue

Closed

opened 2026-02-26 21:34:24 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 21:34:24 +03:00

Owner

Originally created by @cachho on GitHub (Apr 1, 2025).
Original GitHub issue: https://github.com/eduardolat/pgbackweb/issues/112

Hey, I'm using https://aact.ctti-clinicaltrials.org/connect as a demo database. You can make your own account there (no confirmation required) in less than a minute and see for yourself.

When I try to connect via docker with the connection string postgresql://user:password@aact-db.ctti-clinicaltrials.org:5432/aact I get the error in title during the startup, the container exits with code 201.

I think this is about not having write permissions, because in pgweb (https://pgweb-demo.fly.dev) the database aact with the schema ctgov can be read.

To create backups, read should suffice.

Originally created by @cachho on GitHub (Apr 1, 2025). Original GitHub issue: https://github.com/eduardolat/pgbackweb/issues/112 Hey, I'm using https://aact.ctti-clinicaltrials.org/connect as a demo database. You can make your own account there (no confirmation required) in less than a minute and see for yourself. When I try to connect via docker with the connection string `postgresql://user:password@aact-db.ctti-clinicaltrials.org:5432/aact` I get the error in title during the startup, the container exits with code 201. I think this is about not having write permissions, because in pgweb (https://pgweb-demo.fly.dev) the database `aact` with the schema `ctgov` can be read. To create backups, read should suffice.

kerem closed this issue

2026-02-26 21:34:24 +03:00

kerem commented

2026-02-26 21:34:24 +03:00

Author

Owner

@cachho commented on GitHub (Apr 1, 2025):

I guess, I got it wrong. The PBW_POSTGRES_CONN_STRING is not for the database that's supposed to be backed up, it's for pgbackweb internally.

please confirm and close, thanks

@cachho commented on GitHub (Apr 1, 2025): I guess, I got it wrong. The `PBW_POSTGRES_CONN_STRING` is not for the database that's supposed to be backed up, it's for pgbackweb internally. please confirm and close, thanks