Postgres Database Backup

sandeep_c24 · Post by **sandeep_c24** » 02.05.2007, 11:26

How can I use Zeos to backup Postgres database?

Regards

Sandeep

btrewern · Post by **btrewern** » 03.05.2007, 15:39

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

sandeep_c24 · Post by **sandeep_c24** » 03.05.2007, 21:35

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

varathasiva · Post by **varathasiva** » 03.12.2007, 14:43

no need to put the password in pgpass file.just u want set pasword thru command

btrewern · Post by **btrewern** » 04.12.2007, 14:55

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

varathasiva · Post by **varathasiva** » 23.01.2008, 10:05

set PGPASSWORD=my_password u can use this command before run pg_dump command