[postgis-users] fail to upgrade from 2.1.8 to 2.2.2 or 2.3.3
strk at kbt.io
Wed Jun 26 04:00:06 PDT 2019
On Wed, Jun 26, 2019 at 11:20:59AM +0200, olivier.lobry at umontpellier.fr wrote:
> On a postgresql 9.3 / postgis 2.1.8 / debian 8.11, I cannot upgrade postgis to 2.2.2 (or 2.3.3) :
> # ALTER EXTENSION postgis UPDATE TO '2.2.2';
> WARNING: nonstandard use of escape in a string literal
> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
> ERROR: invalid input syntax for integer: « »
> Any idea of what happens ?
Note that latest PostGIS version in the 2.2 branch is
2.2.8 (released on 2018/11/21) and latest in the 2.3 branch is
2.3.8 (released on 2019/03/11).
Also, latest stable is 2.5.2 (released on 2019/03/11)
Before moving on, I'd try *those* upgrades.
> How can I get more debug information ?
> Is it possible to execute the command step-by-step to see where the underlying script fails ?
Not with the "EXTENSION" mechanism, but you could try the
script-way, using psql -f which would give you a line number
of the failing statement.
Please show the output of `SELECT postgis_full_version()" issued
on your 2.1.8 install, and beware that a newer release in the 2.1
branch of PostGIS is also available: PostGIS 2.1.9 (2017/09/19)
More information about the postgis-users