| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
| Cc: | "David Rowley" <dgrowleyml(at)gmail(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Negative Transition Aggregate Functions (WIP) |
| Date: | 2013-12-25 16:49:56 |
| Message-ID: | 25704.1387990196@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Erik Rijkers" <er(at)xs4all(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2013-12-25 23:27:36 | Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE |
| Previous Message | Erik Rijkers | 2013-12-25 15:09:05 | Re: [PATCH] Negative Transition Aggregate Functions (WIP) |