Error while restoring data

Started by Ericson Smithover 23 years ago4 messagesgeneral
Jump to latest
#1Ericson Smith
eric@did-it.com

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

#2Ericson Smith
eric@did-it.com
In reply to: Ericson Smith (#1)
Re: Error while restoring data

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

Show quoted text

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

#3Doug McNaught
doug@mcnaught.org
In reply to: Ericson Smith (#1)
Re: Error while restoring data

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

#4Peter Eisentraut
peter_e@gmx.net
In reply to: Ericson Smith (#1)
Re: Error while restoring data

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