Re: restoring pgdump file file from 7.2 branch to 7.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: restoring pgdump file file from 7.2 branch to 7.4
Date
Msg-id 26758.1099671338@sss.pgh.pa.us
Whole thread Raw
In response to restoring pgdump file file from 7.2 branch to 7.4  ("Bob Powell" <bob@hotchkiss.org>)
List pgsql-general
"Bob Powell" <bob@hotchkiss.org> writes:
> I am sure that the pltcl.so is in the correct location.  Would the
> version issue of pltcl.so matter?  I'm using the pltcl.so from my older
> 7.2 branch.

Can't do that.

In current releases it's considered bad practice to be using absolute
paths for .so's at all --- better to make them relative to $libdir so
that your function definitions are more portable.

What I'd recommend is that you create the database, use the new
version's "createlang" to install the PLs you want, and then run the
restore script and ignore its bleats about the PL objects already
existing.  This will get you a modern definition of the PLs together
with your existing data.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] VACUUM failing ??!!
Next
From: Tom Lane
Date:
Subject: Re: start postmaster as root : problem