[NBLUG/talk] [SoCoSA/discuss] PostgreSQL Replication?

Augie Schwer augie.schwer at gmail.com
Thu Dec 13 05:48:20 PST 2007


OK, that gives me a place to start; thanks for the feedback.  --Augie

On Dec 12, 2007 5:36 PM, Rob Clark <robintclark at gmail.com> wrote:
> The preferred method is to off-load the replication to an appliance
> (storage) that allows for snapshots and delta replication.  That way if you
> corrupt data at your primary site you will have the ability to recover to a
> known good point in time at your DR site and be up and running in a few
> minutes rather than hours/days.  This method also relieves your pSQL server
> from any of the replication burden.
>
>
> On Dec 12, 2007 3:04 PM, Augie Schwer <augie.schwer at gmail.com> wrote:
>
> > How are people doing PostgreSQL replication?
> >
> > Looking around on the web it seems that there is no built in way to do
> > PostgreSQL replication and that there are several third party tools,
> > so my question is: what way is the best way?
> >
> > The point of this would be to do live backups and have a stand by
> > server in case I needed it.
> >
> > Any suggestions?
> >
> >
> > --
> > Augie Schwer    -    Augie at Schwer.us    -    http://schwer.us
> > Key fingerprint = 9815 AE19 AFD1 1FE7 5DEE 2AC3 CB99 2784 27B0 C072
> >
> > _______________________________________________
> > SoCoSA discuss mailing list
> > discuss at socosa.org
> > Your address: robintclark at gmail.com
> > http://socosa.org/mailman/listinfo/discuss
> > http://socosa.org/mailman/options/discuss/robintclark%40gmail.com
> >
>
>
>
> --
> Rob Clark
> robintclark at gmail.com
> _______________________________________________
> SoCoSA discuss mailing list
> discuss at socosa.org
> Your address: augie.schwer at gmail.com
> http://socosa.org/mailman/listinfo/discuss
> http://socosa.org/mailman/options/discuss/augie.schwer%40gmail.com
>



-- 
Augie Schwer    -    Augie at Schwer.us    -    http://schwer.us
Key fingerprint = 9815 AE19 AFD1 1FE7 5DEE 2AC3 CB99 2784 27B0 C072



More information about the talk mailing list