Questions tagged [postgresql-13]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
12 views

pg_upgrade ERROR: could not find function “postgis_sfcgal_version” in file “C:/Program Files/PostgreSQL/13/lib/postgis-3.dll”

I'm trying to pg_upgrade folder data from v12 to v13 "C:\Program Files\PostgreSQL\13\bin\pg_upgrade.exe" --old-bindir "C:\Program Files\PostgreSQL\12\bin" --new-bindir "C:\...
0
votes
0answers
54 views

My geom cannot transform

I have a query like this: WITH var AS ( SELECT '' AS periode, '' AS group, '' AS facility_name, '' AS country ) SELECT row_number() OVER () AS gid, ...
-1
votes
1answer
28 views

How to add US State NHGIS historical GIS data to PostGIS? ERROR: INSERT has more target columns than expressions

I am trying to add historical data extracted from NHGIS to PostGIS, but I get the INSERT has more target columns than expressions error when I run the code below: "C:\psql.exe" -c "...
0
votes
0answers
32 views

PostGIS Geography Data Changed After pg_restore

Two PostGIS databases (PostGIS 3.0, PostgreSQL 13.1) were setup on two separate machines to be as close to each other as possible using a Docker image kartoza/postgis:13.1. A dump of the database was ...