Keeping a Backup database in sync with the primary

From: "Carlson, James (Jim)" <jcarlson(at)rti(dot)org>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Keeping a Backup database in sync with the primary
Date: 2007-01-09 12:32:16
Message-ID: 5C7823A154D8384CBDBE8F20F2038FA8E06931@rtpwexc10.RCC_NT.RTI.ORG
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rti(dot)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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-01-09 13:37:08 Re: Keeping a Backup database in sync with the primary
Previous Message Sean Davis 2007-01-08 22:46:57 Re: Column Name = column does not exist