Upgrade woes
От | Greg Kelley |
---|---|
Тема | Upgrade woes |
Дата | |
Msg-id | 000501c30347$00474d20$3501a8c0@greg обсуждение исходный текст |
Ответы |
Re: Upgrade woes
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: