Re: restoring pgdump file file from 7.2 branch to 7.4

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

In response to

Browse pgsql-general by date

  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 ??!!