BUG #15499: pg_dump does not read connection URL from environmentvariable - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15499: pg_dump does not read connection URL from environmentvariable
Date
Msg-id 15499-915b551f9a1861de@postgresql.org
Whole thread Raw
Responses Re: BUG #15499: pg_dump does not read connection URL from environment variable  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15499
Logged by:          Yonatan Romero
Email address:      yromero@onapsis.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@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


pgsql-bugs by date:

Previous
From: Derek Nelson
Date:
Subject: Re: Tables created WITH OIDS cannot be dumped/restored properly
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15499: pg_dump does not read connection URL from environment variable