Search Postgresql Archives

Re: PostgreSQL 9.0 Streaming Replication Configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Feb 08, 2011 at 08:51:42PM -0600, Ogden wrote:
> 
> On Feb 8, 2011, at 8:47 PM, Ray Stell wrote:
> 
> > 
> > pg_controldata command is helpful.
> > 
> > Archiving wal not required, but you can roll it either way. 
> > 
> > 
> 
> That is my confusion - Archiving wal does not conflict in any way with streaming replication? What if streaming replication lags behind (especially with a lot of connections). 
> 

I don't know about the "any way" deal.  The admin cookbook says:

"There are two main ways to set up streaming replication: with or without
an additional archive. Set up without an external archive is presented
here, as it is both the most simple and efficient way. There is one
downside that suggests the simple approach may not be appropriate for
larger databases, explained later in the recipe."

It looks like that has to do with the initial backup for building the 
standby taking to long. 

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux