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

From: "Romero, Yonatan" <yromero(at)onapsis(dot)com>
To: david(dot)g(dot)johnston(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15499: pg_dump does not read connection URL from environment variable
Date: 2018-11-12 21:10:54
Message-ID: CADMUJRjGojMN3S0a=yhq+KEdYi80H0nj7YG3-VNRbcOXsu6SYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks for your time.
Regards

On Mon, Nov 12, 2018 at 6:03 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Monday, November 12, 2018, PG Bug reporting form <
> noreply(at)postgresql(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jürgen Strobel 2018-11-12 23:06:45 Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation
Previous Message Pavel 2018-11-12 21:06:55 Fail to create PK or index for large table in Windows