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:

Previous
From: "frank_lupo"
Date:
Subject: shutdown postgres problem
Next
From: "frank_lupo"
Date:
Subject: shut down Postgres problem