your suggestion Chris.
From: Kevin Berger
Sent: Thursday, October 27, 2022 8:32 AM
To: 'postgis-users@lists.osgeo.org'
mailto:postgis-users@lists.osgeo.org>>
Subject: RE: Queries slow after PostGIS upgrade
We have run EXPLAIN ANALYZE for both systems. Results are below. The exec
}}}'::jsonb))::text))
Filter:
st_intersects(st_geomfromgeojsonpackageitem.shape)::jsonb || '{crs: {type:
name, properties: {name: EPSG:3401}}}'::jsonb))::text), geom)
Rows Removed by Filter: 5560
Buffers: shared hi
We are migrating from a Windows Postgres Version 9.6.1 PostGIS Version 2.3.1
solution to an AWS RDS solution, Postgres Version 13.7 PostGIS Version 3.1.5.
We used dump files to transfer the database contents to AWS, using pg_dump.exe
to create schema dump files, then using psql to restore the du
ql
(note this script is there for PostGIS 2.2.2+)
4) Restore your data as usual with pg_restore (if custom backup) or psql
if plain text.
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Ke
Hi,
We want to test our PostGIS Version 2.2.2.1/PostgreSQL 9.5.2.1 restore. We have
raster data loaded into the database.
The backup command we are using is: pg_dump.exe -c -C (We specify -C as we want
the SQL for creating databases to be in the dump file - we want to simplify the
restore oper
Hi,
We installed the 64-bit version of PostgreSQL database, version 9.2.3. We then
downloaded and installed postgis-bundle-pg92x64-setup-2.1.8-1.exe. When we try
to create a postgis extension in our PostgreSQL database, we get error:
[cid:image001.png@01D1B02C.E1439F90]
Is there anything we can
Hi,
We installed the 64-bit version of PostgreSQL database, version 9.2.3. We then
downloaded and installed postgis-bundle-pg92x64-setup-2.1.8-1.exe. When we try
to create a postgis extension in our PostgreSQL database, we get error:
[cid:image001.png@01D1B02C.E1439F90]
Is there anything we can
Hi,
We installed the 64-bit version of PostgreSQL database, version 9.2.3. We then
downloaded and installed postgis-bundle-pg92x64-setup-2.1.8-1.exe. When we try
to create a postgis extension in our PostgreSQL database, we get error:
[cid:image001.png@01D1B02C.E1439F90]
Is there anything we can
