Changes between Version 5 and Version 6 of UsersWikiPostGIS20CentOS6pgdg
- Timestamp:
- 10/12/12 02:12:59 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiPostGIS20CentOS6pgdg
v5 v6 30 30 A PGDG RPM file needs to be downloaded for your platform and your PostgreSQL version requirements (you can choose the later). Find the correct RPM file for your system from here: http://yum.postgresql.org/repopackages.php 31 31 32 For example, if you have a 64-bit OS and want to install PostgreSQL 9. 1:32 For example, if you have a 64-bit OS and want to install PostgreSQL 9.2: 33 33 {{{ 34 curl -O http://yum.postgresql.org/9. 1/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm35 rpm -ivh pgdg-centos9 1-9.1-4.noarch.rpm34 curl -O http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-6.noarch.rpm 35 rpm -ivh pgdg-centos92-9.2-6.noarch.rpm 36 36 }}} 37 37 … … 46 46 Install everything with: 47 47 {{{ 48 yum install postgresql9 1-server postgis2_9148 yum install postgresql92-server postgis2_92 49 49 }}} 50 50 51 51 Now perform a few post-installation setup commands, in the order: (1) Initialize the database cluster (required), (2) start database (recommended, if you want to use it straight away), (3) allow it to start-up automatically on reboot (recommended): 52 52 {{{ 53 service postgresql-9. 1initdb54 service postgresql-9. 1start55 chkconfig postgresql-9. 1on53 service postgresql-9.2 initdb 54 service postgresql-9.2 start 55 chkconfig postgresql-9.2 on 56 56 }}} 57 57 58 58 == Spatially enabling a database == 59 Spatially enabling a database using extensions is a new feature of PostgreSQL 9. 1.59 Spatially enabling a database using extensions is a new feature of PostgreSQL 9.2. 60 60 61 61 Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support: