| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | PostgreSQL <Pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_archive_bypass |
| Date: | 2010-06-14 10:39:32 |
| Message-ID: | 87631lc2zf.fsf@hi-media-techno.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I tend to consider it a bug that there's no known way under windows to
use the same trick as under Unix by using '/usr/bin/true' as your
archive command. And this Unix trick itself does feel like a hack.
Also I'd very much like to be able to recommend (even if not change the
official defaults) to setup wal_level to archive, archive_mode=on and
archive_command=pg_archive_bypass, so that the day you have a HA budget
ain't the day you're going to restart the server to enable the fault
tolerance settings…
So please find attached a very simple "let's see about it" patch to
implement an internal archive_command that just returns true and is
called pg_archive_bypass. It's missing documentation, which I'll provide
if needed (meaning there's some will to consider applying such a patch).
Regards,
--
dim
| Attachment | Content-Type | Size |
|---|---|---|
| pg_archive_bypass.diff | text/x-diff | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-06-14 10:57:39 | Re: pg_dump(all) --quote-all-identifiers |
| Previous Message | Magnus Hagander | 2010-06-14 10:21:41 | Re: warning message in standby |