Upgrade woes

Поиск
Список
Период
Сортировка
От Greg Kelley
Тема Upgrade woes
Дата
Msg-id 000501c30347$00474d20$3501a8c0@greg
обсуждение исходный текст
Ответы Re: Upgrade woes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Stored Procedure Error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Upgrade woes