Resolved: Question about pg_upgrade from 9.2 to X.X

Поиск
Список
Период
Сортировка
От Perumal Raj
Тема Resolved: Question about pg_upgrade from 9.2 to X.X
Дата
Msg-id CALvqh4pNqfW9_nx2c3w8c=wrPZk_uxwbW5sGocYe+HyC+0gUcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about pg_upgrade from 9.2 to X.X  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-general
Thanks again.

Perumal Raju

On Thu, Mar 7, 2019, 2:32 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
On Wed, Mar 06, 2019 at 09:44:16PM -0800, Perumal Raj wrote:
> Any pointers for pg_repack schema creation ?

With recent postgres, you should use just: "CREATE EXTENSION pg_repack", which
does all that for you.

> Will there be any impact in the future , Since i used --link option ?

You probably have an old DB directory laying around which is (at least
partially) hardlinks.  You should remove it .. but be careful to remove the
correct dir.  My scripts always rename the old dir before running pg_upgrade,
so it's less scary to rm -fr it later.

Justin

В списке pgsql-general по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Question about pg_upgrade from 9.2 to X.X
Следующее
От: Arjun Ranade
Дата:
Сообщение: Connection pooling for differing databases?