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
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. |