How to install PostgreSQL 7/6 and phpPgAdmin in CentOS 5/6. 4
PostgreSQL is a powerful open-source object relational database system that runs on almost all major operating systems, including Linux, Unix (AIX, BSD, HP-UX, sgi irix, Mac OS, Solaris, Tru64), and Windows OS. In this tutorial, we will learn how to create PostgreSQL in CentOS7/6.5/6.4 server.
postgresql ui
1. Install PostgreSQL
First,postgresql update inner join add the PostgreSQL library based on your server architecture:
For CentOS 6.x 32bit:
Rpm-uv h http://yum.postgresql.org/9.3/RedHat/rhel-6-i386/pgdg-centos93-9.3-1. noarch. rpm
For CentOS 6.x 64bit:
Rpm-Uvh http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
For CentOS 7 64bit:
Rpm-Uvh http://yum.postgresql.org/9.3/redhat/rhel-7-x86_64/pgdg-centos93-9.3-1.noarch.rpm
For other releases, you can view the following links and create a Library:
Http://yum.postgresql.org/repopackages.php#pg93
Run the following command to update the database:postgresql varchar or text
Yum update
Run the following command to install PostgreSQL:
Yum install postgresql93-server postgresql93-contrib
Run the following command to initialize the PostgreSQL database:postgresql synchronous_commit
In CentOS 6.x:
Service postgresql-9.3 initdb
In CentOS 7:
/Usr/pgsql-9.3/bin/postgresql93-setup initdb
Then start the PostgreSQL service and enable it:
In CentOS 6.x:
Service postgresql-9.3 start
Chkconfig postgresql-9.3 on
In CentOS 7:
Systemctl enable postgresql-9.3
Systemctl start postgresql-9.3
2. Adjust Iptables/Firewall
Next, adjust the firewall outbound rules:
In CentOS 6. x:
Vi/etc/sysconfig/iptables
And add the following lines
-A input-m state -- state NEW-m tcp-p tcp -- dport 5432-j ACCEPT
-A input-m state -- state NEW-m tcp-p tcp -- dport 80-j ACCEPT
Exit and save the file. Restart the iptables service:
Service iptables restart
In CentOS:
Firewall-cmd -- permanent-add-port = 5432/tcp
Firewall-cmd -- permanent-add-port = 80/tcp
Firewall-cmd -- reload
3. Access common PostgreSQL Command Prompt
By default, both the Database Name and user name are ipvs. Switch to the user for related operations: pgbouncer in postgresql
Su-postgres
Enter the following command to log on:
Psql
The following is an example output:
Psql (9.3.5)
Type "help" for help.
Postgres = #
You can enter \ q to exit the postgresql return command terminal: phppgadmin postgresql 11
4. Set the User Password
Log on to the postgres command prompt Interface
Su-postgres
Psql
Then use the command to set the password
Postgres = # \ password postgres
Enter new password:
Enter it again:
Postgres = # \ q
Enter the command to create a PostgreSQL system management tool
S = # create extension adminpack;
CREATE EXTENSION
5. Create users and databases
Example: Username: senthil password: centos Database Name: mydb
To postgres user
Su-postgres
Create user senthil
$ Createuser senthil
Create a database
$ Createdb mydb
Log on to the psql prompt page and set a password for senthil and authorize access to mydb:
$ Psql
Psql (9.3.5)
Type "help" for help.
Postgres = # alter user senthil with encrypted password 'centos ';
ALTER ROLE
Postgres = # grant all privileges on database mydb to senthil;
GRANT
Postgres = #
6. delete users and databases
First go to postgres Interface
Su-postgres
Enter the command
$ Dropdb <database-name>
You can enter the delete user name.
$ Dropuser <user-name>
7. Configure PostgreSQL-MD5 Authentication
MD5 authentication requires the client to provide a MD5-encrypted password for authentication. You need to edit the/var/lib/pgsql/9.3/data/pg_hba.conf file:postgresql tutorial pdf
Vi/var/lib/pgsql/9.3/data/pg_assist.conf
The added or modified rows are as follows:
[...]
# TYPE DATABASE USER ADDRESS METHOD
# "Local" is for Unix domain socket connections only
Local all md5
# IPv4 local connections:
Host all 127.0.0.1/32 md5
Host all 192.168.1.0/24 md5
# IPv6 local connections:
Host all: 1/128 md5
[...]
Restart the postgresql service to change the application
In CentOS 6. x System
Service postgresql-9.3 restart
In CentOS 7
Systemctl restart postgresql-9.3
8. Configure PostgreSQL-Configure TCP/IP
By default, TCP/IP connections are not feasible, so other computer users cannot connect to postgresql. You can edit the file/var/lib/pgsql/9.3/data/postgresql. conf to allow connections:
Vi/var/lib/pgsql/9.3/data/postgresql. conf
Find the following line:
[...]
# Listen_addresses = 'localhost'
[...]
# Port = 5432
[...]
Cancel the two lines and set them to your postgresql Server IP address or set it to "*" to listen to all clients. As follows:
Listen_addresses = '*'
Port = 5432
Restart to apply changes
In CentOS6.x:
/Etc/init. d/postgresql-9.3 restart
In CentOS7:
Systemctl restart postgresql-9.3
9. Use phpPgAdmin to manage PostgreSQL
PhpPgAdmin is a web-based management tool written in PHP to manage PostgreSQL. It is only applicable to PostgreSQL RPM databases.
If you have not added a PostgreSQL database, you can add an EPEL database.
You can create an EPEL library in CentOS 6. x based on the following links.
Http://www.unixmen.com/install-epel-repository-rhel-centos-scientific-linux-6/
For CentOS 7, refer to the following link.
Http://www.unixmen.com/install-epel-repository-centos-rhel-7/
Use commands to update Libraries
Yum update
Run the following command to install phpPgAdmin:
Yum install phpPgAdmin httpd
Note that phpPgAdmin is case sensitive. Make sure that the above case is correct!
By default, you can use http: // localhost/phpPgAdmin to access phpPgAdmin. To continue remote access:
Edit the/etc/httpd/conf. d/phpPgAdmin. conf file.
Vi/etc/httpd/conf. d/phpPgAdmin. conf
Modify the following bold parts:
[...]
Alias/phpPgAdmin/usr/share/phpPgAdmin
<Location/phpPgAdmin>
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
# Require host example.com
</IfModule>
<IfModule! Mod_authz_core.c>
# Apache 2.2
Order deny, allow
Allow from all
# Allow from .example.com
</IfModule>
</Location>
Start or restart the Apache service
In CentOS 6. x System
Service httpd start
Chkconfig httpd on
In CentOS 7
Systemctl enable httpd
Systemctl start httpd
Now open the browser and go to http: // ip-address/phpPgAdmin. Finally, we can see the following interface!
Log On with the user you created earlier. My account is the senthil password CentOS.
You may encounter: Login failed.
This is because SELLinux may restrict users from connecting to PostgreSQL. Just enter the following command to change it:
Setsebool-P httpd_can_network_connect_db 1
Now you should be able to log on normally.
My phpPgAdimn is as follows:
OK! Now you can use phpPgAdmin on the graphic interface to create, delete, and manage databases.
How To Install PostgreSQL 9.3 And phpPgAdmin In CentOS 7/6. 5/6. 4
To learn more about the author, visit the customer's home.
This article is launched by the help translation team's original translation help house.
This article permanently updates the link address:
------------------------------------ Lili split line ------------------------------------
Install PostgreSQL 6.3 on yum in CentOS 9.3
PostgreSQL cache details
Compiling PostgreSQL on Windows
Configuration and installation of LAPP (Linux + Apache + PostgreSQL + PHP) Environment in Ubuntu
Install and configure phppgAdmin on Ubuntu
Install PostgreSQL9.3 on CentOS
Configure a Streaming Replication cluster in PostgreSQL
------------------------------------ Lili split line ------------------------------------
PostgreSQL details: click here
PostgreSQL: click here