Re: automatic password for pg_dump to be used for a batch file in vb6 - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: automatic password for pg_dump to be used for a batch file in vb6
Date
Msg-id 45D49F08.6020509@hagander.net
Whole thread Raw
In response to automatic password for pg_dump to be used for a batch file in vb6  (oliver rombaoa <watsamalayu@yahoo.com>)
List pgsql-hackers
oliver rombaoa wrote:
> i want to add database backup to my program i developed in visual
> basic 6, of course i can save the syntax for pg_dump in a batch file
> and call it inside vb6 via "shell", but my problem is that the batch
> file executes but stops to prompt for a password. how can i supply a
> password to it automatically or i mean within visual basic 6 so that
> no user interaction is needed, i don't mind about the security since
> only the administrator has access for the program. please, any help
> will be greatly appreciated. thank you.

Use the pgpass.conf file or the PGPASSWORD environment variable to
supply the password.

//Magnus


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: automatic password for pg_dump to be used for a batch file in vb6
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: automatic password for pg_dump to be used for a batch file in vb6