Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2005
    Posts
    24

    Postgres database backup


    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-

  2. #2
    Linux Guru kkubasik's Avatar
    Join Date
    Mar 2004
    Location
    Lat: 39:03:51N Lon: 77:14:37W
    Posts
    2,396
    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.
    Avoid the Gates of Hell. Use Linux
    A Penny for your Thoughts

    Formerly Known as qub333

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •