Re: Another upgrade question

Michelle Murrain wrote:
>Again, I'm upgrading my Postgresql installation from a 6.5 Debian package, t
>o
>a 7.1 tarball on a Debian potato box.
>
>Everything has gone fairly smoothly (I had to restore each db individually -
>
>restoring a dump-all didn't work), except for one thing. My php scripts have
>
>now broken. Luckily, we're doing most everything using perl-cgi, and all of
>that is fine. But php isn't working. We've got the debian php4 packages
>installed (including php4-pgsql)
>
>The error I get is:
>Warning: Unable to connect to PostgreSQL server: connectDB() -- connect()
>failed: Connection refused
>Is the postmaster running at 'localhost' and accepting connections on Unix
>socket '5432'? This is the standard error if php can't find the postmaster.

The php packages probably expect to find the socket in the Debian location:
/var/run/postgresql, since they will be linked with the Debian package
libpgsql2.1. Either rebuild them as well, or create a dummy libpgsql2.1
package that points to your own version, or make a symlink from that
directory to /tmp.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Draw nigh to God, and he will draw nigh to you.
Cleanse your hands, ye sinners; and purify your
hearts, ye double minded." James 4:8