| From: | "Martin Fandel" <martin(dot)fandel(at)alphyra-evs(dot)de> |
|---|---|
| To: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: replication for hot-standby? |
| Date: | 2005-07-02 11:28:51 |
| Message-ID: | 1120303732.24725.5.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kishore B | 2005-07-02 12:01:58 | Help needed to set the Optimal Value for shared_buffers. |
| Previous Message | Joel Fradkin | 2005-07-01 18:30:11 | Re: encoding converting from ascii to unicode (I got it |