From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: recovery_connections cannot start
Date:
2010-04-26 10:29:19
Message-ID:
u2h603c8f071004260329t13cf584bqf1d687a68df2a8f9@mail.gmail.com (view raw or flat )
Thread:
2010-04-22 16:04:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 00:03:43 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-04-23 09:24:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-23 10:44:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 11:12:12 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-23 11:21:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 11:40:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-23 11:54:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 12:28:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-04-23 16:24:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 16:09:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 17:45:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 18:09:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 18:21:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-23 18:36:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 18:40:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 18:43:47 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-04-23 19:05:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 19:11:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 19:18:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 19:34:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 20:04:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 20:11:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-26 10:28:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-26 12:06:29 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2010-04-23 20:10:54 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-23 20:31:50 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 20:50:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-04-23 20:50:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 21:26:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 22:42:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 21:29:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 21:38:01 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-26 12:05:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-04-26 13:03:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-26 14:23:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-26 14:41:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-26 18:15:58 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-04-26 19:12:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 21:43:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 22:03:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 22:46:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-26 08:41:30 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-04-26 10:08:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-26 10:29:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-27 08:07:11 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-04-27 11:11:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-27 13:10:44 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-04-27 13:20:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-27 14:52:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 22:30:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 23:04:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 23:07:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 23:08:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 23:12:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 23:22:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-23 23:28:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 23:33:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-24 00:00:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-24 00:11:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-04-24 09:32:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 19:38:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 19:56:17 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-04-23 20:05:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 19:57:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 19:23:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-04-23 18:55:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-04-23 11:43:19 from Florian Pflug <fgp(at)phlo(dot)org>
Lists:
pgsql-hackers
On Mon, Apr 26, 2010 at 6:08 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Mon, 2010-04-26 at 10:41 +0200, Dimitri Fontaine wrote:
>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> > The only workable
>> > alternative I can see to keeping archive_mode is to tell people to
>> > set archive_command to something like /usr/bin/true ... which is not
>> > simpler, especially not on Windows.
>>
>> Would it be possible to have "internal" commands there, as for example
>> cd is in my shell, or test, or time, or some more ?
>>
>> That would allow for providing a portable /usr/bin/true command as far
>> as archiving is concerned (say, pg_archive_bypass), and will allow for
>> providing a default archiving command in the future, like "pg_archive_cp
>> /location" or something.
>
> I think making a special case here is OK.
>
> If command string == 'true' then we don't bother to call system(3) at
> all, we just assume it worked fine.
>
> That way we have a simple route on all platforms.
Separating wal_mode and archive_mode, as we recently discussed, might
eliminate the need for this kludge, if archive_mode can then be made
changeable without a restart.
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-04-26 10:54:23Subject : Re: don't allow walsender to consume superuser_reserved_connection slots, or during shutdownPrevious :From : Robert HaasDate : 2010-04-26 10:28:06Subject : Re: recovery_connections cannot start (was Re: master in standby mode croaks)
