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 postmaster.pid
> --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: 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: rudi||Date: 2011-04-20 08:57:48|
|Subject: Re: Streaming replication: rsync to switchover|
|Previous:||From: Mlondolozi Ncapayi||Date: 2011-04-20 07:02:31|
|Subject: How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7|