All Questions
Tagged with postgresql-10 or postgresql
4,293 questions
1
vote
0
answers
30
views
Using QField offline with a PostgreSQL DB on a distant server
I'm developing a PostgreSQL–PostGIS database on a remote server. I’ve already created all the necessary layers and their attribute forms in QGIS. I now want to use it with QField. When my Android ...
- 11
1
vote
0
answers
63
views
Running Python script before PostgreSQL authentication in QGIS
I'm working with PostgreSQL in QGIS and have a Python script that runs when the QGIS session starts.
Right now, the PostgreSQL connection requires authentication first, and only after that, the Python ...
- 1,017
1
vote
1
answer
77
views
SQL query to extract relations within a bounding box from PostgreSQL OSM database
I used osm2pgsql to create an OSM PostgreSQL database for my region.
Now I want to extract data of different types within smaller areas. I can extract the nodes and ways within my bounding box using ...
- 1,013
5
votes
0
answers
122
views
Optimizing attribute table performance for large datasets in QGIS
Currently, when opening attribute tables with a large number of features, QGIS 3.44 becomes very slow and sometimes unresponsive. This happens even on high-end hardware, which suggests the bottleneck ...
0
votes
0
answers
51
views
Erratic behavior QField Sync
I am using QGIS 3.40.11 with QField Sync 4.17.3 and QField 3.7.7.
My layers are stored in a PostgreSQL database. A few days ago everything was working fine, but today when I synchronized, I received ...
- 61
3
votes
1
answer
136
views
Getting NULL values with string_to_array function in QGIS
I work with QGIS and PostGIS. With PostGIS, I ran an SQL script that contains a section dedicated to aggregation geoprocessing: from multiple source data, each containing a unique ID, this allows to ...
- 1,096
1
vote
0
answers
69
views
Displaying PostgreSQL 15 table comments on browser panel exploring in QGIS 3.34.15
I would like to show the layer PostgreSQL comment (comment on table "xxxxx") when I move mouse over the layer name in the browser Panel Exploring:
- 347
3
votes
0
answers
40
views
Does PostgreSQL/PostGIS on AWS RDS use OSTN15 transformation files for 27700?
I’m running PostGIS 3.4.3 on AWS RDS (PostgreSQL 16) with PROJ 9.5.0 (postgis_full_version() output).
We used to handle UK coordinate transformations outside of PostgreSQL (with ogr2ogr and PROJ 6.x) ...
0
votes
0
answers
38
views
ArcGIS Pro doesn't recognise PostgreSQL spatial property
I have two mirroring deployments (Dev & Prod) of PostgreSQL with PostGIS extension (i.e. not Esri enterprise geodatabase) on AWS RDS servers. The database on Prod was accidently deleted and then ...
1
vote
1
answer
73
views
QGIS Form from PostgreSQL evolutive related value column
In PostgreSQL / PostGIS : I have a layer (L1) related by a list values (LV1).
I'm searching for a way to relate L1 to LV1 which :
Automatically updates LV1 in QGIS if it's updated in PostgreSQL
Does ...
- 347
0
votes
0
answers
51
views
QGIS Browse panel "Failed to load layers"
I've run into a quite tricky problem with QGIS Browse panel and maybe someone of you had a similar experience or knows how to solve it.
The situation is as follows: I have a remote PostGIS database ...
- 1
1
vote
1
answer
162
views
PostgreSQL/PostGIS : Error No space left on device SQL state: 53100
I want to compare a geoprocessing done in QGIS and PostGIS. It involves a union of two large polygonal vector layers.The processing in QGIS tooks 1.5 hours on a well-equipped workstation (32 GB of RAM)...
- 1,096
0
votes
2
answers
52
views
QGIS, PostGIS. Table layers_styles missing
I'd like to have style(symbology) definitions per layer(geometry) saved in the database. As I understand it I can the just drag in a layer from the PostgreSQL in Browser section. And then I can apply ...
- 101
0
votes
0
answers
51
views
MapServer PostgreSQL WHERE clause with UUID column fails
I'm using MapServer with PostgreSQL and I need to be able to limit the query using a UUID field. This column type is not mentioned in the documentation.
I can happily use other field types in the ...
- 9
0
votes
0
answers
203
views
Seeking PostGIS docker image for Mac
I need the PostGIS extension to my PostgreSQL database but I cannot find one that will be compatible to my Mac M1,
I also need the vector extension for the PostgreSQL database.
Can you help me?
- 1