Please ignore- seems some old mail of mine got sent waaay late...
Christopher Kings-Lynne wrote:
While fixing the gui for pg_dump and pg_restore, I painfully noticed
there's no option for the password.
After some tests, I found that using the PGPASSWORD environment
variable will do the job. I'm a
While fixing the gui for pg_dump and pg_restore, I painfully noticed
there's no option for the password.
After some tests, I found that using the PGPASSWORD environment variable
will do the job. I'm a bit irritated that it's marked "deprecated" in
the docs, the .pgpass solution isn't a good one
Magnus Hagander said:
How about an environment variable that points to a .pgpass type file.
>>
>>So let's go woth PGPASSFILE
>
> How about --pwfile on the commandline, the same way initdb does it?
>
Then you can't make it part of libpq - you would have to build it into every
program that need
Christopher Kings-Lynne wrote:
It's deprecated because it's insecure, on platforms where other users can
see the environment variables passed to pg_dump (which apparently is
quite a few variants of Unix). You wouldn't pass the password on the
command line either ...
Painful as .pgpass may be for a
>>>How about an environment variable that points to a .pgpass type file.
>>
>>You can do that today: point $HOME at some temp directory or other.
>>AFAIR pg_dump doesn't make any other use of $HOME ...
>>
>>>Or we could even play games with PGPASSWORD - if it names an
>existing file
>>>that satis
Tom Lane wrote:
It's deprecated because it's insecure, on platforms where other users can
see the environment variables passed to pg_dump (which apparently is
quite a few variants of Unix). You wouldn't pass the password on the
command line either ...
Painful as .pgpass may be for an admin tool, I
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
How about an environment variable that points to a .pgpass type file.
You can do that today: point $HOME at some temp directory or other.
AFAIR pg_dump doesn't make any other use of $HOME ...
Or we could even play games with PGP
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> How about an environment variable that points to a .pgpass type file.
You can do that today: point $HOME at some temp directory or other.
AFAIR pg_dump doesn't make any other use of $HOME ...
> Or we could even play games with PGPASSWORD - if it names
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
After some tests, I found that using the PGPASSWORD environment variable
will do the job. I'm a bit irritated that it's marked "deprecated" in
the docs, the .pgpass solution isn't a good one for tool managed passwords.
It's deprecated because it's insecure, on platforms where other users can
see the environment variables passed to pg_dump (which apparently is
quite a few variants of Unix). You wouldn't pass the password on the
command line either ...
Painful as .pgpass may be for an admin tool, I do not know of
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> After some tests, I found that using the PGPASSWORD environment variable
>> will do the job. I'm a bit irritated that it's marked "deprecated" in
>> the docs, the .pgpass solution isn't a good one for tool managed passwords.
> I didn't notic
While fixing the gui for pg_dump and pg_restore, I painfully noticed
there's no option for the password.
After some tests, I found that using the PGPASSWORD environment variable
will do the job. I'm a bit irritated that it's marked "deprecated" in
the docs, the .pgpass solution isn't a good one
While fixing the gui for pg_dump and pg_restore, I painfully noticed
there's no option for the password.
After some tests, I found that using the PGPASSWORD environment variable
will do the job. I'm a bit irritated that it's marked "deprecated" in
the docs, the .pgpass solution isn't a good one
13 matches
Mail list logo