| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Lou Picciano <loupicciano(at)comcast(dot)net> |
| Cc: | jd(at)commandprompt(dot)com, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: binary logs: a location other than pg_xlog?? |
| Date: | 2010-11-22 05:11:47 |
| Message-ID: | 4788.1290402707@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Lou Picciano <loupicciano(at)comcast(dot)net> writes:
> Sure - of course - performance, too! It just seems like such an obvious candidate for a configurable option; I'm a bit surprised it isn't in there... L
It *is* configurable: make pg_xlog a symlink. The reason we don't
handle this via postgresql.conf is that you could too easily shoot
yourself in the foot by breaking the link between a data directory
and its xlogs. There are no postgresql.conf entries that say
destroy_all_my_data_immediately_please = on
but that's more or less what an easily changeable pg_xlog pointer
would be.
In short: this is not something to change if you don't know what
you're doing. If you do, you should be able to handle it using
the mechanism provided.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukasz Brodziak | 2010-11-22 07:18:53 | Re: Zeroing single tuple in data file. |
| Previous Message | Lou Picciano | 2010-11-22 03:37:14 | Re: binary logs: a location other than pg_xlog?? |