Re: Start up error

-----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-----