Keeping a Backup database in sync with the primary - Mailing list pgsql-novice

From Carlson, James (Jim)
Subject Keeping a Backup database in sync with the primary
Date
Msg-id 5C7823A154D8384CBDBE8F20F2038FA8E06931@rtpwexc10.RCC_NT.RTI.ORG
Whole thread Raw
Responses Re: Keeping a Backup database in sync with the primary  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice

I have two Linux servers running with one as a hot standby should the primary fail. It is not critical that they be in sync with every transaction, but I would like to sync them up with a cron job in the middle of the night.

 

Dose anyone have a suggestion on how to do this?

 

Thanks,

Jim Carlson, Principal Scientist

RTI International

3040 Cornwallis Road

MCNC-Bldg. 1, Room 318

Research Triangle Park, North Carolina 27709

jcarlson@rti.org

ph 919-248-9238

fax 919-248-1455

 

This email and its attachments contain confidential information which is intended solely for the use of the addressee and may contain information that is legally privileged, confidential or exempt from disclosure and may be subject to a Mutual Non-Disclosure Agreement between the sender and the recipient. It is intended only for the individual(s) or entity named above and to others who have been specifically authorized to receive it. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to other. Please notify the sender that you have received this e-mail in error by calling the phone number indicated or by e-mail, and delete the e-mail (including any attachment/s) subsequently.

 

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Column Name = column does not exist
Next
From: Sean Davis
Date:
Subject: Re: Keeping a Backup database in sync with the primary