From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Robert Treat <rob(at)xzilla(dot)net>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Josh Berkus <josh(at)agliodbs(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <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-08 07:08:08
Message-ID:
CAHGQGwG_KcHHRYpdtETOTz7Mti9SuGBWhGjgdc_4EnmTW9gDJg@mail.gmail.com (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
On Thu, Sep 8, 2011 at 3:26 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Thu, Sep 8, 2011 at 7:05 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> That's an option. But I don't think that finding an existing file is so serious
>> problem.
>
> The recommendation should be that the archived files are never
> overwritten because that prevents a huge range of data loss bugs and
> kills them stone dead.
I'm OK with that default behavior of the executable. It's helpful if
the executable
supports overwrite-if-filesize-is-not-16MB option.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-hackers by date
Next :From: Fujii MasaoDate: 2011-09-08 08:36:38Subject : pg_last_xact_insert_timestampPrevious :From : davegDate : 2011-09-08 06:35:29Subject : Re: FATAL: lock AccessShareLock on object 0/1260/0 is already held
