Re: Re: database system identifier differs between the primary and standby

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Rajib IN MAA SL Deka" <rajib(dot)deka(at)siemens(dot)com>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: database system identifier differs between the primary and standby
Date: 2011-04-22 16:13:34
Message-ID: 4DB162DE020000250003CBD4@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Deka, Rajib IN MAA SL" <rajib(dot)deka(at)siemens(dot)com> wrote:

> Finally I setup two machines for primary and backup using the
> following link.
> http://wiki.postgresql.org/wiki/Streaming_Replication
>
> But after starting the backup I got the following messages and
> postgresql service doesn't start.

> 2011-04-22 14:37:54 ETC/GMT DEBUG: executing restore command "cp
> /opt/PostgreSQL/9.0/data/archive/000000010000000000000007
> "pg_xlog/RECOVERYXLOG""
> 2011-04-22 14:37:54 ETC/GMT LOG: restored log file
> "000000010000000000000007"
> from archive
> 2011-04-22 14:37:54 ETC/GMT DEBUG: got WAL segment from archive
> 2011-04-22 14:37:54 ETC/GMT LOG: record with zero length at
> 0/700011C
> 2011-04-22 14:37:54 ETC/GMT LOG: record with zero length at
> 0/700011C

You will probably get better results starting a new thread on
pgsql-general with details about how you have this set up, in
addition to log entries such as you have shown. The pgsql-hackers
list is really not the right place to discuss this, and many people
selectively read messages based on the subject line, so a misleading
subject line may prevent the people best placed to help you from
reading the post.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-04-22 16:30:51 Re: best way to test new index?
Previous Message Tom Lane 2011-04-22 16:06:56 Re: "stored procedures"