We’re rewarding the question askers & reputations are being recalculated! Read more.

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

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
67 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 ...
1
vote
0answers
34 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
1answer
45 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 ...
1
vote
1answer
101 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
78 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
67 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
83 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
39 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
0answers
31 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
161 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
159 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 ...