what happens?
valter.
[i've done vacuum analyze while query are running... vacuum stopped at some
point, then i've decided to ctrl-c, then killed postmaster]
-------------------------------------
postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ stop
Smart Shutdown request at Fri Jan 12 05:46:11 2001
postmaster successfully shut down.
postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ start
pg_ctl: It seems another postmaster is running. Trying to start postmaster
anyway.
Lock file "/usr/pg71/data//postmaster.pid" already exists.
Is another postmaster (pid 11320) running in "/usr/pg71/data/"?
pg_ctl: Cannot start postmaster. Is another postmaster is running?
postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ restart
Waiting for postmaster to shut down.........................
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
Startup failed - abort
done.
postmaster successfully shut down.
postmaster successfully started up
postgres@lora:~$ /usr/pg71/bin/postmaster: invalid argument -- '-D'
Try '/usr/pg71/bin/postmaster --help' for more information.
postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ start
postmaster successfully started up
postgres@lora:~$ DEBUG: starting up
DEBUG: database system was interrupted being in recovery at 2001-01-12
05:45:33This propably means that some data blocks are corruptedand you will have to use last backup for recovery.
DEBUG: CheckPoint record at (0, 107606368)
DEBUG: Redo record at (0, 107467584); Undo record at (0, 107484188);
Shutdown FALSE
DEBUG: NextTransactionId: 46738; NextOid: 59680
DEBUG: database system was not properly shut down; automatic recovery in
progress...
DEBUG: redo starts at (0, 107467584)
FATAL 2: out of free buffers: time to abort !
postgres@lora:~$
postgres@lora:~$
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
Startup failed - abort
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.