hi,
sorry for posting this again, but if anyone has any ideas, they would be
greatly appreciated,
i've searched through the FAQ's and other newsgroups etc but cant seem to
find any answers that will help me wit this problem.
thanks
andy
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of andy morrow
> Sent: 02 July 2003 15:17
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] problems with pg_restore to 7.3.3 db
>
>
> hi,
>
> 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
> test,
> 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
> then.
>
> thanks for any ideas,
>
> andy
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>