bug
Your name : Sandeep Joshi
Your email address : sjoshi@zambeel.com
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.16-3
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.3
Compiler used (example: gcc 2.8.0) : egcs-2.91.66 19990314/Linux
(egcs-1.1.2 release)
Please enter a FULL description of your problem:
------------------------------------------------
1. If I kill postmaster then if I try to restart then I get errors
saying it is
already running.
pg_ctl: It seems another postmaster is running. Try to start postmaster
anyway.
FATAL: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on that port?
If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
/work/postgres/bin/postmaster: cannot create UNIX stream port
pg_ctl: Cannot start postmaster. Is another postmaster is running?
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
pg_ctl start
ps auxww | grep postmaster
kill -9 $pid
pg_ctl start
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
pg_ctl should check whether the process and socket specified does exist
or not.
Sandeep Joshi wrote:
1. If I kill postmaster then if I try to restart then I get errors
saying it is
already running.pg_ctl start
ps auxww | grep postmaster
kill -9 $pid
pg_ctl start
It is clearly written in the docs that a server MUST NOT be killed with SIGKILL,
because there's a risk of loosing datas. If you want to kill the server, use
'kill $pid' (or if you really want to specify a signal, use SIGTERM: number 15)
FYI, the signal 9 kills an app without giving her an info, so the server cannot
exit cleanly. The signal 15 was then defined in that way : is asks the app to
terminate.
hope this helped you...