Folks,
Upgraded RH8.0 to 9.0 last saturday. Then pgsql woldn't start - failed using
the /etc/rc.d/init.d script so I manually entered the command and discovered
that it had to fix the database due to not shutting down properly(???). Now
it starts just fine, but I can't connect.
data dir is:
/var/lib/pgsql/data
ps shows:
postgres 10783 0.0 0.3 9776 1984 pts/1 S /usr/bin/postmaster -p
5432
postgres 10784 0.0 0.3 10768 1952 pts/1 S postgres: stats buffer
process
postgres 10785 0.0 0.3 9800 1964 pts/1 S postgres: stats collector
process
Test command is:
psql -h localhost -U postgres
Error is:
psql: could not connect to server: Connection refused
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?
pg_hba.conf shows:
local all
trust
host all 127.0.0.1 255.255.255.255 trust
I also can't seem to find the postmaster log file...?
Thanks for any suggestions to get this going again! We have an online
scheduling system that is down for the count.
Rgds,
________________________
Greg Kelley, IT Director
Britannic Aviation, US and UK
US Office:
Pease Int'l Tradeport
68 New Hampshire Ave.
Portsmouth, NH 03801
603.766.3005
http://www.britannicaviation.com
AOPA, EAA, SSA
CFII SEL, MEL; Comm Glider
