Re: shutdown postgres problem - Mailing list pgsql-cygwin
From | Igor Georgiev |
---|---|
Subject | Re: shutdown postgres problem |
Date | |
Msg-id | 006101c2ce9d$391d3d00$0b0546c0@alpha.bg Whole thread Raw |
In response to | shutdown postgres problem ("frank_lupo" <frank_lupo@email.it>) |
List | pgsql-cygwin |
For diferent shutdown modes use SMART_SHUTDOWN : kill -s TERM "Smart" mode waits for all the clients to disconnect FAST_SHUTDOWN : kill -s INT "Fast" mode does not wait for clients to disconnect IMMEDIATE_SHUTDOWN : kill -s QUIT "Immediate" mode will abort all server processes without clean shutdown. This will lead to a recovery run on restart. RELOAD : kill -s HUP Take a look here - this is a windows console for PostgreSQL http://gborg.postgresql.org/project/winmaster/projdisplay.php ----- Original Message ----- From: "frank_lupo" <frank_lupo@email.it> To: "pgsql-cygwin" <pgsql-cygwin@postgresql.org> Sent: Friday, February 07, 2003 11:10 AM Subject: [CYGWIN] shutdown postgres problem > 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 any active t > ransacti > o > ns > 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 ? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
pgsql-cygwin by date: