1. system message;
#head -1 / etc / issue
CentOS release 6.5 (Final)
2. Install postgresql 9.3 version;
#rpm -ivh http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
# yum install postgresql93 postgresql93-server postgresql93-libs postgresql93-contrib postgresql93-devel
3. Custom database data path;
Because the local hard disk storage is unreliable, put the data in an existing nfs storage in this environment. This machine has already mounted the nfs in the / storage directory. If there is no such requirement, it can be defaulted.
#vim /etc/init.d/postgresql-9.3
PGDATA = / var / lib / pgsql / 9.3 / data
PGLOG = / var / lib / pgsql / 9.3 / pgstartup.log
PGUPLOG = / var / lib / pgsql / $ PGMAJORVERSION / pgupgrade.log
Modify the above three paths into custom paths as follows: (Actually only need to modify the PGDATA parameter)
PGDATA = / storage / pgsql / 9.3 / data
PGLOG = / storage / pgsql / 9.3 / pgstartup.log
PGUPLOG = / storage / pgsql / $ PGMAJORVERSION / pgupgrade.log
4. Initialize & start the database & join the auto start & check the database status;
#service postgresql-9.3 initdb #initialize
! After the initialization is successful, all the database configuration files are in the custom directory /storage/pgsql/9.3/data
#service postgresql-9.3 start #Start
#chkconfig postgresql-9.3 on #
#service postgresql-9.3 status #View the current running status of postgresql, as follows
postgresql-9.3 (pid 5093) is running ...
5. The configuration database can be connected using the pgAdmin tool under windows or other tools;
#cd /storage/pgsql/9.3/data
#vim postgresql.conf
Uncomment #listen_addresses = ‘localhost’ and comment to listen_addresses = ‘*’
#vim pg_hba.conf
Add "host all all 0.0.0.0/0 md5" at the end of the line to allow all hosts to connect
#su postgres
$ psql -p 5432
$ alter user postgres with password ‘123456’ #Set postgres user password
$ \ q
$ \ exit
# service postgresql-9.3 restart
# service postgresql-9.3 reload
The postgresql database is installed and can be used normally, such as:
6. Install postgis extension & use postgis extension;
#yum install postgis2_93
#su postgres
$ psql -p 5432
$ CREATE EXTENSION postgis;
CREATE EXTENSION
$ \ q
$ \ exit
7. Database changes after installing postgis-;
8. Install phpPgAdmin-easy to manage postgresql database from web pages (similar to phpmyadmin);
#yum list | grep phpPgAdmin # (check that your source has this package)
phpPgAdmin.noarch 5.1-1.rhel6 @ pgdg93
#yum install phpPgAdmin httpd
#vim /etc/httpd/conf.d/phpPgAdmin.conf Make the following changes:
‘‘ ‘
Alias / phpPgAdmin / usr / share / phpPgAdmin
<Location / phpPgAdmin>
Order deny, allow
#Deny from all
#Allow from 192.168.0.0/16
Allow from all
#Allow from :: 1
# Allow from .example.com
</ Location>
‘‘ ‘
service httpd restart
chkconfig httpd on
9. You can now access the administration page using http: //x.x.x.x/phpPgAdmin:
#Login may fail because SELLinux may restrict users from connecting to PostgreSQL, just enter the following command to change
#Execute this command "setsebool -P httpd_can_network_connect_db 1" After successful, you can log in
This article comes from "Yunzhongshan" blog, please keep this source http://jiapeng.blog.51cto.com/6706171/1603590
centos uses yum to install custom install postgresql and postgis extensions already phpPgAdmin