From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Dimitri Fontaine" <dimitri(at)2ndQuadrant(dot)fr>
Cc:
"Josh Berkus" <josh(at)agliodbs(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:
Re: postgresql.conf archive_command example
Date:
2011-09-02 20:10:30
Message-ID:
4E60F1E60200002500040B89@gw.wicourts.gov (view raw or flat )
Thread:
2011-08-30 18:39:15 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-08-30 18:45:18 from Brendan Jurd <direvus(at)gmail(dot)com>
2011-08-31 09:18:54 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-08-31 19:27:06 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-08-31 22:17:18 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-09-01 08:14:45 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-09-01 11:06:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-01 19:05:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-09-01 19:26:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-02 08:01:09 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-09-02 14:34:34 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-02 14:53:50 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-09-02 17:00:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-02 17:10:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-09-02 17:13:46 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-02 17:16:35 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-09-02 17:10:48 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-02 19:29:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-09-02 19:38:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-09-02 19:50:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-09-02 20:10:30 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-02 20:20:24 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-09-02 20:42:45 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-07 02:11:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-07 14:53:57 from Robert Treat <rob(at)xzilla(dot)net>
2011-09-08 06:05:48 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-08 06:26:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-09-08 07:08:08 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-09-08 13:09:37 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2011-09-08 13:47:35 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-09-09 18:59:43 from Florian Pflug <fgp(at)phlo(dot)org>
2011-09-09 19:11:41 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2011-09-10 08:29:26 from Andres Freund <andres(at)anarazel(dot)de>
2011-09-02 19:40:15 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Lists:
pgsql-hackers
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> wrote:
> I think the solution to that problem is to provide a default
> archive command that just does the very simple thing, namely
> moving the WAL file to some place given as parameter. Some
> *local* mount point.
I think we've been mostly in agreement, but I have a few quibbles or
clarifications to that:
(1) We're talking about a new /bin executable to do this which
could be referenced in an archive_command string or run from a
script called by archive_command, right?
(2) It should copy, not move, with protection against overwriting
an existing file.
(3) Maybe not in the initial version, but eventually it might be
nice to support URLs of some known protocols in addition to local
directories.
(4) Maybe not in the initial version, but eventually it might be
nice to support checking for an "owner" file of some sort in the
target directory, to help sort out problems with copied databases
writing to the same location as the source.
-Kevin
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2011-09-02 20:11:27Subject : Re: pg_upgrade automatic testingPrevious :From : Tom LaneDate : 2011-09-02 20:04:48Subject : Re: PATCH: regular logging of checkpoint progress
