DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=Ms4sTiD7Np+kkBq9CQMDpG1Cp1JV7fwpIR08O0/oYclNord4irBVRvrdL6hOgF5bNW
	5tnRRlY6Wz5p9LFiOhdS9mPyTjvI/B9brP166vYezCw11BOfBiSKtCurK04WErLjkxCx
	NSob+1iOCGkm/ViKULIzl/Zdji9hiWdkotzV8=
Message-ID: <4CA338BE.6030503@gmail.com>
Date: Wed, 29 Sep 2010 15:01:50 +0200
From: Michal Glowacki <mg.scandic@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; pl;
	rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4
MIME-Version: 1.0
To: Guillaume Lelarge <guillaume@lelarge.info>
CC: Fujii Masao <masao.fujii@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: Hot standby server does not start
References: <4CA2F025.3010508@gmail.com>
	<AANLkTim8eZ3nMPN3_1Au1pb32Rfv6v2NtifmCu0OCf6u@mail.gmail.com>
	<4CA2F5ED.3000209@gmail.com> <4CA2FF32.6070002@lelarge.info>
In-Reply-To: <4CA2FF32.6070002@lelarge.info>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  W dniu 2010-09-29 10:56, Guillaume Lelarge pisze:
>
> Using rar on the data folder should work if you don't have tablespaces.
> If you have some, add them to your data rar archive.
>
> And instead of overwriting the data folder on the slave, wipe out your
> old data folder and recreate it by restoring your rar archive.
>
> BTW, pgAdmin backup and restore facilities use pg_dump/pg_restore. So
> it's not really surprising that you get the same results :)
>
>

Alright, now it starts - thanks:

2010-09-29 14:54:33 CEST LOG:  database system was interrupted; last 
known up at 2010-09-29 13:02:11 CEST
2010-09-29 14:54:33 CEST LOG:  entering standby mode
2010-09-29 14:54:34 CEST LOG:  streaming replication successfully 
connected to primary
2010-09-29 14:54:34 CEST LOG:  redo starts at 6/D2000020
2010-09-29 14:54:34 CEST LOG:  consistent recovery state reached at 
6/D3000000
2010-09-29 14:54:34 CEST LOG:  database system is ready to accept read 
only connections

, but still some questions on my side :)

1. I wiped out the data dir on standby and modified configuration in 
files backed up from master - I believe I had to it, to configure it as 
standby.

2. Now I would like to connect to standby to see myself if it 
replicates, but when I run pgadminIII and try to connect to standby I got:

2010-09-29 14:55:05 CEST FATAL:  could not open file "global/11601": No 
such file or directory

And I can't connect to standby database. I know it's because I wiped out 
/data folder - how can I connect to standby then? Even if I can believe 
it's replicating at the moment, when the master is down then I need 
access to standby.

Regards,
Michal