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

Re: postgres 9 streaming replication

From: "Khadtare, Sharad" <sharad(dot)khadtare(at)teamaol(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: postgres 9 streaming replication
Date: 2011-01-25 11:59:28
Message-ID: 951D39B8B6185A4D852967EB943E7AE701CEA3AF@AOLE1AMEC31.ad.aol.aoltw.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

Pls find below logfile of standby and recovery.conf in standby data directory.

bash-3.2$ cat logfile
LOG:  database system was interrupted while in recovery at log time 2011-01-25 05:28:35 EST
HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
LOG:  entering standby mode
LOG:  restored log file "000000010000000000000037" from archive
LOG:  redo starts at 0/37000020
LOG:  consistent recovery state reached at 0/38000000
LOG:  database system is ready to accept read only connections
cp: cannot stat `/db/postgres/archive/000000010000000000000038': No such file or directory
LOG:  unexpected pageaddr 0/30000000 in log file 0, segment 56, offset 0
cp: cannot stat `/db/postgres/archive/000000010000000000000038': No such file or directory
LOG:  trigger file found: /db/postgres/trigger
LOG:  redo done at 0/370000D8
LOG:  restored log file "000000010000000000000037" from archive
cp: cannot stat `/db/postgres/archive/00000002.history': No such file or directory
LOG:  selected new timeline ID: 2
cp: cannot stat `/db/postgres/archive/00000001.history': No such file or directory
LOG:  archive recovery complete
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

Regards,
Sharad k


-----Original Message-----
From: Fujii Masao [mailto:masao(dot)fujii(at)gmail(dot)com] 
Sent: Tuesday, January 25, 2011 3:38 PM
To: Khadtare, Sharad
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] postgres 9 streaming replication

On Tue, Jan 25, 2011 at 5:01 PM, Khadtare, Sharad <sharad(dot)khadtare(at)teamaol(dot)com> wrote:
> Configured postgres 9 streaming replication and changed parameter in 
> postgresql.conf & pg_hba.conf file
>
> Problem is wal sender & receiver process not started , is there any 
> way to check process please suggest.

What log messages did you get right after starting the standby?

Did you locate the recovery.conf in PostgreSQL's data directory, not /etc or elsewhere?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center

In response to

Responses

pgsql-bugs by date

Next:From: Fujii MasaoDate: 2011-01-25 12:24:44
Subject: Re: postgres 9 streaming replication
Previous:From: Rodriguez FernandoDate: 2011-01-25 11:50:18
Subject: Re: BUG #5847: pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0x96

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