Re: restoring pgdump file file from 7.2 branch to 7.4

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: restoring pgdump file file from 7.2 branch to 7.4
Дата
Msg-id
26758.1099671338@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
restoring pgdump file file from 7.2 branch to 7.4 "Bob Powell" <bob@hotchkiss.org>
Re: restoring pgdump file file from 7.2 branch to 7.4 Peter Eisentraut <peter_e@gmx.net>
Re: restoring pgdump file file from 7.2 branch to 7.4 Tom Lane <tgl@sss.pgh.pa.us>
"Bob Powell"  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 по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ