From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Simon Riggs <simon(at)2ndQuadrant(dot)com>,
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: pg_ctl idempotent option
Date:
2013-01-29 21:34:50
Message-ID:
5108407A.3020408@gmx.net (view raw or flat )
Thread:
2013-01-14 11:37:58 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-14 15:22:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-14 15:29:53 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-14 15:47:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-15 10:14:36 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2013-01-14 15:48:57 from Thom Brown <thom(at)linux(dot)com>
2013-01-28 15:40:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-29 02:29:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-29 02:47:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-29 05:19:15 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-01-29 06:32:58 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
2013-01-29 12:57:03 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-30 05:07:45 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-01-30 21:35:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-29 16:03:39 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-29 21:34:50 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-29 22:03:08 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-14 16:49:49 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-15 10:26:28 from Vik Reykja <vikreykja(at)gmail(dot)com>
2013-01-15 12:53:21 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-15 15:25:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-15 19:28:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-15 19:36:39 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-15 15:51:53 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-15 16:06:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-19 01:48:08 from Phil Sorber <phil(at)omniti(dot)com>
2013-01-21 15:54:41 from Phil Sorber <phil(at)omniti(dot)com>
2013-01-22 12:33:28 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
2013-01-23 18:56:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-23 19:00:25 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-23 19:06:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-24 03:35:59 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
2013-01-24 13:06:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-15 15:55:41 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-15 19:29:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-15 23:48:16 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2013-01-15 20:50:09 from Josh Berkus <josh(at)agliodbs(dot)com>
2013-03-06 04:37:17 from Peter Eisentraut <peter_e(at)gmx(dot)net>
Lists:
pgsql-hackers
On 1/28/13 9:29 PM, Bruce Momjian wrote:
> pg_upgrade uses that to find out of the server was already running or if
> we started it. This is to start the server to remove the
> postmaster.pid file.
It's currently a bit missed up anyway. pg_ctl start is successful if
the server is already started, but pg_ctl -w start fails.
What pg_upgrade is doing doesn't sound particularly safe, for example
when something is concurrently starting or stopping the server.
> Also, no one has explained how not knowing if -o
> options were used was a safe.
Hmm, good point. But we already have this problem -- see above.
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2013-01-29 22:03:08
Subject : Re: pg_ctl idempotent option
Previous :From : Marko TiikkajaDate : 2013-01-29 20:37:12
Subject : Re: pg_dump --pretty-print-views