Skip to content

Instantly share code, notes, and snippets.

@luqmanrom

luqmanrom/install_postgresql9.4_postgis2.1_ubuntu.md

Forked from ansell/install_postgresql9.4_postgis2.1_ubuntu.md
Last active September 30, 2018 00:43
Show Gist options
  • Save luqmanrom/ebed0b29ba03fd22c66d9ea80e109bb0 to your computer and use it in GitHub Desktop.
Save luqmanrom/ebed0b29ba03fd22c66d9ea80e109bb0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. luqmanrom revised this gist Sep 30, 2018. 1 changed file with 7 additions and 0 deletions.
    7 changes: 7 additions & 0 deletions install_postgresql9.4_postgis2.1_ubuntu.md
    View file
    Original file line number Diff line number Diff line change
    @@ -11,6 +11,13 @@ The first step is to remove older version of PostGIS if any.
    ## Install PostgreSQL and PostGIS

    sudo apt-get update && sudo apt-get install postgresql-9.4-postgis-2.1 -f


    ## Create role

    sudo -u postgres -i

    https://stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-exist

    ## Enable PostGIS extension

  2. @ansell ansell renamed this gist Jun 6, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions install_postgresql9.3_postgis2.1_ubuntu.md → install_postgresql9.4_postgis2.1_ubuntu.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,7 +10,7 @@ The first step is to remove older version of PostGIS if any.

    ## Install PostgreSQL and PostGIS

    sudo apt-get update && sudo apt-get install postgresql-9.3-postgis-2.1 -f
    sudo apt-get update && sudo apt-get install postgresql-9.4-postgis-2.1 -f

    ## Enable PostGIS extension

    @@ -30,7 +30,7 @@ This is an old method of doing the same. Creating a template for PostGIS will m

    Now, we have to run an SQL script comes along with PostGIS in the template:

    psql -d template_postgis2.1 -f /usr/share/postgresql/9.3/extension/postgis--2.1.5.sql
    psql -d template_postgis2.1 -f /usr/share/postgresql/9.4/extension/postgis--2.1.5.sql
    psql -d template_postgis2.1 -c "GRANT ALL ON geometry_columns TO PUBLIC;"
    psql -d template_postgis2.1 -c "GRANT ALL ON geography_columns TO PUBLIC;"
    psql -d template_postgis2.1 -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
    @@ -51,7 +51,7 @@ In test_db you can run the following statement to make sure that you installed a
    ### Enable PostGIS for an existing Database
    If you don’t want to use the `CREATE EXTENSION` statement and want to enable PostGIS for an already existing database. It is simple enough, you just need to run the PostGIS 2.1 script in your database:

    psql -d test_db -f /usr/share/postgresql/9.3/extension/postgis--2.1.5.sql
    psql -d test_db -f /usr/share/postgresql/9.4/extension/postgis--2.1.5.sql

    ----------------------------------------------------
    inspiration http://technobytz.com/install-postgis-postgresql-9-3-ubuntu.html
  3. @hewerthomn hewerthomn renamed this gist Feb 19, 2015. 1 changed file with 0 additions and 0 deletions.
    0 install_postgresql9.3_postgis2.1_ubuntu → install_postgresql9.3_postgis2.1_ubuntu.md
    View file
    File renamed without changes.
  4. @hewerthomn hewerthomn created this gist Feb 19, 2015.
    57 changes: 57 additions & 0 deletions install_postgresql9.3_postgis2.1_ubuntu
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,57 @@
    ## Remove old PostGIS Installation
    The first step is to remove older version of PostGIS if any.

    sudo apt-get purge postgis

    ## Setup repository

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
    sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" >> /etc/apt/sources.list.d/postgresql.list'

    ## Install PostgreSQL and PostGIS

    sudo apt-get update && sudo apt-get install postgresql-9.3-postgis-2.1 -f

    ## Enable PostGIS extension

    Now, let’s see how we can create a PostGIS enabled database. We have two ways of doing this, in which the first one is the latest and simple one:

    ### 1. Using the CREATE EXTENSION statement
    This is as simple as running a query in the database where you want to enable PostGIS:

    CREATE EXTENSION postgis;
    OR

    ### 2. Create database template for PostGIS
    This is an old method of doing the same. Creating a template for PostGIS will make it easy to enable PostGIS for every new database you create:

    createdb -E UTF8 template_postgis2.1
    psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis2.1'"

    Now, we have to run an SQL script comes along with PostGIS in the template:

    psql -d template_postgis2.1 -f /usr/share/postgresql/9.3/extension/postgis--2.1.5.sql
    psql -d template_postgis2.1 -c "GRANT ALL ON geometry_columns TO PUBLIC;"
    psql -d template_postgis2.1 -c "GRANT ALL ON geography_columns TO PUBLIC;"
    psql -d template_postgis2.1 -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"

    ### Create a test database
    Let’s test the PostGIS installation by creating a test database:

    createdb test_db -T template_postgis2.1

    ### Test the installation
    In test_db you can run the following statement to make sure that you installed and configured PostGIS correctly:

    test_db=# select postgis_version();
    postgis_version---------------------------------------
    2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
    (1 row)

    ### Enable PostGIS for an existing Database
    If you don’t want to use the `CREATE EXTENSION` statement and want to enable PostGIS for an already existing database. It is simple enough, you just need to run the PostGIS 2.1 script in your database:

    psql -d test_db -f /usr/share/postgresql/9.3/extension/postgis--2.1.5.sql

    ----------------------------------------------------
    inspiration http://technobytz.com/install-postgis-postgresql-9-3-ubuntu.html