From: | Sandeep Joshi <sjoshi(at)Zambeel(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | bug |
Date: | 2000-12-21 02:19:16 |
Message-ID: | 3A4168A4.E3589F05@zambeel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Your name : Sandeep Joshi
Your email address : sjoshi(at)zambeel(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2000-12-21 16:35:00 | postgresql process crashes on select * from cmd_sm (which is a view) |
Previous Message | Tom Lane | 2000-12-20 20:12:14 | Re: Re: Table name scope (was Re: [BUGS] Outer joins aren't working with views) |