From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Bob Powell" <bob(at)hotchkiss(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: restoring pgdump file file from 7.2 branch to 7.4 |
Date: | 2004-11-05 16:15:38 |
Message-ID: | 26758.1099671338@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Bob Powell" <bob(at)hotchkiss(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-05 16:19:54 | Re: start postmaster as root : problem |
Previous Message | Tom Lane | 2004-11-05 16:04:00 | Re: VACUUM failing ??!! |