| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | chinnaobi <chinnaobi(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: hot standby PSQL 9.1 Windows 2008 Servers |
| Date: | 2012-05-22 13:20:58 |
| Message-ID: | CA+TgmoanA_uMn3UaN-9kdW8vrPs2UGkhaLdidpc=aTyeF1H6UQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, May 14, 2012 at 8:18 AM, chinnaobi <chinnaobi(at)gmail(dot)com> wrote:
> I do base backup only first time on standby when it is going to be
> replicated. when ever primary goes down, standby becomes primary and
> primary becomes standby when primary comes up. When primary becomes standby
> I am restoring data from WAL archive and start postgres service streaming
> replication to connect to primary.
>
> This setup is working.
I don't think this is safe. The primary might have WAL that never
made it to the standby, in which case the two machines will be out of
sync with each other and all sorts of bad stuff could happen.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-05-22 13:22:12 | Re: ERROR: catalog is missing 2 attribute(s) for relid 16584 |
| Previous Message | Robert Haas | 2012-05-22 13:05:43 | Re: Changing the concept of a DATABASE |