Re: [GENERAL] 9.1.3 Standby catchup mode

2012-04-10 Thread Fujii Masao
On Fri, Apr 6, 2012 at 1:35 AM, hans wulf wrote: > I am wondering how the catchup mode of a hot synchron slave server works on > 9.1.3 if there is no WAL archive. > > Can the slave only request WALs that are still in the xlog directory of the > master server? Or does the master regenerate some k

Re: [GENERAL] 9.1.3 Standby catchup mode

2012-04-08 Thread Adrian Klaver
On 04/08/2012 03:51 AM, hans wulf wrote: Why would you not want to maintain a WAL archive? Are you depending on the slave server(s) as your only form of backup? If the slave devide acts as a perfect backup, why would I need an additional 3rd entiy for WAL backups? Belt and suspenders mode:)

Re: [GENERAL] 9.1.3 Standby catchup mode

2012-04-08 Thread hans wulf
is, but I don't see the need for a WAL archive in sync mode. Can you please explain that? Thanks Original-Nachricht > Datum: Fri, 6 Apr 2012 17:54:54 -0400 > Von: Michael Nolan > An: hans wulf > CC: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] 9.1.3 S

Re: [GENERAL] 9.1.3 Standby catchup mode

2012-04-06 Thread Michael Nolan
On Thu, Apr 5, 2012 at 12:35 PM, hans wulf wrote: > I am wondering how the catchup mode of a hot synchron slave server works > on 9.1.3 if there is no WAL archive. > Why would you not want to maintain a WAL archive? Are you depending on the slave server(s) as your only form of backup? It isn't

Re: [GENERAL] 9.1.3 Standby catchup mode

2012-04-06 Thread Adrian Klaver
On 04/05/2012 09:35 AM, hans wulf wrote: > I am wondering how the catchup mode of a hot synchron slave server works on > 9.1.3 if there is no WAL archive. http://www.postgresql.org/docs/9.1/interactive/warm-standby.html#STREAMING-REPLICATION "Streaming replication allows a standby server to sta