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

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
182 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 ...
2
votes
1answer
126 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 ...
1
vote
0answers
73 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 ...
1
vote
0answers
165 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 ...
1
vote
0answers
89 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
vote
0answers
104 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 ...
1
vote
1answer
41 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 ...
0
votes
1answer
34 views

How to update 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 ...
0
votes
0answers
68 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 ...
0
votes
0answers
105 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 ...
0
votes
0answers
187 views

Is Spatial clustering with PostGIS possible to generate N number of groups that have 10 elements?

I need to create a query using some sort of spatial clustering algorithm within PostGIS database. Currently, I am using pgAdmin version 4. More specifically, I need to create N number of groups that ...
0
votes
0answers
222 views

pgr_createTopology() 'Connection to the server has been lost'

When trying to create topology from pgAdmin 4 (version 2.1) with the pgr_createTopology function I get an error: "Connection to the server has been lost." The database is on localhost. The input ...