DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	b=B8mCYRly1sFUaVQdO7bnMzLgXQVqaO0NmYKZdB+v/4nJvrbTLCLSwbJUCeQZFl2B0y
	1qo+s5IMomNUhrp2pkwCZLzsIxGYXvQWzlZ3ghe7YYn90mYhqf5nA12Bz+XHGWMWivPj
	oZyJG4Ebt0L0Rrs0FfpB2VtsworjTNmcM16eg=
Message-ID: <4DAEA00C.2040807@gmail.com>
Date: Wed, 20 Apr 2011 10:57:48 +0200
From: rudi <rudolone@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.14) Gecko/20110223 Thunderbird/3.1.8
MIME-Version: 1.0
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Streaming replication: rsync to switchover
References: <4DAC7205.8080203@kemen.it>
	<BANLkTikrqROJjNiVpmkZorkPM7nUYHZUAw@mail.gmail.com>
	<4DAD52D8.1090006@gmail.com> <20110419121105.GA17761@cns.vt.edu>
	<4DADAA5C.6040107@gmail.com> <4DAE98A3.3090002@gmail.com>
In-Reply-To: <4DAE98A3.3090002@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 04/20/2011 10:26 AM, rudi wrote:
> Database cluster state: in archive recovery
>
> and doesn't accept connections:
>
> 2011-04-20 10:17:00 CEST:[local]:u@postgres:[13099] FATAL: the database
> system is starting up
>
> even if is a hot standby.

My fault: it seems I forgot to stop the backup in my previous attempt. I 
tried this procedure and now the former master acts as a hot standby as 
expected:

On the former master:

a) stop
b) cleanup pg_xlog
c) set archive_mode = off and hot_standby = on in postgresql.conf

On the former slave:

a) set archive_mode = on in postgresql.conf
b) psql -c "SELECT pg_start_backup('switchover base backup')"
c) rsync -av $PGDATA --delete --exclude server.crt --exclude server.key 
--exclude recovery.* --exclude postmaster.pid --exclude pg_xlog 
--exclude archive $SLAVE:$PGDATA
d) psql -c "SELECT pg_stop_backup()"

Finally I started the former master.

-- 
rd

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