Posts

Showing posts with the label postgis

install postgresql 9.5 postgis 2.1 on ubuntu 16.04 || postgis install in ubantu

First you have to install postgres if you have already install then run this command psql --version it return in my system psql (PostgreSQL) 9.6.2  Now we have to install postgis sudo apt install postgis postgresql- your-pg-version -postgis-2.3 in my case sudo apt install postgis postgresql-9.6-postgis-2.3 create extension for your database sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" your_db_name  In my case sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" gisdata Note: Remember before running this command please make sure you have not created extensions in your migration if you created extension in migration file then you must have to skip this command if you run this command by mistake then comment your extension create migration and run your migration file else you will get an error " Extension already created "