postmaster never finishes starting up, silent to boot

From: Aaron Glenn <aaron(dot)glenn(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: postmaster never finishes starting up, silent to boot
Date: 2009-03-18 05:30:58
Message-ID: 18f601940903172230m503df84eo53b54a5a27247419@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I've gotten myself in a pickle and had a postgresql (8.2) instance
fill its disk completely and shutdown itself down. I've moved the
entire data directory to a new, larger slice however postmaster never
finishes "starting". Despite configuring postgresql.conf for excessive
'verboseness' nothing gets outputted to syslog or the --log specified
file. I have a feeling I'm just not hitting the right search terms,
but shouldn't I be able to simply start a fully copied data directory
without issue? at the very least I'd expect some kind of output to
some kind of log. I have to kill it with a 'pg_ctl stop -D /mnt/data
-m i' -- immediate is the only one that actually kills it; and I get
this in syslog:

Mar 17 22:36:49 rtg postgres[1879]: [8-1] WARNING: terminating
connection because of crash of another server process
Mar 17 22:36:49 rtg postgres[1879]: [8-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar 17 22:36:49 rtg postgres[1879]: [8-3] process exited abnormally
and possibly corrupted shared memory.
Mar 17 22:36:49 rtg postgres[1879]: [8-4] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Mar 17 22:36:49 rtg postgres[1879]: [8-5] CONTEXT: xlog redo zeropage: 16645

there are no other postgres instances running on this machine;
actually there is nothing else but the OS running on this machine.

Appreciate a cluebat hit.

thanks,
aaron.glenn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe 2009-03-18 05:34:13 Re: [GENERAL] Re: Video from the 2009-03-11 SFPUG talk on Unison, by Reese Hart
Previous Message vy 2009-03-18 05:18:11 Re: Question Concerning PostgreSQL license.