Postgres database backup

[m.maheshpathak@gmail.com]

Hi,
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
Mahesh-

[kkubasik]

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.