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

Re: Postgresql 9.1 replication failing

From: desmodemone <desmodemone(at)gmail(dot)com>
To: Jim Buttafuoco <jim(at)contacttelecom(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Jerry Sievers <gsievers19(at)comcast(dot)net>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgresql 9.1 replication failing
Date: 2011-12-01 22:53:48
Message-ID: CAEs9oFkCMbf2BgsWor_DisCxeGscte+MBfEDzGjyjkF1fh_Bww@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello Jim,
               I think you not have other possibilities if the archives are
corrupted and there are no possibilities to restore it,
you need to recreate the standby starting from a base backup.

Kind Regards


2011/12/1 Jim Buttafuoco <jim(at)contacttelecom(dot)com>

> Simon,
>
> What do you mean, start over with a base backup?
>
> Jim
>
> On Dec 1, 2011, at 4:08 PM, Simon Riggs wrote:
>
> On Thu, Dec 1, 2011 at 7:09 PM, Jim Buttafuoco <jim(at)contacttelecom(dot)com>wrote:
>
>> the WAL file on the master is long gone, how would one inspect the web
>> segment?  Any way to have PG "move" on?
>>
>
> Regenerate the master.
>
>
>
>> --
>>
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>
>
> ___________________________________________________________
>
>
>
>
>
>
> Jim Buttafuoco
> jim(at)contacttelecom(dot)com
> 603-647-7170 ext. 2222- Office
> 603-490-3409 - Cell
> jimbuttafuoco - Skype
>
>
>
>
>
>
>
>

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-12-01 23:47:17
Subject: Re: backup_label during crash recovery: do we know how to solve it?
Previous:From: Josh BerkusDate: 2011-12-01 22:52:44
Subject: Re: to_date() marked stable?

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