Re: WARM standby with pg_standby - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: WARM standby with pg_standby
Date
Msg-id 4BBEF1150200002500030644@gw.wicourts.gov
Whole thread Raw
In response to Re: WARM standby with pg_standby  (Dennis Thrysøe <dth@geysirit.dk>)
List pgsql-admin
Dennis Thrysøe<dth@geysirit.dk> wrote:

> After copying a new dump of the MASTER cluster data and starting
> the SLAVE with this data, I now get:
>
> Database cluster state:               in production
> ..
> Minimum recovery ending location:     0/0

Somehow it completed archive recovery and switched over to
production.  How are you configured for triggering that?  Is there
some triggering file you need to delete before you try again?

> "cp: cannot stat `/psql_archive/00000001.history': No such file
> or directory"

As already mentioned, that's just noise.  Ignore that line, as long
as you just see it once per startup.

> By the way, one of these lines each second!
>
> "2010-04-09 09:09:49 IST FATAL:  the database system is starting
> up"

Forever, or some fixed number of times?

-Kevin

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: database restoration problem- data became incorrect caused by incorrect date in the server
Next
From: "Kevin Grittner"
Date:
Subject: Re: archive_timeout - good indication