[Pkg-postgresql-private] Re: postgresql-client: pg_dump from 7.2.x does not restore cleanly

Martin Pitt martin@piware.de
Sun, 28 Mar 2004 00:51:30 +0100


--GvXjxJ+pjyke8COw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi!

On 2003-02-13  7:04 +1300, Andrew McMillan wrote:
> Package: postgresql-client
> Version: 7.3.2-2
> Severity: normal
>=20
> It seems that the location of some libraries has changed from version
> 7.2 to 7.3, and that now a pg_restore will not load cleanly into a 7.3
> database, returning the following error:
>=20
> pg_restore: [archiver (db)] could not execute query: ERROR:  stat failed =
on file '$libdir/plpgsql': No such file or directory
>=20
> This appears to be easily worked around by adding a symbolic link in
> /usr/lib/postgresql to /usr/lib/postgresql/lib/plpgsql.so, at which
> point the restore will function perfectly.

It seems that this is the same bug as #180776 (which is marked fixed
becuase there's an explanation in it) and #175566 (closed long ago).
So it seems that this can be closed as well.

What do you think?

Thanks and have a nice day!

Martin
--=20
Martin Pitt                 Debian GNU/Linux Developer
martin@piware.de                      mpitt@debian.org
http://www.piware.de             http://www.debian.org

--GvXjxJ+pjyke8COw
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAZhN/DecnbV4Fd/IRAu1PAJ0fNj7Cd4AWFHMsYoHA9FYEj+SkuwCg98w/
MzPf5yXixTEV8RzLU1cboEs=
=6iI3
-----END PGP SIGNATURE-----

--GvXjxJ+pjyke8COw--