In CentOS6.3 environment, yum installs PostgreSQL9.3

PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system.

PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system.

PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial databases. This database research program originated from Berkeley (BSD) has now been developed into an international development project and has a wide range of users.

The following describes how yum installs ipvs 6.3 In CentOS 9.3.

------------------------------------ Lili split line ------------------------------------

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 ------------------------------------

1. View installed packages

# Rpm-qa | grep postgres

If it already exists

// Uninstall

# Rpm e postgresql92-server-9.2.4-1PGDG.rhel6.i686

# Rpm e postgresql92-contrib-9.2.4-1PGDG.rhel6.i686

# Rpm e postgresql92-9.2.4-1PGDG.rhel6.i686

# Rpm e postgresql92-libs-9.2.4-1PGDG.rhel6.i686

2. Install yum

Yum install
Yum install postgresql93-server postgresql93-contrib

// Initialization
Service postgresql-9.3 initdb

Enable
Service postgresql-9.3 start or

/Etc/init. d/postgresql-9.3 start

View installation results

Rpm-aq | grep postgres

We can see that

[Root @ i-87-575-VM vmuser] # rpm-aq | grep postgres
Postgresql93-libs-9.3.4-1PGDG.rhel6.x86_64
Postgresql93-contrib-9.3.4-1PGDG.rhel6.x86_64
Postgresql93-9.3.4-1PGDG.rhel6.x86_64
Postgresql93-server-9.3.4-1PGDG.rhel6.x86_64

The installation is complete.

3. Test
[Root @ i-87-575-VM vmuser] # su-postgres
-Bash-4.1 $ psql-l
The default password is blank. We need to change it to the specified password, which is set to 'codecs' here '.
-Bash-4.1 $ psql

By default, PostgreSQL creates an ipvs database user as the database administrator. The default password is blank. We need to change it to the specified password, which is set to 'ipvs '.
# Alter user Login s with password 'login s ';
# Select * from pg_shadow;

For more detailed information, see