From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>,
Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>,
Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: postgresql.conf archive_command example
Date:
2011-09-02 19:29:05
Message-ID:
23395.1314991745@sss.pgh.pa.us (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
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> Another thought I have here is to wonder whether we should change
> something on the server side so that we don't NEED such a complicated
> archive_command. I mean, copying a file to a directory somewhere is
> not fundamentally a complex operation. Nor is using ssh to copy it to
> another machine.
It is once you consider error handling and catering to N combinations of
user requirements.
I think the notion that we should get rid of archive_command in favor of
something more hard-wired is sheer lunacy. We have a nicely decoupled
arrangement for dealing with these issues now; why would we want to pull
them into the server?
Now, providing a more useful sample script is certainly reasonable.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2011-09-02 19:38:30Subject : Re: CF2011-09Previous :From : Tom LaneDate : 2011-09-02 19:23:07Subject : Re: PATCH: regular logging of checkpoint progress
