Обсуждение: Keeping a Backup database in sync with the primary
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
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.
On Tuesday 09 January 2007 07:32, Carlson, James (Jim) wrote: > 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? You can certainly use a cron job to dump and reload the database, but you might want to look at other ways of doing this such as: http://slony.info Sean