Re: Upgrade woes

On Tuesday 15 April 2003 09:56, Tom Lane wrote:
> "Greg Kelley" <gkelley(at)britannicaviation(dot)com> writes:
> > 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.

> > psql: could not connect to server: Connection refused

> This is a kernel-level refusal. Check your packet filtering setup --- I
> bet you have traffic to port 5432 filtered out :-(

Which is very easy to do with Red Hat Linux, since the install or upgrade
defaults to 'medium' security on the netfilter config. Which is set to block
5432 by default; not on localhost, though, IIRC.

However, there's something very disturbing here. Greg, what version of
PostgreSQL were you running on RH8? RH8 shipped with 7.2.2, with an errata
to 7.2.4. Did you upgrade to 7.3.x at some point?

Tom, if he was running 7.2.x prior, the initscript is programmed to prevent
starting postmaster if the database structure is too old. Why did postmaster
subsequently startup when started manually, if he was running 7.2.x prior?

I sincerely hope you had upgraded to 7.3.x prior to upgrading to RHL 9, or we
have something very bad going on here.

Since you are attempting to connect to localhost, why not just let it use the
Unix domain socket (by not specifying the hostname) and see if that connects?
This will tell us whether netfilter is interposing itself.

Greg, if you were running 7.2.x prior, RPMs for 7.2.4 built on RHL9 are
available by FTP from ftp.postgresql.org, in /pub/binary/v7.2.4/RPMS/redhat-9

Please let us know what you have found out.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11