Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [postgis]

33 questions
9
votes
2 answers

How to scale out OpenStreetMap data efficiently

For over a year now, I'm running an in-house PostGIS server filled with OSM data, used for both Mapnik-based tile generation and Nominatim-based geocoding, updated with day replicates. This works pretty well. However, as usage is growing…
Pierre
  • 243
  • 2
  • 8
8
votes
2 answers

Why is Postgres sitting 95% idle, with no file I/O?

I have a TileMill/PostGIS stack running on an 8 core Ubuntu 12.04 VM on an OpenStack cloud. It's a rebuild of a very similar system which was running nicely on very similar hardware (same cloud, but different physical hardware, I believe) last week.…
Steve Bennett
  • 5,539
  • 12
  • 45
  • 57
7
votes
1 answer

Cannot upgrade postgresql 9.4 -> 9.5beta2 after postgis 2.1.6 -> 2.2.0 upgrade

Here is my situation: I started with Postgresql 9.4.5 and Postgis 2.1.6. Everything running smoothly. Both are installed from source. I upgraded Postgis to 2.2.0 (download source, configure, make, make install, then ALTER EXTENSION postgis UPGRADE…
elynnaie
  • 201
  • 1
  • 9
7
votes
1 answer

How to import a dump in Postgres from a newer version?

We have a postgres-databse under windows, that is version 9.1. From that we want to dump the data and import under a Linux-server, that runs Postgres 8.4. The data include spatial data with Postgis. The problem is, that the dump doesn't import, as…
Mnementh
  • 1,075
  • 2
  • 11
  • 18
5
votes
3 answers

Upgrade PostgreSQL 9.5 to 9.6 with PostGIS - pg_upgrade

I'm trying to upgrade a 9.5 server to 9.6, and pg_upgrade gives me the following error: Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is the install…
Jeremy Wilson
  • 301
  • 1
  • 3
  • 12
5
votes
1 answer

Postgres on OS X can't find postgis extension control file

Using mac OSX Yosemite 10.10.1. I uninstalled and re-installed both postgres and postgis with homebrew. I understand that postgres is looking in the wrong place for the postgis control file. Also noticed that 'which psql' path seems incorrect. …
ltrainpr
  • 221
  • 2
  • 7
4
votes
1 answer

Contrib directory in PostgreSQL 9.1

Where is the contrib directory in PostgreSQL 9.1? This source states its at /usr/share/pgsql/contrib but the directory /usr/share/pgsql does not exist. I installed PostgreSQL from the rpm, on a CentOS 6.3. I am basically trying to find the correct…
Nyxynyx
  • 1,449
  • 10
  • 37
  • 47
4
votes
0 answers

Ignoring maturity, which database would be better for storing spatial data?

I am looking to store possibly millions of spatial locations. I will need to do queries like "hotels within 10 miles of [lat,lng]". I've had a little experience with MongoDB in this regard and was actually impressed at how easy it was. However,…
cbmeeks
  • 243
  • 1
  • 4
  • 11
4
votes
2 answers

Installing Nominatim Pre-Indexed Data

I am trying to install nominatim using this guide. After one day of processing, I finaly get this message: feature 895(k) Killed After a read in dmesg I got: [143978.925793] Out of memory: kill process 14456 (bash) score 204947 or a…
Natim
  • 616
  • 1
  • 6
  • 16
3
votes
1 answer

Install postgis on ubuntu 12.04.4 LTS

I am trying to install postgis on ubuntu Ubuntu 12.04.4 LTS. I search the repo and find a package called postgresql-9.1-postgis. I then installed it: sudo apt-get install postgresql-9.1-postgis It also installed the following…
user209247
  • 31
  • 1
3
votes
1 answer

Using PostgreSQL 9.0 and PostGIS 1.5 on Debian Squeeze

I have installed PostgreSQL 9.0 (postgresql) and PostGIS 1.5 (postgis) from Debian Backports on my freshly installed Squeeze (stable). However, when trying to create a PostGIS-enabled database, I noticed that I’m missing the “enabler script”…
scy
  • 307
  • 3
  • 11
3
votes
1 answer

Setting up PostGIS on Ubuntu 10.10

I followed this manual: http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/ I installed using aptitude: postgis postgresql-8.4-postgis but there is no script lwpostgis.sql in the /usr/share/postgresql-8.4-postgis/.
Xaver
  • 249
  • 2
  • 12
2
votes
2 answers

PostGIS on Fedora27

I'm trying to get PostGIS installed on Fedora27 and Postgres 9.6. When doing this on Windows, I can just use the Stack Builder, but that doesn't appear to be a utility available on the Fedora distribution. I have tried using dnf to install, but…
JGrindal
  • 121
  • 2
1
vote
0 answers

OGR FDW only works with UTF-8 databases, postgis install

I try to add postgis extension on postgresql95. I use centos7 I follow this link to install…
ikhwan aja
  • 23
  • 1
  • 4
1
vote
2 answers

CREATE EXTENSION postgis fails with /usr/lib/libgdal.so.1: undefined symbol: sqlite3_column_table

Problem: postgres=# CREATE EXTENSION postgis; LOG: statement: CREATE EXTENSION postgis; ERROR: could not load library "/usr/lib/postgresql/9.5/lib/rtpostgis-2.3.so": /usr/lib/libgdal.so.1: undefined symbol: sqlite3_column_table_name` What I've…
tiblu
  • 141
  • 6
1
2 3