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

Re: Streaming replication: rsync to switchover

From: rudi <rudolone(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Streaming replication: rsync to switchover
Date: 2011-04-20 08:26:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On 04/19/2011 05:29 PM, rudi wrote:
> $ psql -c "SELECT pg_start_backup('switchover base backup')"
> $ rsync -av /var/lib/postgresql/9.0/main/ --delete --exclude server.crt
> --exclude server.key --exclude recovery.* --exclude
> --exclude archive $FORMER_MASTER_ADDRESS:/var/lib/postgresql/9.0/main/
> $ psql -c "SELECT pg_stop_backup()"

No, it doesn't work. The slave is stuck in "archive recovery":

Database cluster state: in archive recovery

and doesn't accept connections:

2011-04-20 10:17:00 CEST:[local]:u(at)postgres:[13099] FATAL:  the database 
system is starting up

even if is a hot standby.

I really can't find a way to do a safe switchover.


Peel your own image from the mirror.
Sit. Feast on your life.

In response to


pgsql-admin by date

Next:From: rudiDate: 2011-04-20 08:57:48
Subject: Re: Streaming replication: rsync to switchover
Previous:From: Mlondolozi NcapayiDate: 2011-04-20 07:02:31
Subject: How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7

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