From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Geoffrey <lists(at)serioustechnology(dot)com> |
Cc: | Erik Jones <ejones(at)engineyard(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: warm standby with WAL shipping |
Date: | 2009-06-03 18:53:55 |
Message-ID: | 1244055235.10620.24.camel@jd-laptop.pragmaticzealot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2009-06-03 at 14:43 -0400, Geoffrey wrote:
>
> > pg_standby is in no way dependent on PITRTools. PITRTools is, however,
> > dependent on pg_standby. Put another way: you do not need to use
> > PITRTools to use pg_standby. In fact, you also don't need any perl or
> > shell scripts to use pg_standby, just use rsync directly in the
> > archive_command on the master and pg_standby in the recovery_command on
> > the standby. The wiki link Greg provided
> > (http://wiki.postgresql.org/wiki/Warm_Standby) has all of the info
> > needed to set things up manually.
>
> Our current scenario is that we are archiving from machine A to machine
> B. Our hot spare is machine C, thus we are pulling the files via
> network from machine B to machine C, hence the reason I don't believe
> db_standby will work as it has no facility (rsync,scp) to retrieve the
> files from another machine.
The point that is being made is that pg_standby doesn't need pitrtools
to do its job. That is all. It is also why I said that pg_standby is
just a component of a PITR solution and not a PITR Solution in itself.
You are still going to need to either:
A. Reinvent the wheel, by scripting it all yourself
B. Use solutions that are already used by others such as walmgr or
pitrtools
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Jaśkiewicz | 2009-06-03 18:57:27 | Re: Upgrading Database: need to dump and restore? |
Previous Message | Louis Lam | 2009-06-03 18:46:00 | Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role |