Questions tagged [postgis]
8 questions
4
votes
2 answers
Could not load postgis-2.4.so "undefined symbol: Float8GetDatum"
Just upgraded to PostgreSQL 10.1 on Arch Linux. Created a fresh new database and I'm trying to install postgis, but it is giving me the following error:
local=# create extension postgis;
ERROR: could not load library…
elynnaie
- 1,065
2
votes
1 answer
Debian install of PostGIS extension is installing X packages
I'm trying to install PostGIS on a Debian server running Stretch. I installed PostgreSQL on it without any problems, but when I try to install the package postgresql-9.6-postgis-2.3, the latest available, apt-get tries to install truckload of X and…
Ivan
- 212
- 4
- 15
1
vote
0 answers
Upgrading PostgreSQL 10 to 11
As I was installing osm2pgsql with Homebrew, brew started updating my Postgres from 10.8 to 11.3. After installation, the process, the upgrade of database failed.
Error: Upgrading postgresql data from 10 to 11 failed!
==> Removing empty postgresql…
1
vote
0 answers
Update database from PostgreSQL 8.3.8 + PostGIS 1.3.5 to PostgreSQL 10.1 + PostGIS 2.4
I inherited an old server (Ubuntu 12.04.5) with a database running on PostgreSQL 8.3.8 with the PostGIS 1.3.5 Extension. This server is going to be replaced by a new server (4.14.12-1-ARCH) where I use docker to separate different PostgreSQL…
nevrome
- 190
0
votes
0 answers
What are the command line parameters that I can pass to the PostGIS installer?
I want to silently install PostGIS on a Windows machine with PostgreSQL using Ansible.
To do so, I need to be able to run the PostGIS installer on the commandline, with the required options as arguments to the installer.
I found the separate…
Saaru Lindestøkke
- 5,899
0
votes
1 answer
PostgreSQL and PG Admin 3 Not Listening
I'm using PostgreSQL 9.4 with the PostGIS extension. Everything was working fine until I turned off my server to move it to a different location in my rack.
Now I get the error "Server doesn't listen". My .conf files have the "*" for listening range…
Kyle
- 1
0
votes
1 answer
Indexing a PostgreSQL query using a geometry field (gist) but it doesn’t seem to be working
I remembered to remove and recreate the index to eliminate the possibility that anything changed
gidrop index if exists incidents;
create index idx_geo on incidents using gist(geo);
Then this:
vacuum analyze incidents;
Here's the query that is…
0
votes
2 answers
Postgres Authentication Fails When Starting Dajngo
I am in the process of restoring my Django development server to another virtual machine. I have set up Django, Postgres, installed the GIS extensions and restored the database.
When I run the server, I get the error below:
password authentication…
RLBChrisBriant
- 123
- 1
- 2
- 12