PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15499
PG VersionUnsupported/Unknown
OSUbuntu 14.04 LTS
Opened2018-11-12 20:07:42+00
Reported byYonatan Romero
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15499
Logged by:          Yonatan Romero
Email address:      (redacted)
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@onapsis:~$ env
PGDATABASE="postgresql://onapsis:secret@localhost/onapsis" pg_dump
pg_dump: [archiver (db)] connection to database
"postgresql://onapsis:secret@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

Messages

DateAuthorSubject
2018-11-12 20:07:42+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15499: pg_dump does not read connection URL from environment variable
2018-11-12 21:03:56+00"David G(dot) Johnston"Re: BUG #15499: pg_dump does not read connection URL from environment variable
2018-11-12 21:10:54+00"Romero, Yonatan"Re: BUG #15499: pg_dump does not read connection URL from environment variable