Install PostGIS records on Ubuntu server

Because the project needs to install Postgresql 9.3 on Ubuntu Server 14.04 , PostGIS 2.1

1. Installation Instructions postgresql 9.3, PostGIS 2.1 procedure See HTTP://TRAC.OSGEO.ORG/POSTGIS/WIKI/USERSWIKIPOSTGIS21UBUNTUPGSQL93APT

Install pgadmin 1.18.1 is a graphical management tool that can be installed on desktop Linux.

Ubuntu server itself does not hold the apt-add-repository command and needs to run sudo apt-get install python-software-properties and sudo apt-get Install Software-properties-common installs the relevant package, in the desktop version can be used directly.

2. Need to change configuration after installation allow remote connection of management tools

Modify the configuration file for PostgreSQL/etc/postgresql/8.1/main/postgresql.conf, one of the sentences:
listen_address= ' localhost '
The previous comment is removed and the ' localhost ' should be ' * '.
Modify the configuration file for PostgreSQL/etc/postgresql/8.1/main/pg_hba.conf, add a sentence after the file:
Host all 192.168.0.0/24 password
The 192.168.0.* machine in the same network can use all the databases in the form of a password. More
The parameter meaning of the body can be viewed directly from the comments in the configuration file.
This must be configured correctly, otherwise the PostgreSQL database cannot be connected remotely.

After the above installation process, the Pgadmin can be installed on other machines , and the data should be managed remotely .

Install PostGIS records on Ubuntu server