Page 1 of 1
Postgres Database Backup
Posted: 02.05.2007, 11:26
by sandeep_c24
How can I use Zeos to backup Postgres database?
Regards
Sandeep
Posted: 03.05.2007, 15:39
by btrewern
I think you'd be better off using the pg_dump and pg_dumpall included in the Postgresql distro. They are made for the purpose.
Regards,
Ben
Posted: 03.05.2007, 21:35
by sandeep_c24
The thing with pgdump is I cannot use it from application without storing password in pgpass file. I don't want to do this. Is there any other way of backing up postgres database from the application?
Regards
Sandeep
Posted: 03.12.2007, 14:43
by varathasiva
no need to put the password in pgpass file.just u want set pasword thru command
Posted: 04.12.2007, 14:55
by btrewern
It doesn't look as if there is an option to call pg_dump with a password without using the .pgpass file. I think it's for security reasons.
You could hack pg_dump to take a password on the command line. I'm not sure how much work it would be but you do have the code available.
Regards,
Ben
Posted: 23.01.2008, 10:05
by varathasiva
set PGPASSWORD=my_password u can use this command before run pg_dump command