On Wednesday, July 10, 2002, at 08:54 AM, Kevin Brannen wrote:
Stuff deleted
> The order I would propose would be: env-var, command-line, STDIN,
> interactive prompt if we have a tty. Reorder as you see fit.
To the above list I would add a .psql (or something) file in
the home dir of the pe
Bruce Momjian wrote:
> Kevin Brannen wrote:
>
>>Bruce Momjian wrote:
>>...
>>
>>>7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
>>>file that contains the password.
>>
>>But do you know how many hours it took me to find out about PGPASSWORD
>>in the docs and now you want t
> -Messaggio originale-
> Da: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Inviato: mercoledì 10 luglio 2002 4.11
> A: Kevin Brannen
> Cc: [EMAIL PROTECTED]
> Oggetto: Re: [ADMIN] Authentication in batch processing
>
>
> Kevin Brannen wro
Kevin Brannen wrote:
> Bruce Momjian wrote:
> ...
> >
> > 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
> > file that contains the password.
>
> But do you know how many hours it took me to find out about PGPASSWORD
> in the docs and now you want to change that? :-)
>
Bruce Momjian wrote:
...
>
> 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
> file that contains the password.
But do you know how many hours it took me to find out about PGPASSWORD
in the docs and now you want to change that? :-)
How about all 4 approaches: on the com
In my previous message I forgot to say that there is also another file
to patch to re-enable the old stdin input method for pg_dump:
In addition to: src/bin/psql/common.c
You have to patch also: src/bin/pg_dump/pg_backup_db.c
Changes to apply are the same.
--
t;http://www.xmedia.net>
via Francesco Benaglia, 13 - Tel. +39 06 588851
00153 Roma Italy fax +39 06 58885016
--
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: tuesday 4 july 2002 18.16
> To: Alfred Anzlovar
> Cc: Alfred Anzlova
On Tue, 2 Jul 2002, Bruce Momjian wrote:
> Yes, we had complaints that people were running their script and they
> wouldn't be prompted for the password on their terminal. Researching,
> we found no applications that gets passwords from stdin _if_ a
> controlling terminal (/dev/tty) can be opene
At 12:16 PM 7/4/02 -0400, Bruce Momjian wrote:
> > Well, I must admit we had some rain today, but after your answer sun came
> > from behind the clouds :)
Rain? I've heard about that. Something about moisture falling from the
sky. Haven't seen any here in Phoenix for several months.
On Thu, 4 Jul 2002, Bruce Momjian wrote:
> How about PGUSER/PGPASSWORD? That will work. This is assuming you
> don't have an OS (BSD?) that displays environment variables for a
> process.
No BSD, Linux. And it works. Thanks.
Well, I must admit we had some rain today, but after your answer sun
Alfred Anzlovar wrote:
> On Thu, 4 Jul 2002, Bruce Momjian wrote:
>
> > How about PGUSER/PGPASSWORD? That will work. This is assuming you
> > don't have an OS (BSD?) that displays environment variables for a
> > process.
>
> No BSD, Linux. And it works. Thanks.
>
> Well, I must admit we had s
Alfred Anzlovar wrote:
> Maybe this could/can be done differently, but as it was, it was so easy
> and nice. And if there are more of us, poor souls, with comparable
> problems maybe an option called '--pwd-from-stdin-only' would be a
> solution. Another option (thanks God for Open Source proje
Alfred Anzlovar wrote:
> [EMAIL PROTECTED] (Bruce Momjian) wrote in message
>news:<[EMAIL PROTECTED]>...
> > Password prompting was changed in 7.2.X. You can now pass a script into
> > psql, and you will be prompted for the password on your terminal rather
> > than having the password coming fro
[EMAIL PROTECTED] (Bruce Momjian) wrote in message
news:<[EMAIL PROTECTED]>...
> Password prompting was changed in 7.2.X. You can now pass a script into
> psql, and you will be prompted for the password on your terminal rather
> than having the password coming from the script.
>
> The best way
Password prompting was changed in 7.2.X. You can now pass a script into
psql, and you will be prompted for the password on your terminal rather
than having the password coming from the script.
The best way send the password in 7.2.X is to use 'expect', or use the
PGPASSWORD environment variable
I have postgres set up to require usernames and passwords for access.
The following script works just fine in 7.1.2 without manual
intervention. Using 7.2.1 psql issues a password prompt and
blocks until a password is manually entered.
###
#!/bin/sh
psql myd
16 matches
Mail list logo
