how to make a postgres backup on servers which run on linux/windows

Question

i am creating a web application in asp.net with database on postgres. i have successfuly created a database backup by putting the destination of database backup on the webconfig file. the web application succesfully creates backups when published on windows server, however i was wondering if the server is changed to linux the destination folder would be invalid.what could be the solution for it to work on different OS??

another problem is that the postgres installation could be on any drive in linux whereas rightnow in my webapplication i open the system diagnostics to run the pgdump command using the info.filename="C:\Program Files\PostgreSQL\9.3\bin\" + commandType + ".exe ";

anyone has solution for multiOS database backup for postgres using asp.net?? is there any solution to this??

i have successfuly deployed the application in windows server,however i am thinking what would happen if the server goes to linux check this link everest.planetearthsolution.com/File/BackupCompany.aspx.. — user3118094
– user3118094, Commented Jan 29, 2014 at 16:05

Craig Ringer · Accepted Answer · 2014-01-30 01:12:43Z

1

You can continue to use your backup scripts on Windows. pg_dump will happily connect to the remote database on the Linux box. E.g.

pg_dump -h my_linux_server ....

I strongly suggest reading the PostgreSQL docs on backup/restore. Consider setting up PITR in addition to periodic dumps. I'd recommend running PgBarman on the Linux server (archiving to an external drive, NAS, or network share) for point-in-time recovery, plus periodic dumps to the Linux box.

See: http://www.postgresql.org/docs/current/static/backup.html

answered Jan 30, 2014 at 1:12

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to make a postgres backup on servers which run on linux/windows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related