Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 429F0B5F5B5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  7 Jun 2011 13:32:41 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 29495-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  7 Jun 2011 16:32:34 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nm13-vm0.bullet.mail.ne1.yahoo.com
	(nm13-vm0.bullet.mail.ne1.yahoo.com [98.138.91.48])
	by mail.postgresql.org (Postfix) with SMTP id 6DB9BB5F5B0
	for <pgsql-admin@postgresql.org>; Tue,  7 Jun 2011 13:32:32 -0300 (ADT)
Received: from [98.138.90.50] by nm13.bullet.mail.ne1.yahoo.com with NNFMP;
	07 Jun 2011 16:32:31 -0000
Received: from [98.138.89.249] by tm3.bullet.mail.ne1.yahoo.com with NNFMP;
	07 Jun 2011 16:32:31 -0000
Received: from [127.0.0.1] by omp1041.mail.ne1.yahoo.com with NNFMP;
	07 Jun 2011 16:32:31 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 808572.46303.bm@omp1041.mail.ne1.yahoo.com
Received: (qmail 13084 invoked by uid 60001); 7 Jun 2011 16:32:31 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1307464351; bh=dpln67lfCcrOYQ2Ivlj2uw/dCbxpFqmglddISAziOMk=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=1p61VkBxeWdsyCurz4a0zzOGsLQbjvj+gZefUSMlnNmvF8M8G8nEE2ijcrDP4O1/SZJqzVs6pKuhzkt8PzV2EEILv4aPmeIQWCVdwjgXV86stEPDtRVpfWGci+Zbu9YRV3uwLrm33CDgpzIafAyXggO8itXGdgP57NJfEh/5j8Q=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=6HrRmvddryq8CSoIteP1ZtMf4cDaePBzRqGObtNgpjRovBUAVF4qpRnG06zxCQ8w3gzdAygvdGJoOzTRPGi6m1WjGDucYKMupgormoKE4Ssbm2jRiWYM24UUF6UuRyCHcN3EDS+8Snlf6uG54MBvYcXRMmCodSZtFWgtzN9R1Zg=;
Message-ID: <693391.31715.qm@web120020.mail.ne1.yahoo.com>
X-YMail-OSG: BECcvsAVM1mjJf.XYTM7H9.zGZR9_UYrEVRe8hgX1FCAdbp
	HTsoIbTz17B0dZmpNemum6OA29hsLWi8Zc44KSbtBN5HX6G22xQPttumpyRz
	6Zvq61EhgfdhZWNV.HX_x9ysDnXLHRb_xMMsa5A6hl0.Pco_9oTQpqTNKnr6
	SdM1t8YmWG43MSmILIksNkbBsfh7.jUKfphLvuoBGVAvhYCYbBJDOaCZQfRk
	3fvko0yKVklntjTis9ualiJJZYwaIK_zxLB3N2uJZ__LmBQea2.G7VnTHbPQ
	Buj8Kv8zze20iRUOMqteVAz_Is6OeewTv3FPiDA_2aZN8iAbekg8-
Received: from [64.61.91.74] by web120020.mail.ne1.yahoo.com via HTTP;
	Tue, 07 Jun 2011 09:32:31 PDT
X-Mailer: YahooMailRC/570 YahooMailWebService/0.8.111.304355
Date: Tue, 7 Jun 2011 09:32:31 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: Switchover of Master and Slave roles
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-138916902-1307464351=:31715"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.897 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001,
	T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201106/29
X-Sequence-Number: 37655

--0-138916902-1307464351=:31715
Content-Type: text/plain; charset=us-ascii

Hello,
I am trying to switch the master and slave roles in a test I am doing with 
streaming replication in 9.1 beta.

To start with, I have one master (N1 node) and one slave (N2 node).

I stop N1 and promote N2 as primary (by touching the trigger file).
Now I wish for N1 to come back up as slave of N2. How should I do that ?

I tried creating a recovery.conf in N1's directory, along with cleaning up its 
pg_xlog and pg_log.
But when I start N1 and try to connect to it, I get the message:
psql: FATAL:  the database system is starting up

And the log file of N1 says:
FATAL:  timeline 2 of the primary does not match recovery target timeline 1

Any ideas on what could I be missing ?

Thanks,
AJ

--0-138916902-1307464351=:31715
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div>Hello,</div><div>I am trying to switch the master and slave roles in a test I am doing with streaming replication in 9.1 beta.</div><div><br></div><div>To start with, I have one master (N1 node) and one slave (N2 node).</div><div><br></div><div>I stop N1 and promote N2 as primary (by touching the trigger file).</div><div>Now I wish for N1 to come back up as slave of N2. How should I do that ?</div><div><br></div><div>I tried creating a recovery.conf in N1's directory, along with cleaning up its pg_xlog and pg_log.</div><div>But when I start N1 and try to connect to it, I get the message:</div><div><div>psql: FATAL: &nbsp;the database system is starting up</div></div><div><br></div><div>And the log file of N1 says:</div><div><div>FATAL: &nbsp;timeline 2 of the primary does not match
 recovery target timeline 1</div></div><div><br></div><div>Any ideas on what could I be missing ?</div><div><br></div><div>Thanks,</div><div>AJ</div><div><br></div><div style="position:fixed"></div>


</div></body></html>
--0-138916902-1307464351=:31715--