After changing the IP address of the computer, and forgotten to adjust the listen_address in /var/lib/postgresql/8.3/data/postgresql.conf - postgres naturally failed to start. But the start script reports some generic error: # /etc/init.d/postgresql-8.3 start * Starting PostgreSQL ... waiting for server to start...............................................................could not start server [ !! ] * The pid-file doesn't exist but pg_ctl reported a running server. * Please check whether there is another server running on the same port or read the log-file. Reproducible: Always Steps to Reproduce: 1. change the IP in config file to something different than the IP you are using 2. 3. Actual Results: Generic start message is displayed that postgresql can't start. Expected Results: Display the same error message that is displayed when you manually call /usr/bin/pg_ctl or have the correct error message in /var/log/messages or similar. If you start manually - the real reason is seen: (as postgres user) /usr/bin/pg_ctl start -D /var/lib/postgresql/8.3/data LOG: could not bind IPv4 socket: Cannot assign requested address HINT: Is another postmaster already running on port 53891? If not, wait a few seconds and retry. WARNING: could not create listen socket for "10.0.0.95" FATAL: could not create any TCP/IP sockets
Addressed in bug #311047
Committed
