Tom Korach <tom@xxxxxxxxxxxx> writes: >> What do you mean exactly by "file-system replication"? > RAID1 setup (specifically, between two disks or EBS volumes [on AWS]), > using LVM. Maybe I'm missing something, but AFAIK plain old RAID will not protect you against any scenario except failure of a single disk. It certainly won't do anything to help you revert to a prior database state. The docs page I pointed you to is part of a chapter that lays out all the backup methods the PG community considers reliable. I strongly suggest sticking to one of those and not trying to take shortcuts. (The following chapter on high-availability setups is relevant reading as well.) regards, tom lane
