Install PostgreSQL on CentOS
— filed under: PostgreSQL, CentOS
How to install PostgreSQL Server on CentOS
1. Download yum repository rpm for your arch and version you want to use:
http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html
2. install rpm file
rpm -i <file>.rpm
3. modify CentOS Repository
vi /etc/yum.repos.d/CentOS-Base.repo
add this line:
exclude=postgresql*
should look like this:
[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
exclude=postgresql*
4. install PostgreSQL
yum install postgresql-server
5.initialize PostgreSQL-Database
service postgresql initdb
6. start service
service postgresql start
7. if you want postgresql to be started at boot time run this:
chkconfig --levels 35 postgresql on
— filed under: PostgreSQL, CentOS
How to install PostgreSQL Server on CentOS
1. Download yum repository rpm for your arch and version you want to use:
http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html
2. install rpm file
rpm -i <file>.rpm
3. modify CentOS Repository
vi /etc/yum.repos.d/CentOS-Base.repo
add this line:
exclude=postgresql*
should look like this:
[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
exclude=postgresql*
4. install PostgreSQL
yum install postgresql-server
5.initialize PostgreSQL-Database
service postgresql initdb
6. start service
service postgresql start
7. if you want postgresql to be started at boot time run this:
chkconfig --levels 35 postgresql on