Thread: 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...