John R Pierce <pierce@xxxxxxxxxxxx> writes: >>> Two DB servers will be using a common external storage (with raid). > > This is also one of the only postgres HA configurations that won't lose > /any/ committed transactions on a failure. Most all PITR/WAL > replication/Slony/etc configs, the standby storage runs several seconds > behind realtime. I'm not clear on what error case it protects against, though. Either the data is ok and a single PostgreSQL system will restart fine, or the data isn't and you're hosed the same with or without the second system. What's left is hardware failure that didn't compromise the data. I didn't see much hardware failure yet, granted, but I'm yet to see a motherboard, some RAM or a RAID controller failing in a way that leaves behind data you can trust. So my question would be, what case do you handle better with a shared external storage compared to shared nothing servers with some sort of replication (including WAL shipping)? Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
