Skip site navigation (1) Skip section navigation (2)

Re: Start up error

From: tomas(at)tuxteam(dot)de
To: Hussain Jawad-FXRM43 <FXRM43(at)motorola(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Start up error
Date: 2007-11-17 11:42:50
Message-ID: 20071117114250.GA4006@www.trapp.net (view raw or flat)
Thread:
Lists: pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Nov 17, 2007 at 08:19:37AM +0800, Hussain Jawad-FXRM43 wrote:
> Hello Sir,
>  
> I have installed postgresql DB on my Linux server.
>  
> When I am trying to stop and start the DB, below error is reported in
> postgresql start up log file.
>  
> FATAL:  lock file "postmaster.pid" already exists
> HINT:  Is another postmaster (PID 25372) running in data directory
> "/var/lib/pgsql/data"?
> FATAL:  lock file "postmaster.pid" already exists
> HINT:  Is another postmaster (PID 25372) running in data directory
> "/var/lib/pgsql/data"?

This doesn't look like a PostgreSQL bug. I'd suggest to post such
questions in other mailing lists. Have a look at

  <http://www.postgresql.org/community/lists/>

especially pgsql-general or pgsql-novice

> I have deleted the file postmaster.pid in the directory
> /var/lib/pgsql/data for number of times and restarted the postgresql
> service, but I am still not able to restart the server and the same
> error is repeating again.

- From your mail I gather that this postmaster.pid "appears" every time
you start the service. Things to check:

  (1) are you really sure the service is not running?
    (try e.g. ps wwaux | grep postmaster).

  (2a) if the answer to (1) is "service is not running", that would
      mean that the postmaster process starts, creates the PID file
      and dies unexpectedly. In this case: have you had a look at
      the relevant log files (typically in /var/log/postgresql --
      but it depends on distribution).

  (2a) if the answer to (1) is "is running", but your clients are not
      able to connect, perhaps the server is listening just on an unix
      domain socket while the clients are trying to contact it via an
      Internet socket.

HTH.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFHPtO6Bcgs9XrR2kYRAiEAAJ4gt/IKJSHvB4kJmADWChXmXdwtSgCfW52W
CiMqL1XXWgcN2X0Wi+7wumI=
=g8Jw
-----END PGP SIGNATURE-----


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-11-17 16:17:36
Subject: Re: Start up error
Previous:From: Hussain Jawad-FXRM43Date: 2007-11-17 00:19:37
Subject: Start up error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group