Search Postgresql Archives

Re: warm standby with WAL shipping

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

 



On Tue, 2009-06-02 at 19:44 -0400, Geoffrey wrote:
>  
> > pg_standby it self isn't a solution for warm standby. It is a component
> > thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
> > PITRTools it will make your life easier.
> 
> I still don't understand why the pg_standby code is looking for the 
> *.history.  Apparently others have seen this same behavior (according to 
> google), yet I don't see any definitive answer.

http://www.postgresql.org/docs/8.3/static/warm-standby.html
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL

I think will have what you want.



> It appears the PITRTools use pg_standby binary, thus I'm still confused 
> as to how these files are processed.
> 

Yes it does use pg_standby. It just wraps everything that is missing for
warm standby into a single utility.

Joshua D. Drake

-- 
PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


-- 
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