See how you can leverage Mergin Maps platform API to sync between QGIS and PostgreSQL/PostGIS database by Mergin-DB-Sync tool.
We follow quick start available on github.com/MerginMaps/mergin-...
1) Setup PG container
- curl raw.githubusercontent.com/Mer... -o test_data.sql
- docker run --name some-postgis -v $(pwd):/opt/hostdata -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgis/postgis
- docker exec -ti some-postgis psql -U postgres -c "CREATE DATABASE dbsync OWNER postgres"
- docker exec -ti some-postgis psql -U postgres -d dbsync -c "CREATE EXTENSION postgis;"
- docker exec -ti some-postgis psql -U postgres -d dbsync -f /opt/hostdata/test_data.sql
2) create config file
- curl raw.githubusercontent.com/Mer... -o config.yaml
- cat config.yaml
mergin:
url: app.merginmaps.com
username: REPLACE_your_username
password: REPLACE_your_password
init_from: db
connections:
- driver: postgres
conn_info: "host=127.0.0.1 dbname=dbsync user=postgres password=mysecretpassword"
modified: sync_data
base: sync_data_base
mergin_project: REPLACE_your_workspace/REPLACE_your_project_name
sync_file: data.gpkg
daemon:
sleep_time: 10
3) create blank project on app.merginmaps.com
4) start deamon
- docker run --name mergin_db_sync -it --network="host" -v $(pwd):/settings lutraconsulting/mergin-db-sync:latest /settings/config.yaml
Need support with more complicated setups?
- merginmaps.com/community/join
- merginmaps.com/support
See more: merginmaps.com
Негізгі бет How to connect PostGIS and Mergin Maps
Пікірлер: 10