PostgreSQL not reading postgresql.conf file

From: "Roderick A(dot) Anderson" <raa(at)mailporter(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL not reading postgresql.conf file
Date: 2005-03-07 23:35:47
Message-ID: 422CE553.5060605@mailporter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Or at least it seems that way.

I have Pg 8.0.1 from the PGDG RPMs installed in a Linux-Vserver ( which
I have used before with Pg 7.2 and 7.3 ). I have changed the
postgresql.conf file and added/modified the listen_addresses to the
Vserver's IP. In pgstartup.log I always see these lines after every
restart.

LOG: could not bind IPv4 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
WARNING: could not create listen socket for "localhost"
LOG: logger shutting down
LOG: could not bind IPv4 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
WARNING: could not create listen socket for "localhost"
LOG: logger shutting down
LOG: could not bind IPv4 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
WARNING: could not create listen socket for "localhost"

There were(/are) some issues with localhost ( 127.0.0.1 ) and
Linux-Vservers but I have got around them before. I just can't remember
what I did. ( Good case of needing to do better documentation on my
part. :-)

The funny thing is the postmaster seems to be running

ps aux gives me

postgres 7680 0.1 0.5 16708 3036 ? S 14:49 0:02
/usr/bin/postmast
postgres 7684 0.0 0.3 6592 1984 ? S 14:49 0:00
postgres: logger
postgres 7686 0.0 0.5 16708 3084 ? S 14:49 0:00
postgres: writer

I've looked through the /etc/init.d/postgresql file and don't see
anything _odd_ so it's probably a head-space issue on my part. Clue
sticks anyone?

TIA,
Rod
--
---
[This E-mail scanned for viruses by Declude Virus]

Browse pgsql-admin by date

  From Date Subject
Next Message Angel Hernandez 2005-03-08 00:03:03 unsuscribe
Previous Message Tomeh, Husam 2005-03-07 23:33:33 PostgreSQL on Solaris Source Download