Questions tagged [pgadmin-4]
pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects
62
questions
2
votes
3
answers
57
views
QGIS will not save edits for data stored in PostGIS
So I am trying to edit data saved on a local instance of PostGIS within QGIS. However,whenever I try to save my edits I get the error message:
I am capable of modifying the data how I want in QGIS, ...
- 343
0
votes
1
answer
62
views
Error 2: Importing Shapefile to QGIS DB Manager Failure || PostGIS || PgAdmin
I am new to PostgreSQL, PostGIS, and pgAdmin. I am trying to import a shapefile through the DB Manager (PostGIS --> my specific database) in QGIS. I keep getting an Error 2 message indicating that ...
2
votes
2
answers
61
views
Finding all isolated buffer points using PostGIS [closed]
I am doing a project where I find the banks in Ireland using PostGIS and pgAdmin
I want to run a query that finds all the buffer spaces that do not intersect with any nearby buffers. I am using ...
- 29
1
vote
1
answer
33
views
Initialise variable with ST_Polygon
I use ST_Polygon in my queries:
ST_Polygon('LINESTRING(-71.9436023 41.3108239,
-71.7237582 41.0254994,
-73.2015354 41.0545020,
-71.9436023 41.3108239)'::geometry, ...
- 133
1
vote
0
answers
44
views
PostGIS and QGIS - how to restrict delete, add, rename layer [closed]
How do I restrict users from deleting, adding, or renaming the layers from my database? or would it be possible to only show the project but not the layers?
Note: I logged in to my superuser account, ...
- 139
1
vote
1
answer
481
views
Geometry Viewer in pgAdmin 4 displays a straight line instead of polygons of European union countries
Via PostGIS I import a shapefile layer with polygons of EU countries. I try select all rows and after still display blue straight line without the end. Where is the problem?
- 11
1
vote
1
answer
4k
views
Osm2pgsql error: authentication method 10 not supported
I'm getting the following error when trying to import osm data using osm2pgsql. I just installed pgAdmin4 today so it should all be up to date.
osm2pgsql version 0.92.0 (64 bit id space)
pgAdmin4 ...
- 792
1
vote
1
answer
386
views
Forcing geometry columns to be small on pgAdmin 4
On pgAdmin 4, geometry columns always show as huge lines:
So when I want to check the geometries inside Postgres I have to go all the way until the end of the line with a very small scroll bar:
That ...
- 1,141
3
votes
1
answer
960
views
Installing PostGIS extension with pgAdmin 4 on MacOS Monterey
I'm currently running into a problem on pgAdmin 4 where I am unable to use the PostGIS extension. I first tried running it this way through PGAdmin 4:
DROP EXTENSION IF EXISTS postgis CASCADE;
CREATE ...
- 41
5
votes
0
answers
191
views
Loading layer from PostGIS with non-unique primary key
I'm trying to load (by mean of PyQGIS) a layer from PostGIS based on query involving a inner join with a non-spatial table. When I run the query in pgAdmin I get the desired output but when I ...
- 347
3
votes
1
answer
740
views
View two geometry columns together in pgAdmin Geometry Viewer
I have two geometry columns like this:
How can I see them together in the Geometry Viewer?
If i select all rows it shows only one column at a time.
- 33
5
votes
4
answers
494
views
Saving modifications in PostGIS layer edited in QGIS
I opened a PostGIS layer (from the server) with QGIS and I did some modifications (for example attribute join from another layer). How can I save my modifications so that it is visible in pgAdmin?
- 169
0
votes
0
answers
484
views
SQL Server error when creating Geography data from a Multipolygon Geometry
So, in SQL server, I have a table called Municipios, which contains a column with 2463 entries of geometry type, with their SRID set to 4326.
I'm running the following Query to try to convert them to ...
- 31
9
votes
1
answer
3k
views
pgAdmin version 4-5.3 where is the geometry viewer
Updated the pgAdmin to latest version 4-5.3 on Windows 64 bit, I can not find the geometry-viewer anymore.
So howto "activate" the geometry-viewer in the latest version?
Update:
As @JGH ...
- 6,833
1
vote
1
answer
162
views
Interlis ili import into PostGIS
I am currently trying to generate an empty database in pgAdmin 4.29 using ili2pg. The Interlis model SIA405_ABWASSER_2015_LV95 is available here. The ili2pg-command I used is
java -jar ili2pg-4.4.4....
- 155
0
votes
0
answers
544
views
Layer is not valid error when connecting QGIS to PostGIS
I am new to QGIS.
I am trying to connect a view from PostGIS to QGIS (3.16.4, same with 3.12).
The PostGIS connection in QGIS browser have no issues and when "Test Connection" it says it can ...
- 1
0
votes
0
answers
155
views
pg_tileserv SET DATABASE_URL return
I'm trying to set the SET DATABASE_URL for pg_tileserv in the cmd terminal using:
DATABASE_URL=postgresql://postgres:[password]@127.0.0.1:60999/pgr
which seems to be accepted. But when I start ...
- 1
0
votes
0
answers
250
views
pgAdmin 4: create view without defining schema
I have a database containing the official cadastral surveying of hundreds of counties. For every county I have created a new schema named state_zipcode_countyname. As all my db entries have the same ...
- 155
1
vote
1
answer
219
views
QGIS error message while running PostgreSQL code. WARNING Invalid PostgreSQL layer
I have run a code in pgAdmin it returns 43 rows of data. I took the same code ran it in QGIS and found the same row of data. However while trying to add the new data into the map QGIS comes with the ...
- 57
0
votes
1
answer
146
views
PostGIS: Can´t preview geometry when in different schema than public - why?
So I'm trying to wrap my head around PostGIS and how to get it working correctly in a schema other than 'public'.
I followed this tutorial, and transfered PostGIS to my own schema, postgis_test. I ...
- 59
1
vote
0
answers
78
views
Making multi-layer mvt vector tile [closed]
I'm trying to make multi-layer vector tile using SQL query. I could able to make Mvt tile, but that was only for single layer. I got binary file from that query.
How can I make multi-layer Mvt ...
- 41
1
vote
0
answers
203
views
Updating tables from QGIS to pgAdmin
I have created a connection between QGIS (ver. 3.10.1-A Coruña) and PostgreSQL (pgAdmin 4).
Every time I edit/update my table in QGIS I have to delete the table in PostgreSQL and re-import again the ...
- 940
-2
votes
1
answer
568
views
Error when publishing a table/layer from PostGIS to GeoServer
The error messages pops up every time I try to publish a table from PostGIS in GeoServer.
Oops, something went wrong...
Sorry, something unexpected happened on the server.
Here's an error report you ...
- 29
2
votes
1
answer
437
views
Create PostgreSQL user for QGIS project
I have some data in a PostgreSQL database, I use pgAdmin4 for the organisation of the data.
I want to create a QGIS project for other users with the data from my database. The users of the project ...
- 401
0
votes
0
answers
644
views
Connect QGIS to Remote PostgreSQL Server
I am trying to connect to my database on a remote server using QGIS. From what I've read I have to edit the pg_hba.conf and the postgresql.conf files. I think I have edited these files to allow any IP ...
- 159
1
vote
1
answer
908
views
Error when creating PostGIS extension in pgAdmin4
I am trying to create a PostGIS extension in pgAdmin4.
When typing CREATE EXTENSION postgis;, or through "db_name > Create > Extension > General > Name = postgis", I get this error:
ERROR: could ...
- 623
1
vote
1
answer
125
views
Query to Map GPS points with multi-linestring
I have a column of geometry of type multi-linestring in a database as in the following format
Now I want to add a new column of speed by mapping GPS points against geometry column (as described ...
0
votes
0
answers
738
views
Downloading Census data to PostgreSQL PostGIS TIGER extension for Amazon RDS database
Can someone point me toward instructions on how to download census data for the postGIS_tigerP_geocoder extension?
I would like to use the geocode() function, but any query returns 0 results. From ...
- 413
2
votes
0
answers
725
views
Upgrade to PostGIS 3.0 in pgAdmin
I would like to use the new ST_TileEnvelope() function from PostGIS 3.0. My current version is 2.4.4.
I would like to update to PostGIS 3.0 in pgAdmin. Is this possible?
I have tried
ALTER ...
- 413
1
vote
0
answers
313
views
Access PostGIS on Heroku instance from GeoServer
In Heroku, I have a PostgreSQL DB with all the credential to be accessed by outside (Host, Port, Database name, User, Password, URI). Then I connected pgAdmin with this database using the above ...
- 11
1
vote
1
answer
160
views
Transfer spatial data between databases using pgAdmin4
I'm new to pgAdmin4 and performing tests before jumping in the deep end.
I've uploaded a large dataset into a the public schema within a database named 'spatial_db'. Rather than re-uploading the data ...
- 2,109
2
votes
1
answer
377
views
pgr_createTopology uses too much memory and "connection to the server has been lost"
I have the large roads network (urban walking paths).
I'm trying create topology in my database but when query reaches 175
thousands of edges, begins to increase memory usage. In the same time CPU ...
- 195
1
vote
1
answer
726
views
Error while using ST_Line_Interpolate_Point: first argument isn't line
I've been running a scheduled task that contains some SQL code that has been running fine up until a few weeks ago. I don't believe any of the code had changed recently so I went through the debugger ...
- 93
1
vote
0
answers
18
views
Setting constraint so that new value in "Table A" must already exist in "Table B", else return error? [closed]
I'm trying to set up some kind of constraint so that I can only enter values in "Table A", if that value exists in "Table B".
I want this to act sort of like a selection list, where there are only a ...
- 97
4
votes
2
answers
413
views
Query in QGIS is significantly slower, than in pgAdmin
So, I've a table in postgresql, that is joined to other spatial table.
If I've run a simple query in pgAdmin, let's say SELECT * FROM table1 WHERE "area" > '5000' and it takes less, than 1s to ...
- 876
1
vote
1
answer
987
views
Restore backup from pgadmin 3 to 4 [closed]
Is there an easy way to restore databases from PGadmin 3 into Pgadmin 4? Right now data on both, and I want to gather all my data on the same server. The port on PGadmin 3 is 5432 and 5433 on PGadmin ...
- 331
1
vote
0
answers
2k
views
Rendering 3D map in pgAdmin 4 to view Data? [closed]
I found this error 3D geometrics not rendered in view data (pgAdmin 4).
In GeoDjango I've updated my PointField model with dim=3. After successful migration, I cannot see my data in map.
My Django ...
- 11
1
vote
1
answer
508
views
Parse Error on PostgreSQL when using ST_AsText
I am new to using POSTGIS and PostgreSQL.
I am trying to convert PostGIS coordinates into lat and long values. When I copy one of the values and query like
SELECT ST_AsText('...
1
vote
1
answer
308
views
Updating geometry as Multipolygon from Polygon table using PostGIS? [closed]
There are two tables in PostGIS. In which, one has polygon geometries with layer name wise and another one table has master layer name list.
The requirement is to collect the polygon geometries as ...
- 1,021
1
vote
0
answers
430
views
ERROR: function st_orientedenvelope(unknown) does not exist
I tried the example for ST_OrientedEnvelope given in PostGIS website but that failed. This function is failing for my table geometry column also.
SELECT ST_AsText(ST_OrientedEnvelope('MULTIPOINT ((0 ...
- 608
2
votes
2
answers
1k
views
Load LINESTRING in WKT-format from CSV to pgAdmin?
I've got a CSV file with a column containing LINESTRINGs that looks something like this:
1,"LINESTRING(20.331 54.33, 21.67 44.89, 12.67 13.5679)",2014-03-09 13:30:33,2014-03-09 13:31:33
2,"LINESTRING(...
- 23
1
vote
1
answer
1k
views
PostgreSQL PostGIS: append table to another table [closed]
I have a large polygon table (30+million rows) and a smaller polygon table (45,000 rows). Both are PostGIS enabled.
The smaller table only contains polygons that do not exist in the large table. Both ...
- 1,667
3
votes
1
answer
1k
views
PostgreSQL PostGIS: Spatial join but keep all features that don't intersect
Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
- 1,667
2
votes
2
answers
14k
views
ERROR: parse error - invalid geometry (Postgis)
Initially I was storing my column as path and then following this question I changed it to text.
I'm trying to convert my column from text to geometry type by running this command:
ALTER TABLE ...
- 123
1
vote
0
answers
303
views
Import CSV to QGIS 3 where the geometry is in GeoJSON format
I have a CSV file with different attributes for each polygon. One of the attributes (column name) is GeoJSON which hold the geometry. For example, in the first polygon the geojson attribute is:
{"...
- 1,689
1
vote
0
answers
193
views
Setting PostgreSQL privileges for ArcGIS?
I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
- 5,747
12
votes
5
answers
11k
views
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
When I try to run PostGIS 2.0 Shapefile and DBF Loader Exporter I get the following error:
The program can't start because libintl-9.dll is missing from your
computer. Try reinstalling the ...
- 5,700
3
votes
1
answer
15k
views
How to upgrade pgAdmin 4 in Windows? [closed]
A new version of pgAdmin 4 is released almost every month. I wonder what is the correct way to upgrade a newer version of it?
Is it necessary to uninstall the older version first and install the new ...
- 10.1k
2
votes
1
answer
60
views
Why does my source and target repeats itself when I use pgr_createtopology()?
I created my path in QGIS v2.18.18, making the lines and a combination of cleaning tool and explode lines tool to get my desired output.
I tried using ROAD GRAPH plugin in order to check whether my ...
1
vote
2
answers
4k
views
PostgreSQL select value where '100%' using bigint
I am trying to select data from a bigint column in PgAdmin using SQL:
SELECT FROM public.addressbaseplus WHERE uprn LIKE '100%'
However, I am getting the following error:
ERROR: operator does not ...
- 329