The following bug has been logged online:
Bug reference: 3745
Logged by: Jawad Hussain
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: Linux
Description: I am unable to load the data in postgresql DB
Details:
Below is the error log I am getting repeatedly in the file pgstartup.log.
WARNING: could not create listen socket for "localhost"
FATAL: could not create any TCP/IP sockets
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
LOG: logger shutting down
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"?
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"?
LOG: logger shutting down
FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster (PID 9346) running in data directory
"/var/lib/pgsql/data"?
FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster (PID 9346) running in data directory
"/var/lib/pgsql/data"?
Please suggest on this.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
