470,581 Members | 2,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

problems with pg_restore to 7.3.3 db


fairly new to postgres admin stuff......

i have a production machine that is running postgresql 7.1.3
also, there's a test machine which already had 7.0.3, and which i newly
installed 7.3.3

so, i dumped all the databases from the production db and reloaded on the
there was a few problems but only small ones and i sorted them out ok, but
one of the databases has large objects in it, so the dumpall wont dump the
large objects,
so, i made a dump of the db with large objects
pg_dump -b -Fc -f /var/lib/pgsql/backups/mydblo_dump mydblo
this went fine,
then i created the db using
createdb -T template0 mydblo

then, i try to restore on the test machine using
pg_restore -Fc -d mydblo mydblo_dump

to which i get the error

pg_restore: [archiver (db)] could not execute query: ERROR: Load of file
/usr/lib/pgsql//plpgsql.so failed: /usr/lib/pgsql//plpgsql.so: undefined
symbol: fmgr_pl_finfo
is there something wrong with my pg_restore command or is there some mix up
that its looking at variabels from the old version of the db?

i've tried

pg_restore -Fc -f mydblo_dump -d mydblo

but that just starts and does nothing for ages, and i have to kill the job

thanks for any ideas,

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
0 1325

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sam | last post: by
reply views Thread by Joshua D. Drake | last post: by
14 posts views Thread by Ron Johnson | last post: by
11 posts views Thread by Ben Marklein | last post: by
reply views Thread by Otto Blomqvist | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by ruben | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.