Re: BUG #15499: pg_dump does not read connection URL from environment variable

Поиск
Список
Период
Сортировка
От Romero, Yonatan
Тема Re: BUG #15499: pg_dump does not read connection URL from environment variable
Дата
Msg-id CADMUJRjGojMN3S0a=yhq+KEdYi80H0nj7YG3-VNRbcOXsu6SYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15499: pg_dump does not read connection URL from environment variable  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavel
Дата:
Сообщение: Fail to create PK or index for large table in Windows
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #15495: Ldap authentication not working with multiple serverin Postgresql 11