Re: postgis after pg_upgrade

2018-12-06 Thread Adrian Klaver
On 12/6/18 12:40 AM, Slavcho Trnkovski wrote: Hi, But my understanding is that this approach is used when upgrading PostGIS. Which maybe necessary when upgrading the database: http://postgis.net/docs/manual-2.4/postgis_installation.html#upgrading Which seems to be what is happening in your ca

Re: postgis after pg_upgrade

2018-12-06 Thread Slavcho Trnkovski
Hi, But my understanding is that this approach is used when upgrading PostGIS. I'm upgrading postgresql from 9.4 to 9.6 and PostGIS version remains the same (2.4.5). If I execute: drop extension postgis; CREATE EXTENSION postgis SCHEMA postgis; select PostGIS_full_version(); postgis_full_v

Re: postgis after pg_upgrade

2018-12-04 Thread Jeremy Schneider
On 11/30/18 05:11, Slavcho Trnkovski wrote: > I have postgresql 9.4 with postgis extension installed (latest version, > 2.4.5). I upgraded postgresql from 9.4 to 9.6.  > After upgrading to 9.6 I get the following result > from PostGIS_full_version() >  select PostGIS_full_version(); > >  ... (proc

Re: postgis after pg_upgrade

2018-12-03 Thread Adrian Klaver
On 12/1/18 8:56 AM, Slavcho Trnkovski wrote: Hi, This will not resolve the issue I have because extension is already to the latest version, but it is using postgres 9.4 and it should use 9.6. Well according to below: POSTGIS="2.4.5 r16765" According to this: http://postgis.net/source/ pos

Re: postgis after pg_upgrade

2018-12-03 Thread Rene Romero Benavides
Are the postgis functions usable? do they currently work ? any error messages in the database server logs ? have you installed the postgis binaries for postgres 9.6? if you follow the given advise by Paul Ramsey, what happens? Am So., 2. Dez. 2018 um 14:24 Uhr schrieb Slavcho Trnkovski < strnkov..

Re: postgis after pg_upgrade

2018-12-02 Thread Slavcho Trnkovski
Hi, This will not resolve the issue I have because extension is already to the latest version, but it is using postgres 9.4 and it should use 9.6. Regards, Slavcho On Fri, Nov 30, 2018 at 6:01 PM Paul Ramsey wrote: > If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to > up

Re: postgis after pg_upgrade

2018-11-30 Thread Paul Ramsey
If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to update the SQL-side bindings, everything should improve. > On Nov 30, 2018, at 5:11 AM, Slavcho Trnkovski wrote: > > Hi, > > I have postgresql 9.4 with postgis extension installed (latest version, > 2.4.5). I upgraded po

postgis after pg_upgrade

2018-11-30 Thread Slavcho Trnkovski
Hi, I have postgresql 9.4 with postgis extension installed (latest version, 2.4.5). I upgraded postgresql from 9.4 to 9.6. After upgrading to 9.6 I get the following result from PostGIS_full_version() select PostGIS_full_version(); postgis_full_version