Re: pg_xlog question
От | Shridhar Daithankar |
---|---|
Тема | Re: pg_xlog question |
Дата | |
Msg-id | 3F30FC65.319.4761DA7@localhost обсуждение исходный текст |
Ответ на | Re: pg_xlog question ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>) |
Список | pgsql-general |
On 6 Aug 2003 at 12:52, Shridhar Daithankar wrote: > On 6 Aug 2003 at 8:36, Mario Weilguni wrote: > > > 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? > > I doubt. It might end up with some transaction uncommittied in files. > > If you could replicate/rsync pg_xlog to another machine, you could get it > correctly in case of failover. Argh.. I forgot.. Simple option is to sync the pg_xlog while doing failover. It might add some 10 odd sec to failover process but should be bullet proof.. I don't know if PG is nose poking about permissions of those files. otheriwse it might refuse to start.. Check out.. Worth adding to failover HOWTO. I doubt if one exists for postgresql. Bye Shridhar -- Do you know about being with somebody? Wanting to be? If I had thewhole universe, I'd give it to you, Janice. When I see you, I feellike I'm hungry all over. Do you know how that feels? -- Charlie Evans, "Charlie X", stardate 1535.8
В списке pgsql-general по дате отправления: