Thread: Error while restoring data

Hi all,

I'm upgrading to 7.3 from 7.2 and while restoring data, I got this error
message:

pg_restore: [archiver (db)] could not execute query: ERROR:  stat failed
on file '$libdir/pgcrypto': No such file or directory

I'm using the RPM's built for RH 8.0 on a RH 7.3 machine. I'm sure its
something really simple and stupid :-)

- Ericson Smith
eric@did-it.com

Looking at gcc on the box, it is:
> gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

Any other suggestions?

- Ericson

On Mon, 2002-12-16 at 13:24, Fred Moyer wrote:
> The rpms for rh8 are dependent on gcc3.2
> Fred Moyer
> Digital Campaigns, Inc.
> 415-504-8206

Ericson Smith <eric@did-it.com> writes:

> Hi all,
>
> I'm upgrading to 7.3 from 7.2 and while restoring data, I got this error
> message:
>
> pg_restore: [archiver (db)] could not execute query: ERROR:  stat failed
> on file '$libdir/pgcrypto': No such file or directory
>
> I'm using the RPM's built for RH 8.0 on a RH 7.3 machine. I'm sure its
> something really simple and stupid :-)

Did you install the pg-contrib RPM?

-Doug

Ericson Smith writes:

> pg_restore: [archiver (db)] could not execute query: ERROR:  stat failed
> on file '$libdir/pgcrypto': No such file or directory

Move the pgcrypto.so file into the right place (for the new installation)
or edit the dump to omit it.

--
Peter Eisentraut   peter_e@gmx.net