Re: [PATCH] Negative Transition Aggregate Functions (WIP)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Дата
Msg-id 25704.1387990196@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCH] Negative Transition Aggregate Functions (WIP)  ("Erik Rijkers" <er@xs4all.nl>)
Список pgsql-hackers
"Erik Rijkers" <er@xs4all.nl> writes:
> I have a 200 GB dev database running under 9.4devel  that I thought I could now, for test purposes, compile a
patched
> postgres binary for (i.e.: a HEAD + inverse_transition_functions_v1.5.patch.gz binary), so as to avoid an initdb and
use
> the existing 200 GB data.

That's not going to work for any patch that touches the initial contents
of the system catalogs.

> Is there a way I can use the existing database and avoid both initdb and this error?

Use pg_upgrade to move the data into a newly initdb'd directory.  Note
you will need both unpatched and patched executables for this.
        regards, tom lane



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

Предыдущее
От: "Erik Rijkers"
Дата:
Сообщение: Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE