Results 1 to 2 of 2
Thread: Postgres database backup
Enjoy an ad free experience by logging in. Not a member yet? Register.
- Join Date
- Apr 2005
Postgres database backup
Please tell me
I have postgres database dxcf4 and I need to tack backup of this on another system, which is in the same network,
but destination system donít have postgres due to that I want to tack back up in my home dir
Your best bet is just going to be a nfs share over the network, with the remote computer gzipping up the database file. I am not sure where postgres stores this data, but using pg_dump you should be able to make a nightly dump of the server with cron, then have the remote machine pull that dump file.