Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-25 Thread Marcin Mańk
> On Wed, Jul 25, 2012 at 6:38 AM, Martin Pitt wrote: >> http://anonscm.debian.org/loggerhead/pkg-postgresql/postgresql-common/trunk/revision/1181 > http://anonscm.debian.org/loggerhead/pkg-postgresql/postgresql-common/trunk/annotate/1181/pg_ctlcluster I still see some pid file unlinking there.

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-25 Thread Marcin Mańk
I privately pointed Martin Pitt (Debian maintainer) to this discussion, his response below. Martin, I believe what happened is: the original complainer did /etc/init.d/postgresql restart this called pg_ctlcluster --force restart this effectively did: pg_ctlcluster --force stop (which removed the p

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-24 Thread Tom Lane
Scott Marlowe writes: > On Tue, Jul 24, 2012 at 7:48 AM, Craig Ringer wrote: >>> # if that still not helps, use the big hammer >>> if (-f $info{'pgdata'}.'/postmaster.pid') { >>> print "(does not shutdown, killing the process)"; >>> $pid = get_running_pid $info{'pg

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-24 Thread Scott Marlowe
On Tue, Jul 24, 2012 at 7:48 AM, Craig Ringer wrote: > On 07/24/2012 05:31 PM, Marcin Mańk wrote: > > On Tue, Jul 24, 2012 at 3:16 AM, Craig Ringer wrote: >>> >>> It shouldn't matter - only PostgreSQL was restarted, not the whole >>> machine - and cleanly at that. Very strange. > > # if t

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-24 Thread Craig Ringer
On 07/24/2012 05:31 PM, Marcin Mańk wrote: On Tue, Jul 24, 2012 at 3:16 AM, Craig Ringer > wrote: It shouldn't matter - only PostgreSQL was restarted, not the whole machine - and cleanly at that. Very strange. # if that still not helps, use

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-24 Thread Marcin Mańk
On Tue, Jul 24, 2012 at 3:16 AM, Craig Ringer wrote: > It shouldn't matter - only PostgreSQL was restarted, not the whole machine >> - and cleanly at that. Very strange. > > > look at pg_ctlcluster, (which does the restart): if (!fork()) { close STDOUT; exec $pg_

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-23 Thread Craig Ringer
On 07/24/2012 08:48 AM, Jeff Davis wrote: On Thu, 2012-07-19 at 11:35 +0800, Craig Ringer wrote: The short version is that the person did a bulk-load of some PostGIS data using the osm2pgsql data-loader tool ( http://wiki.openstreetmap.org/wiki/Osm2pgsql) to populate a Pg 9.1 database. This appe

Re: [GENERAL] Odd corruption issue reported on dba.stackexchange.com, need advice

2012-07-23 Thread Jeff Davis
On Thu, 2012-07-19 at 11:35 +0800, Craig Ringer wrote: > The short version is that the person did a bulk-load of some PostGIS > data using the osm2pgsql data-loader tool > ( http://wiki.openstreetmap.org/wiki/Osm2pgsql) to populate a Pg 9.1 > database. This appeared to succeed, but when the server