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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] VACUUM failing ??!!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: start postmaster as root : problem