Installation of PostgreSQL database and installation of PostGIS

Source: Internet
Author: User
Tags psql postgis


Installing PostgreSQL

[Plain]View PlainCopy
    1. sudo apt-get install postgresql-9.1 postgresql-contrib-9.1

Where postgresql-contrib-9.1 does not have to be installed, if you do not install it, you may be prompted to install it later using Pgadmin to open the database. If it's too much trouble, install it together.

If you want to install a different version of PostgreSQL, you can use

[Plain]View PlainCopy
    1. sudo apt-cache search PostgreSQL


Installing PostGIS

[Plain]View PlainCopy
    1. sudo apt-get install Postgresql-9.1-postgis

The installation is installed, PostgreSQL is ready to use, if you want to build a PostGIS database, the following steps:

Build the PostGIS Template Library

Switch to Postgres user

[Plain]View PlainCopy
    1. sudo su postgres

New Library Postgis_template

[Plain]View PlainCopy
    1. Createdb postgis_template

Execute PostGIS scripts, these scripts are/usr/share/postgresql/9.1/contrib/postgis-1.5 by default

[Plain]View PlainCopy
    1. psql-d postgis_template-f/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
    2. psql-d postgis_template-f/usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

Modify User Password

[Plain]View PlainCopy
    1. Psql
    2. ALTER USER postgres with PASSWORD ' 111111 ';

Installation of PostgreSQL database and installation of PostGIS (RPM)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.