Thread: automatic password for pg_dump to be used for a batch file in vb6

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
ina batch file and call it inside vb6 via "shell", but my problem is that the batch file executes but stops to prompt
fora password. how can i supply a password to it automatically or i mean within visual basic 6 so that no user
interactionis needed, i don't mind about the security since only the administrator has access for the program. please,
anyhelp will be greatly appreciated. thank you. 

oliver
A man is what he is, not what he used to be





____________________________________________________________________________________
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/

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_dumpin a batch file and call it inside vb6 via "shell", but my problem is that the batch file executes but stops to
promptfor a password. how can i supply a password to it automatically or i mean within visual basic 6 so that no user
interactionis needed, i don't mind about the security since only the administrator has access for the program. please,
anyhelp will be greatly appreciated. thank you.
 
>
>   

1. pgsql-hackers is not really the right list to ask this question. In 
future, please ask usage question on pgsql-general
2. have your vb program write out a pgpass file, if necessary also 
setting up the PGPASSFILE environment setting in the .bat file to point 
to it.
2-a. alternatively, use some auth method that does not require use of 
passwords.

cheers

andrew

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

Firstly, this is the wrong list;  this one is to discuss the development
OF postgres, NOT with.  You need novice or general.

Secondly: look for pgpass in the documentation