Does anybody know if pg_xlog are essential for postgres to start? What would
happen if those files are lost, is the whole database corrupted or simply
some transactions lost?
I want to know if the following cluster setup would work:
* /dbase - contains the database itself, is on a DRBD mirror device and spread
across 2 machines.
* /dbase/pg_xlog is a symlink to /pg_log and is a local partition, not a DRBD
device
* what would happen if a failover happens, and the pg_xlog on the other
machine is empty. will postgres simply recreate those files (maybe some tx
are lost) or cant this setup work correctly?
Best regards,
Mario Weilguni