Re: [GENERAL] Alternative replication method.

2003-06-25 Thread Mike Benoit
According to section 5 in this: http://www.complang.tuwien.ac.at/reisner/drbd/publications/drbd_paper_for_LK7.pdf it looks like it does guarantee write order. 5 Write ordering Some file systems require that certain blocks hit the media in a determined order, for example a JFS needs to write a t

Re: [GENERAL] Alternative replication method.

2003-06-25 Thread Tom Lane
Mike Benoit <[EMAIL PROTECTED]> writes: > Has anyone used PostgreSQL with Drbd > (http://www.complang.tuwien.ac.at/reisner/drbd/)? Does it guarantee preservation of write ordering? regards, tom lane ---(end of broadcast)---

Re: [GENERAL] Alternative replication method.

2003-06-24 Thread Jonathan Bartlett
I haven't used this. It would probably work, but there's also another way just using plain SCSI. You can attach both your main machine and a hot standby to an external RAID array. When the main machine goes down, just mount the RAID array yourself. However, you should also install a serial powe

[GENERAL] Alternative replication method.

2003-06-24 Thread Mike Benoit
Has anyone used PostgreSQL with Drbd (http://www.complang.tuwien.ac.at/reisner/drbd/)? They claim it works with PostgreSQL. Do the PostgreSQL hackers forsee any issues with this type of replication method? Do you think this method (combined with some other HA utilities) could work well as a "hot