[SoCoSA/discuss] PostgreSQL Replication?

[Rob Clark]

You'd want to LVM to an appliance w/ storage and cordinate snapshots
w/ a pSQL agent.  The appliance would replicate to another appliance
at the DR site where you could SAN boot if desired.


On 12/13/07, Kevan Benson <kbenson at a-1networks.com> wrote:
>
> Hmm.
>
> LVM+Snapshots+rsync from snapshot = poor man's NAS with snapshots?
>
> Rob Clark 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
> >>
> >
> >
> >
>
>
> --
>
> -Kevan Benson
> -A-1 Networks
>
> _______________________________________________
> 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