bug

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.

Responses

  • Re: bug at 2000-12-21 18:37:13 from Chris

Browse pgsql-bugs by date

  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)