Linux downloads (Red Hat family)

The Red Hat family of distributions includes Red Hat Enterprise Linux, CentOS, Fedora, Scientific Linux, Oracle Linux and others. PostgreSQL is available on these platforms by default. However, each version of the platform normally "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of this platform. Since this can often mean a different version than preferred, the PostgreSQL project provides a repository of packages of all supported versions for the most common distributions.

Included in distribution

These distributions all include PostgreSQL by default. To install PostgreSQL from these repositories, use the yum command:

yum install postgresql-server

Which version of PostgreSQL you get will depend on the version of the distribution:

Distribution Version
RHEL/CentOS/SL/OL 7 9.2
RHEL/CentOS/SL/OL 6 8.4(also supplies package postgresql92)
RHEL/CentOS/SL/OL 5 8.1 (also supplies package postgresql84)
Fedora 22 9.4
Fedora 21 9.3
Fedora 20 9.3
Other Red Hat family distributions may ship a different version of PostgreSQL by default, check with your distribution vendor to be sure.

The repository contains many different packages including third party addons. The most common and important packages are (substitute the version number as required):

  • postgresql-client libraries and client binaries
  • postgresql-server core database server
  • postgresql-contrib additional supplied modules
  • postgresql-devel libraries and headers for C language development
  • pgadmin3 - pgAdmin III graphical administration utility


Due to policies for Red Hat family distributions, the PostgreSQL installation will not be enabled for automatic start or have the database initialized automatically. To make your database installation complete, you need to perform these two steps: service postgresql initdb
chkconfig postgresql on
or, on Fedora 19 and other later derived distributions:
postgresql-setup initdb
systemctl enable postgresql.service

PostgreSQL Yum Repository

If the version supplied by your operating system is not the one you want, you can use the PostgreSQL Yum Repository. This repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL.

The PostgreSQL yum repository currently supports Red Hat Enterprise Linux, CentOS, Oracle Enterprise Linux and Scientific Linux versions 5.x, 6.x, and 7.x, as well as current versions of Fedora. Note that due to the shorter support cycle on Fedora, all versions are not available on this platform, and we recommend not using Fedora for server deployments. All distributions are supported on both x86_64 and i386 architectures.

To use the yum repository, you must first install the repository RPM. To do this, download the correct RPM from the repository RPM listing, and install it with commands like:

yum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm

Once this is done, you can proceed to install and update packages the same way as the ones included in the distribution.

yum install postgresql94-server postgresql94-contrib
service postgresql-9.4 initdb
chkconfig postgresql-9.4 on
or, on Fedora 19 and other later derived distributions:
yum install postgresql94-server postgresql94-contrib
/usr/pgsql-9.4/bin/postgresql94-setup initdb
systemctl enable postgresql-9.4.service
systemctl start postgresql-9.4.service

Package names in the PostgreSQL yum repository follows the same standard as the ones included in the main repositories, but include the version number, such as:

  • postgresql94
  • postgresql94-server
  • postgresql94-contrib
  • pgadmin3_94

Direct RPM download

If you cannot, or do not want to, use the yum based installation method, all the RPMs that are in the yum repository are available for direct download and manual installation as well.

Cross distribution packages

Generic RPM and DEB packages that provide a server-only distribution are avaliable for some 32 and 64-bit Linux distributions. These packages provide a single set of binaries and consistent packaging across different Linux distributions. They are designed for server installation where a GUI is not available and consistency across multiple distributions is a requirement.

Download the packages from OpenSCG for all supported versions.

Note: The cross distribution packages do not fully integrate with the platform-specific packaging systems.

Graphical installer

Installers are available for 32 and 64-bit Linux distributions and include PostgreSQL, pgAdmin and the StackBuilder utility for installation of additional packages.

Download the installer from EnterpriseDB for all supported versions.

Note: The installers do not integrate with platform-specific packaging systems.

Build from source

The source code can be found in the main file browser. Instructions for building from source can be found in the documentation.


조회 수 :
등록일 :
20:26:45 (*.175.161.172)
엮인글 :
게시글 주소 :
List of Articles
번호 제목 글쓴이 날짜 조회 수
49 [MYSQL]테이블 크기 확인 Cheeryj 2017-05-01 3231
48 [MYSQL]GROUP_CONCAT persona 2016-10-28 3051
47 Get size of all tables in database persona 2016-10-20 27814
46 Enterprise manager에서 한글로 바뀌는 문제 persona 2016-10-20 1392
45 View the Definition of a Stored Procedure persona 2016-08-03 3743
44 [MSSQL] 테이블 프로시저 존재 체크 persona 2016-07-28 2547
43 [MSSQL] Collation persona 2016-06-23 3975
42 [MSSQL] RESTORE할 때 오류 persona 2016-06-21 2974
41 [MSSQL] Resetting SQL Server Identity Columns: persona 2016-06-20 1783
40 [MSSQL]using SQLCMD persona 2016-06-05 6392
39 PostgreSQL 설치 & 사용법 정리 persona 2016-05-05 22815
» [PostgreSQL]설치 persona 2016-04-30 37289
37 [MSSQL] Index 리스트 얻기 persona 2016-04-07 7799
36 MySQL EXPORT & IMPORT [1] persona 2016-02-20 5027
35 MySQL via MERGE table engine: persona 2015-10-15 14531
34 MySQL charset encoding [1] persona 2015-06-12 5551
33 SQL SERVER INSTANACE LIST persona 2015-04-17 4488
32 SQL JOIN file Cheeryj 2015-03-25 5634
31 SQL SERVER SINGLE USER MODE persona 2015-03-17 6084
30 MSSQL FILESTREAM 활성화 persona 2015-03-17 5569