Upgrade woes

From: "Greg Kelley" <gkelley(at)britannicaviation(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Upgrade woes
Date: 2003-04-15 12:03:17
Message-ID: 000501c30347$00474d20$3501a8c0@greg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-04-15 13:56:16 Re: Upgrade woes
Previous Message Joe Conway 2003-04-15 03:23:22 Re: Stored Procedure Error