Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching QGIS User0015 - PostGIS Setup. and this video is uploaded by Klas Karlsson at 2019-05-29T04:10:55-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [EBfjZgjyZmM]
| Name | QGIS User0015 - PostGIS Setup |
| Video Uploader | Video From Klas Karlsson |
| Upload Date | This Video Uploaded At 29-05-2019 11:10:55 |
| Video Discription | In this video you learn how to install and setup PostGIS on a Linux Server. The steps I use are: 1. Install Ubuntu Server 2. Update all packages sudo apt update && sudo apt upgrade 3. Install PostGIS sudo apt install postgis 3b If missing packages: sudo apt install --fix-missing 4. Set the system password for the "postgres" user sudo passwd postgres (fill in new password and confirm) 5. Create a new database (I'm naming mine geodata) sudo -u postgres createdb geodata 6. Connect to the database sudo -u postgres psql geodata 7. Set the internal postgres user password \password postgres (fill in password and confirm) 8. Log out of postgres, and log back in \q sudo -u postgres psql geodata 9. Create the PostGIS extension create extension postgis; 10 Check the PostGIS version select PostGIS_version(); 11 Exit postgresql \q 12 Edit configfiles postgres.conf and pg_hba.conf postgresql.conf: listen_addresses = '*' pg_hba.conf add: host all all 192.168.0.1/24 md5 13 Restart postgresql sudo service postgresql restart 14 Connect with QGIS... [EBfjZgjyZmM] |
| Category | Science & Technology |
| Tags | QGIS | PostGIS | Linux | Server | VirtualBox | Geodata | Geospatial |
