Re: Problem with streaming replication, backups, and recovery (9.0.x)

On Mon, Mar 28, 2011 at 04:53:37PM -0500, Kevin Grittner wrote:
> hubert depesz lubaczewski <depesz@depesz.com> wrote:
> > On Mon, Mar 28, 2011 at 04:24:23PM -0500, Kevin Grittner wrote:
> >> hubert depesz lubaczewski <depesz@depesz.com> wrote:
> >>  
> >>> how come that I can use this backup to make standalone pg, and
> <<< it starts without any problem, but when I start it as sr slave,
> >>> let it run for some time, and then promote to standalone, it
> >>> breaks?
> >>  
> >> We need more detail to make much of a guess about that.
> > 
> > what details can I provide?
> > 
> > I can provide scripts that I use to test it, and also access to
> > test machine that I was testing it on.
>  
> For starters, what do you mean by "it breaks"?  What, exactly
> happens?  What is in the logs?  What version of PostgreSQL?  Are you
> using pg_standby or custom scripts?

hmm ... i thought that all details are in the first mail in thread.

I can probably repost it, but it seems to me that it includes all of the
information - which scripts, how it fails, in what cases, and what
exactly i'm doing.

have you seen this mail -
http://archives.postgresql.org/pgsql-hackers/2011-03/msg01490.php ?

Best regards,

depesz

-- 
The best thing about modern society is how easy it is to avoid contact with it.
                  http://depesz.com/