Re: [GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

2007-03-20 Thread Raymond O'Donnell
On 20/03/2007 14:04, Lars Haugseth wrote: As you can see, all of these command line utilities accept the -W parameter followed by the password. Correct me if I'm wrong, but doesn't -W simply force a prompt from the password? - it doesn't accept the password on the command line. Using the .p

Re: [GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

2007-03-20 Thread Lars Haugseth
* "filippo" <[EMAIL PROTECTED]> wrote: > > Hello, > > I have written a program perl/Tkprogram, based on postgres. For > maintenance reasons in my program I use these commands: > > `dropdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`; > `createdb -U postgres -h $BACKUP_SERVER $

Re: [GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

2007-03-15 Thread Alvaro Herrera
filippo wrote: > Hello, > > I have written a program perl/Tkprogram, based on postgres. For > maintenance reasons in my program I use these commands: > > `dropdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`; > `createdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`; >

[GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

2007-03-15 Thread filippo
Hello, I have written a program perl/Tkprogram, based on postgres. For maintenance reasons in my program I use these commands: `dropdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`; `createdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`; `pg_dump -U postgres -h $D