Re: replication for hot-standby? - Mailing list pgsql-admin

From Martin Fandel
Subject Re: replication for hot-standby?
Date
Msg-id 1120303732.24725.5.camel@localhost.localdomain
Whole thread Raw
In response to replication for hot-standby?  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-admin
Hi,

maybe filesystem-snapshots with wal's are your solution. There
is a block-device replication-tool too. It's called drbd
(http://www.drbd.org). I never tested/used it, but i heard it
should be fine.

I'm using rsync/xfs_freeze to make incremental filesystem-snapshots
(incremental by hardlinks). This works fine/reliable for me :).

best regards,

Martin

Am Freitag, den 01.07.2005, 15:51 +0200 schrieb Hannes Dorbath:
> I need something that is able to replicate schema changes as well, so
> Slony seems out of the game :/
>
> pg_cluster?
> mammoth postgresql?
> db_mirror?
>
> What to use for a hot-standby box?
>
> Thanks in advance
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-admin by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Re: encoding converting from ascii to unicode (I got it
Next
From: Kishore B
Date:
Subject: Help needed to set the Optimal Value for shared_buffers.