From: | Chadima Jiří <chadima(at)jtbank(dot)cz> |
---|---|
To: | "pgsql-pkg-debian(at)postgresql(dot)org" <pgsql-pkg-debian(at)postgresql(dot)org> |
Subject: | pg_upgrade in 9.3.5 can not start cluster |
Date: | 2014-10-01 16:07:04 |
Message-ID: | D1FA90F570B9E3449D7EF1A4D43D1736B7203591@CZPAV00092.pa.jtfg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
Hi,
we've encountered possible bug in debian packages, both squeeze and wheezy seem to be affected.
We're using following repositories:
http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg/main amd64 Packages
http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main amd64 Packages
This bug makes it currently impossible to run pg_upgrade script on 9.3 and therefore successfully upgrade from 9.2 to 9.3. It seems to be a typo somewhere in the source code. Unfortunately, I don't have the logs anymore, but the problem was that pg_upgrade refused to start cluster with an error that went like 'parameter "full_page_writes" requires a Boolean value'. The problem was that the startup command had a typo in it and contained '-c full_page_writes=off-c anotherparameter...' (Notice no space after =off).
I think the pg_upgrade script worked when we were upgrading from 9.2 to 9.3.4, upgrade from 9.2 to 9.3.5 does not work anymore. As a workaround we have used pg_upgrade from 9.3.4 package and it worked.
Could you guys look at it? Unfortunately due to internal policy I can't test any patches in our environment, but this should be easily reproducible on a clean debian box.
Regards,
Jirka Chadima
From | Date | Subject | |
---|---|---|---|
Next Message | Jake O'brien Fagan | 2014-10-01 20:56:10 | postgresql-9.3-postgis-2.1 failing to install on debian 7.6 |
Previous Message | apt.postgresql.org repository | 2014-10-01 07:54:25 | postgis updated to version 2.1.4+dfsg-1.pgdg+2 |