Re: [PATCH] Negative Transition Aggregate Functions (WIP) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Date
Msg-id 25704.1387990196@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Negative Transition Aggregate Functions (WIP)  ("Erik Rijkers" <er@xs4all.nl>)
List 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 by date:

Previous
From: "Erik Rijkers"
Date:
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Next
From: Peter Geoghegan
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE