All Questions
Tagged with postgresql ubuntu
41
questions
1
vote
1
answer
290
views
mapnik-renderd error: FATAL: role "_renderd" does not exist
mapnik-renderd error: FATAL: role "_renderd" does not exist
I've been following this tutorial to making an osm tile server on Ubuntu 20.04 (WSL), but after restarting the renderd service ...
0
votes
1
answer
430
views
Very Slow OSM Tile Rendering
I have built my own OSM server of North America using switch2osm's Ubuntu 20.04 guide and all went well. Except when it comes to rendering tiles...or pre-rendering.
Here is the most recent completed ...
8
votes
2
answers
6k
views
PostGIS: type "raster" does not exist
I'm new to PostgreSQL and PostGIS.
I'm adding a raster to a newly created PostGIS schema and table with the raster2pgsql command:
sudo raster2pgsql -I -C -s 3577 -t 50x60 /path/to/raster.tif schema....
8
votes
3
answers
14k
views
PostgreSQL-12.3 / PostGIS-3.0 - could not access file “$libdir/postgis-2.4”: No such file or directory
I am aware there are a few similar questions to this one, such as here and here. My problem is however a bit different.
I've recently upgraded my Ubuntu to 20.04 and there only PostgreSQL 12.3 and ...
0
votes
1
answer
2k
views
PostGIS cannot create extention:ERROR: cache lookup failed for function 1
When trying to create PostGIS extension I am getting this error:
ERROR: cache lookup failed for function 1
I am running PostgreSQL 11 on Ubuntu 16.04.
I have installed PostGIS and PostGIS scripts. ...
2
votes
2
answers
2k
views
Installing PgPointCloud extension for PostgreSQL on Ubuntu Bionic
I'm stuck with the installation of the PgPointCloud extension for PostgreSQL. I found this article:
https://connect.boundlessgeo.com/docs/suite/4.6/dataadmin/pointcloud/install.html
But when I run ...
4
votes
2
answers
6k
views
Cannot create PostGIS extension with Ubuntu 18.04
I am a few days new to Linux Ubuntu and am in the process of setting up a PostGIS database to use in GeoDjango.
I am going to post all my commands that I have done so far
these are installed in ...
3
votes
0
answers
3k
views
ogr2ogr PQconnectdb connection error [closed]
I am trying to convert a PostgreSQL table to CSV using ogr2ogr. Why is my command failing?
ogr2ogr -f CSV output.csv PG:"host=myhost port=5432 user='postgres' password='mypassword' dbname='mydb'" "...
2
votes
1
answer
3k
views
Install Postgis in Ubuntu 16.04 in with already postgresql 9.3 installed
In ubuntu 16.04 with postgresql 9.3 when I tried to install postgis with using command
sudo apt-get install postgis postgresql-9.3-postgis-2.1
It installed postgresql 9.6 and postgis-9.6 version. ...
2
votes
1
answer
1k
views
Installing pgrouting on Ubuntu 16.04 fails
I tried to install pgrouting on Ubuntu 16.04 but I got following error message:
CREATE EXTENSION pgrouting;
could not open extension control file "/opt/PostgreSQL/9.6/share/postgresql/extension/...
5
votes
2
answers
5k
views
Plotting a shapefile directly from PostGIS using Python
I'm trying to plot a shapefile directly from PostGIS using Python. My shapefile is already stored in PostgreSQL. I know how to connect Python with PostgreSQL, but I just can't find anything that helps ...
2
votes
1
answer
384
views
How to store complete edit history OSM PostgreSQL?
I successfully built a PostgreSQL server on an Ubuntu VM and populated it with the latest Geofabrik .osm.pbf complete dataset for Nepal. Now, I'd like to append to that dataset all of the historic ...
2
votes
1
answer
2k
views
Restoring PostGIS 2.1. dump in PostGIS 2.2
I tryed to restore my old PostGIS dumps (Postgis 2.1, PostgreSQL 9.1) at my new system (PostGIS 2.2 and PostgreSQL 9.5)
I was using pgadmin3 to dump the databases and was now trying to restore it ...
2
votes
1
answer
2k
views
shp2pgsql-gui not work after Ubuntu update
I'm using Ubuntu 14.04 with postgres-9.5 and postgis 2.2.2.
Previously I performed shp2pgsql-gui to access the interface, but now, the terminal shows me this message:
the program shp2pgsql-gui not ...
0
votes
1
answer
235
views
Is there some method on Ubuntu to request newest postgresql postgis package rather than specific version?
There is postgresql-9.3-postgis-2.1 and there is postgresql-9.4-postgis-2.1. Unfortunately 9.3 is available only on trusty and 9.4 is not available on trusty (see http://packages.ubuntu.com/search?...