| From: | Mario Weilguni <mweilguni(at)sime(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_xlog question |
| Date: | 2003-08-06 06:36:25 |
| Message-ID: | 200308060836.25070.mweilguni@sime.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2003-08-06 06:48:28 | Re: indices and cidr/inet type |
| Previous Message | Bjorn T Johansen | 2003-08-06 05:54:48 | Column number 4 is out of range 0..3 ? |