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(at)depesz(dot)com> wrote:
> > On Mon, Mar 28, 2011 at 04:24:23PM -0500, Kevin Grittner wrote:
> >> hubert depesz lubaczewski <depesz(at)depesz(dot)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/