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

From Romero, Yonatan
Subject Re: BUG #15499: pg_dump does not read connection URL from environment variable
Date
Msg-id CADMUJRjGojMN3S0a=yhq+KEdYi80H0nj7YG3-VNRbcOXsu6SYQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15499: pg_dump does not read connection URL from environment variable  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Thanks for your time.
Regards

On Mon, Nov 12, 2018 at 6:03 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Monday, November 12, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
pg_dump's docs says this command can use connection string on --dbname
argument[1].

A command line argument and the parameter it links to are two separate things.  

Also, the libpq environments variables's documentation says PGDATABASE
behaves the same as the dbname connection parameter[2].
 
Which the linked portion then says:

"In certain contexts, the value is checked for extended formats;"

I try to pass connection string on PGDATABASE environment variable, but it
does [not] work.

Which implies that PGDATABASE envvar interpretation is not one of those places where the extended URI connection string format can be passed; instead the environment variables covering the different parts need to be used.  Using them works one-to-one with the plain meaning of the parameters they link to.

Probably the docs could use a note to that effect.

David J.



--
Yonatan Romero
Onapsis | Python developer | T2
www.onapsis.com

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

pgsql-bugs by date:

Previous
From: Pavel
Date:
Subject: Fail to create PK or index for large table in Windows
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15495: Ldap authentication not working with multiple serverin Postgresql 11