Re: [postgis-users] postgis_restore

Thanks! Il 09/10/20 13:46, Matti Linnanvuori ha scritto: > Hi! > > That has been fixed in 3.0.1. > https://trac.osgeo.org/postgis/ticket/4605 > > Best regards, Matti Linnanvuori > > >> On 9 Oct 2020, at 13.41, Paolo Cavallini > > wrote: >> >> Hi all, >> is the

[postgis-users] Moving PostGIS to a different schema

Hi all, alter extension postgis set schema public ; returns, in PostGIS 3.0 ERROR: extension "postgis" does not support SET SCHEMA any solution to this? Thanks. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more

Re: [postgis-users] postgis_restore

Hi! That has been fixed in 3.0.1. https://trac.osgeo.org/postgis/ticket/4605 Best regards, Matti Linnanvuori > On 9 Oct 2020, at 13.41, Paolo Cavallini wrote: > > Hi all, > is the utility supposed to work restoring a 9.3/2.1 dump into a 12.0/3.0

[postgis-users] postgis_restore

Hi all, is the utility supposed to work restoring a 9.3/2.1 dump into a 12.0/3.0 db? I keep on getting pg_restore: error: one of -d/--dbname and -f/--file must be specified Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more

Re: [postgis-users] Moving PostGIS to a different schema

Thanks Regina! Il 09/10/20 15:26, Regina Obe ha scritto: >> alter extension postgis set schema public ; returns, in PostGIS 3.0 >> ERROR: extension "postgis" does not support SET SCHEMA >> >> any solution to this? >> Thanks. >> -- >> Paolo Cavallini >> www.faunalia.eu - QGIS.org >> training,

Re: [postgis-users] Moving PostGIS to a different schema

> alter extension postgis set schema public ; returns, in PostGIS 3.0 > ERROR: extension "postgis" does not support SET SCHEMA > > any solution to this? > Thanks. > -- > Paolo Cavallini > www.faunalia.eu - QGIS.org > training, support, development on QGIS, PostGIS and more >

[postgis-users] Compile error during build of 3.0.2...

Hello, I'm getting the following error message when compiling... gcc -I../liblwgeom -Wall -Wmissing-prototypes -std=gnu99 -g -O2 -fno-math-errno -fno-signed-zeros -I/usr/include/postgresql/13/server -fPIC -DPIC -c -o gserialized_gist.o gserialized_gist.c gserialized_gist.c:12:10: fatal error: