Обсуждение: Another upgrade question

Поиск
Список
Период
Сортировка

Another upgrade question

От
Michelle Murrain
Дата:
Again, I'm upgrading my Postgresql installation from a 6.5 Debian package, to
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.

Postgres is running, and I'm using the default socket. As I said, the Perl
stuff is working just dandy (I did have to upgrade to the new DBD::Pg - using
the new lib and include directories -  but that was expected and minor)

Ideas?? Thanks!

Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

Re: Another upgrade question

От
"Oliver Elphick"
Дата:
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.Elphick@lfix.co.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