Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group