| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | yromero(at)onapsis(dot)com |
| Subject: | BUG #15499: pg_dump does not read connection URL from environment variable |
| Date: | 2018-11-12 20:07:42 |
| Message-ID: | 15499-915b551f9a1861de@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15499
Logged by: Yonatan Romero
Email address: yromero(at)onapsis(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: Ubuntu 14.04 LTS
Description:
pg_dump's docs says this command can use connection string on --dbname
argument[1].
Also, the libpq environments variables's documentation says PGDATABASE
behaves the same as the dbname connection parameter[2].
I try to pass connection string on PGDATABASE environment variable, but it
does work.
yromero(at)onapsis:~$ env
PGDATABASE="postgresql://onapsis:secret(at)localhost/onapsis" pg_dump
pg_dump: [archiver (db)] connection to database
"postgresql://onapsis:secret(at)localhost/onapsis" failed: FATAL: role
"yromero" does not exist
References:
[1] https://www.postgresql.org/docs/9.3/app-pgrestore.html
[2] https://www.postgresql.org/docs/9.3/libpq-envars.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2018-11-12 21:03:56 | Re: BUG #15499: pg_dump does not read connection URL from environment variable |
| Previous Message | Derek Nelson | 2018-11-12 20:00:32 | Re: Tables created WITH OIDS cannot be dumped/restored properly |