I work in Win NT 4.0 using the following version:
PostgreSQL 7.2.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5
Every night, I need to shut down Postgres, using the command line
net stop postmaster
Later, the database is starting again, using the command line
net start postmaster
If some user is still connected to the database, the shut down process fails
and I find some processes "postgres.exe" still active in the server.
In order to solve the problem and make the database again starting, I kill all the "postgres.exe" processes
kill process #process number ("postgres.exe")
kill process #process number ("postgres.exe")
................
rm $PGDATA/postmaster.pid
then
net start postmaster
Looking at the log file, I see the following messages
DEBUG: pq_recvbuf: recv() failed: Connection reset by peer
DEBUG: fast shutdown request
DEBUG: aborting a
ny activ
e
transactions
FATAL 1: This connection has been terminated by the administrator.
FATAL 1: This connection has been terminated by the administrator.
DEBUG: ReceiveSharedInvalidMessages: cache state reset
FATAL 1: The database system is shutting down
DEBUG: database system was interrupted at 2003-02-06 19:52:23 WEST
DEBUG: checkpoint record is at 7/EBB80A30
DEBUG: redo record is at 7/EBB80A30; undo record is at 0/0; shutdown FALSE
DEBUG: next transaction id: 1621877; next oid: 43682810
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: redo starts at 7/EBB80A70
DEBUG: ReadRecord: record with zero length at 7/EBB98230
DEBUG: redo done at 7/EBB98208
DEBUG: database system is ready
Sometimes, the shut down process runs correctly even with some users connected.
Do you have any idea on the way to solve this problem ?
Bye !!=0
A
Frank Lupo (Wolf) !!
/\_ _/\
\ o o /
--ooo-----ooo---
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
L'ultimo capolavoro di Stephen King...con EmailConto Risparmio puoi acquistarlo ad un prezzo esclusivo. Scopri i
vantaggicliccando qui.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=836&d=7-2
