CentOS: how to install postgresql 9.1

The page gives a short installation sequence for PostgreSQL 9.1 on CentOS. It downloads and installs the pgdg repository RPM, adds a yum exclude rule for PostgreSQL in the CentOS Base repo, then installs the server package, initializes the database, starts the service, and enables it at boot. It also points to the PostgreSQL wiki for streaming replication.

Reading notes

#

• Download the pgdg CentOS 9.1 repository RPM with wget and install it with rpm.
• Add exclude=postgresql* to the end of the [base] and [updates] sections in /etc/yum.repos.d/CentOS-Base.repo.
• Install postgresql91-server with yum.
• Initialize the database with service postgresql-9.1 initdb.
• Start PostgreSQL with service postgresql-9.1 start.
• Enable PostgreSQL at boot with chkconfig postgresql-9.1 on.
• For replication, consult the official PostgreSQL wiki page on streaming replication.