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.
PostgreSQL Yum Repository
The PostgreSQL Yum 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
Rocky Linux
CentOS
Scientific Linux
Oracle Linux
Fedora *
* Note: due to the shorter support cycle on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend using Fedora for server deployments.
To use the PostgreSQL Yum Repository, follow these steps:
Select version:
Select platform:
Select architecture:
Copy, paste and run the relevant parts of the setup script:
Included in Distribution
These distributions all include PostgreSQL by default. To install PostgreSQL from these repositories, use the yum command on RHEL 6 and 7:
yum install postgresql-server
or dnf command on RHEL 8 and Fedora:
dnf install postgresql-server
Which version of PostgreSQL you get will depend on the version of the distribution:
Distribution
Version
RHEL/Rocky Linux/CentOS/OL 8
13, 12, 10 and 9.6 via modules
RHEL/CentOS/SL/OL 7
9.2 (also supplies package rh-postgresql10, rh-postgresql96, rh-postgresql95 and rh-postgresql94 via SCL)
RHEL/CentOS/SL/OL 6
8.4 (also supplies package rh-postgresql96, via SCL)
Fedora 34
13
Fedora 33
12
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
Post-installation
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 the following steps, based on your distribution:
For RHEL / CentOS / SL / OL 6
For RHEL / Rocky Linux / CentOS / SL / OL 7, 8 or Fedora 31 and later derived distributions:
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.
PostgreSQL is available in all Ubuntu versions by default. However, Ubuntu «snapshots» a specific version of PostgreSQL that is then supported throughout the lifetime of that Ubuntu version. Other versions of PostgreSQL are available through the PostgreSQL apt repository.
PostgreSQL Apt Repository
If the version included in your version of Ubuntu is not the one you want, you can use the PostgreSQL Apt 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 Apt Repository supports the current versions of Ubuntu:
on the following architectures:
amd64
arm64 (18.04 and newer; LTS releases only)
i386 (18.04 and older)
ppc64el (LTS releases only)
To use the apt repository, follow these steps:
For more information about the apt repository, including answers to frequent questions, please see the PostgreSQL Apt Repository page on the wiki.
Included in distribution
Ubuntu includes PostgreSQL by default. To install PostgreSQL on Ubuntu, use the apt-get (or other apt-driving) command:
apt-get install postgresql-12
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-12
client libraries and client binaries
postgresql-12
core database server
postgresql-contrib-9.x
additional supplied modules (part of the postgresql-xx package in version 10 and later)
libpq-dev
libraries and headers for C language frontend development
postgresql-server-dev-12
libraries and headers for C language backend development
PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself.
Packages and Installers
Select your operating system family:
Select your Linux distribution:
Select your BSD operating system:
Source code
The source code can be found in the main file browser or you can access the source control repository directly at git.postgresql.org. Instructions for building from source can be found in the documentation.
Beta/RC Releases and development snapshots (unstable)
There are source code and binary packages of beta and release candidates, and of the current development code available for testing and evaluation of new features. Note that these builds should be used for testing purposes only, and not for production systems.
3rd party distributions
Machine Learning and Data Visualization with PostgreSQL
Download 2UDA for Windows, macOS, and Linux — certified by 2ndQuadrant for all supported versions of PostgreSQL.
2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, machine learning, data mining, and visualization. The application can be installed using a user-friendly, one-click desktop installer. 2UDA builds on the capabilities of Orange, an open source machine learning and data visualization tool, by integrating it with the PostgreSQL database.
Ready to run stacks
‘LAPP’, ‘MAPP’ and ‘WAPP’ (Linux/Mac/Windows + Apache + PHP + PostgreSQL) stacks are available from BitNami.
Additional Software
Software Catalogue
There is much software available that is not bundled with PostgreSQL. The Software Catalogue offers a listing of many commercial and Open Source applications, interfaces and extensions to PostgreSQL that you may find useful.
If you wish to have your product listed in the catalogue, please fill out this form.
File Browser
You can download most of the software we publish from a mirror site using our File Browser.
PostgreSQL is available in all Debian versions by default. However, the stable versions of Debians «snapshot» a specific version of PostgreSQL that is then supported throughout the lifetime of that Debian version. The PostgreSQL project also maintains an apt repository with all supported of PostgreSQL available.
PostgreSQL Apt Repository
If the version included in your version of Debian is not the one you want, you can use the PostgreSQL Apt 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 apt repository supports the currently supported stable versions of Debian:
on the following architectures:
amd64
arm64 (Buster and newer)
i386 (Buster and older)
ppc64el
To use the apt repository, follow these steps:
For more information about the apt repository, including answers to frequent questions, please see the apt page on the wiki.
Included in distribution
Debian includes PostgreSQL by default. To install PostgreSQL on Debian, use the apt-get (or other apt-driving) command:
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-12
client libraries and client binaries
postgresql-12
core database server
postgresql-contrib-9.x
additional supplied modules (part of the postgresql-xx package in version 10 and later)
libpq-dev
libraries and headers for C language frontend development
postgresql-server-dev-12
libraries and headers for C language backend development
AspSQLProvider is a PostgreSQL implementation of the ASP.NET 2.0 Membership, Role, Profile and Session-State Store Provider.
Open source
Nauck IT KG
View
DBD::Pg
Description
License
Pricing
Publisher
PostgreSQL database driver for the Perl DBI module
Open source
Greg Sabino Mullane
View
dbExpress driver for PostgreSQL
Description
License
Pricing
Publisher
dbExpress Driver for PostgreSQL is a database-independent layer that defines common interface to provide fast access to PostgreSQL from from Delphi and C++Builder, including Community Edition, on Windows and macOS (32-bit and 64-bit) and Linux (64-bit) platforms. For this server, dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures.
As data-access layer is thin and simple, dbExpress provides high performance database connectivity and is easy to deploy. You can use dbExpress driver for PostgreSQL in the same way as the one supplied by Embarcadero.
Direct Mode
Allows your application to work with PostgreSQL directly without involving PostgreSQL connectivity solutions, thus significantly facilitating deployment and configuration of your applications.
DB Compatibility
Our product supports PostgreSQL server versions from 8 to 12, Microsoft Azure Database for PostgreSQL, Amazon RDS for PostgreSQL; Amazon Aurora, and Google Cloud for PostgreSQL.
IDE Compatibility
Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney. It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.
Learn more about dbExpress Driver for PostgreSQL on Devart website.
Commercial
139.95
Devart
View
dotConnect for PostgreSQL
Description
License
Pricing
Publisher
dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.
Our ADO.NET PostgreSQL provider supports a wide range of PostgreSQL-specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.
Key Features
Advanced Visual Studio Integration. dotConnect for PostgreSQL provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.
PostgreSQL support: from 7.1 to 13
Visual Studio support: 2008 – 2019
Full .NET Framework 2.0 – 4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and above
Mono 2.0 and above
Entity Framework v1 — v6
Entity Framework Core 1.x, 2.x, 3.1, and 5.0
Commercial
$159.95
Devart
View
Excel Add-in for PostgreSQL
Description
License
Pricing
Publisher
Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data and save them back to PostgreSQL.
Use Excel to work with PostgreSQL data, easily perform data cleansing and de-duplication. Apply all the Excel’s powerful data processing and analysis capabilities to these data.
Connect to PostgreSQL Directly from Excel
To connect Excel to PostgreSQL you just need to specify its host, port, and your credentials. As for security, PostgreSQL Excel Add-in supports secure SSL connections, secure authentication with single sign-on, etc. Connection information may optionally be stored in the Excel file, or you may reenter it whenever necessary.
Use Query Builder or SQL to Import Data You Need
Visual Query Builder allows you to choose a table to import data from, select the columns from this table and related tables, and set filter conditions and data ordering options visually. If you need to select data more precisely, you can use SQL to select data you need.
Instantly Refresh Data Whenever You Need
It’s very convenient to always have fresh data from the database right in your workbook. Imagine, you have performed data analysis in your Excel workbook, built some charts for your PostgreSQL data, and you can re-read data from the source and update all this to the current state by just clicking a button on the ribbon whenever you need.
Edit PostgreSQL Data Like Usual Excel Spreadsheets
To edit PostgreSQL data in Excel you need just to click the Edit Mode button on the ribbon before editing, and then you can edit data just like you usually do it — add or delete rows, modify cell values, etc. All the changes are highlighted so you can easily see which data is changed.
Instant Data Validation
Excel Add-in for PostgreSQL instantly validates entered data and highlights errors, such as incorrect dates, duplicate primary key values, etc.
Learn more about Excel add-in for PostgreSQL on Devart website.
Commercial
$119.95
Devart
View
libpqxx
Description
License
Pricing
Publisher
libpqxx is the official C++ client API for PostgreSQL, the enterprise-strength open-source database software.
Open source
pqxx.org
View
LinqConnect
Description
License
Pricing
Publisher
LinqConnect is a fast, lightweight, and easy to use LINQ to SQL compatible ORM solution, supporting PostgreSQL, SQL Server, Oracle, MySQL and SQLite. It allows using efficient and powerful data access for your .NET Framework, Metro, Silverlight, or Windows Phone applications supporting Code-First, Model-First, Database-First or mixed approaches.
LINQ to SQL Compatible.
LinqConnect was developed closely to LINQ to SQL and retains full compatibility with it. Interface of the LinqConnect classes is compatible with LINQ to SQL ones. If you are a LINQ to SQL developer, you don’t need to learn much and can start developing with LinqConnect immediately.
Unlike LINQ to SQL, LinqConnect is an actively developed and supported product, and it offers a number of benefits over LINQ to SQL. It supports more database servers, more development platforms, more LINQ features, more mapping kinds, provides better performance, etc.
Multiple
Starts from $149.95
Devart
View
Lua binding for PostgreSQL
Description
License
Pricing
Publisher
Access your PostgreSQL data from the Lua programming language. luapgsql is a libpq binding for Lua.
Open source
micro systems
View
Npgsql
Description
License
Pricing
Publisher
Npgsql is a .Net data provider for PostgreSQL. It allows any program developed for .Net framework to access database server. It is implemented in 100% C# code. Works with PostgreSQL 7.x and 8.x.
Open source
Npgsql Project
View
ODBC for PostgreSQL
Description
License
Pricing
Publisher
Devart ODBC Driver for PostgreSQL provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access PostgreSQL databases from Windows, macOS, and Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your application with PostgreSQL fast, easy and extremely handy.
Direct Connection
Our connectivity solution enables various ODBC-aware applications to establish a direct connection to PostgreSQL via TCP/IP to eliminate the need for PostgreSQL libraries or clients.
Integration
The driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
Platforms Variety
ODBC Driver for PostgreSQL can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment.
Fully Unicode Driver
With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual PostgreSQL databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
Bulk Updates
Moreover, with our driver you can perform bulk updates to PostgreSQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to PostgreSQL.
Secure Connection
Work with PostgreSQL securely using SSL connection options provided in our driver along with the support for SSL protocol. You can also connect to PostgreSQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption.
Learn more about more ODBC for PostgreSQL features on Devart website.
Commercial
$169.95
Devart
View
Description
License
Pricing
Publisher
A modern C++ API to PostgreSQL that simplifies working with PostgreSQL in C++.
Open source
Dmitry Igrishin
View
pgintcl
Description
License
Pricing
Publisher
This is a Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. It is highly but not entirely compatible with other Tcl interfaces, although it is slower.
Open source
pgintcl Project
View
pgtcl
Description
License
Pricing
Publisher
This is a project to evolve and upgrade libpgtcl, the Tcl client interface to PostgreSQL. Application writers will be able to interface to PostgreSQL from Tcl using this interface.
Open source
pgtcl Project
View
pgtcl-ng
Description
License
Pricing
Publisher
PostgreSQL Tcl Interface Next-Generation (pgtcl-ng) is a loadable Tcl/Tk module for accessing PostgreSQL databases. It extends the pre-8.0 libpgtcl from an early Pgtcl release and from the companion project pgintcl.
Open source
pgtcl-ng Project
View
PostgresClientKit
Description
License
Pricing
Publisher
PostgresClientKit provides a friendly Swift API for operating against a PostgreSQL database.
Doesn’t require libpq
Developer-friendly API using modern Swift
Safe conversion between Postgres and Swift types
Memory efficient
SSL/TLS support
Open source
codewins.com
View
PostgresDAC
Description
License
Pricing
Publisher
PostgresDAC is a component suite for direct access to PostgreSQL servers from Borland Delphi and C++ Builder applications
Commercial
$134.95
Microolap
View
PostgreSQL Data Access Components
Description
License
Pricing
Publisher
PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.
PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.
Native Connectivity to PostgreSQL
PgDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), and that’s why they can work faster than the ones based on standard Delphi data connectivity solutions. Moreover, PgDAC provides an additional opportunity to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client.
Key Features:
Direct Mode. Allows your application to work with PostgreSQL directly without involving PostgreSQL connectivity solutions, thus significantly facilitating deployment and configuration of your applications.
Mobile Development. Development for iOS and Android mobile devices using PgDAC becomes still easier, as PgDAC allows your mobile applications to work with PostgreSQL database as simply as desktop applications do.
Database Compatibility. Our product supports PostgreSQL server versions from 8.0 to 13, Microsoft Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, Amazon Aurora, and Google Cloud for PostgreSQL.
IDE Compatibility. Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++ Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.
Data Type Mapping. If you want to make custom correspondence between PostgreSQL and Delphi data types, you can use a simple and flexible Data Type Mapping engine provided by PgDAC.
Development Platforms. All major GUI frameworks supported: develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.
Read more about PostgreSQL Data Access Component Editions.
Commercial
$199.95
Devart
View
postgresql-kit
Description
License
Pricing
Publisher
postgresql-kit is a set of frameworks, tools, applications and examples for deploying the PostgreSQL database on Mac OS X and iOS platforms.
On the server-side, it provides an embedded server framework which allows you to put a postgresql database right in your Cocoa application. On the client-side, it helps you interact and use all the features of libpq, including converting data seemlessly between Foundation objects and Postgresql data types.
Sample applications for the Macintosh and iOS devices is included in the project, which is licensed with the Apache open-source license.
Open source
mutablelogic
View
PostgreSQL Native OLEDB Provider (PGNP)
Description
License
Pricing
Publisher
PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database.
The provider features support for Linked Servers, replication, DTS, SSIS and more. It can be used from 32-bit and 64-bit Windows applications both native and .NET.
Commercial
PGNP Team
View
PostgreSQL-SDBC
Description
License
Pricing
Publisher
Native PostgreSQL driver for LibreOffice and Apache OpenOffice. It is faster, seamlessly integrated and there is no need to install and setup a JDBC or ODBC driver separately. Compatible with PostgreSQL version 8.4 and later.
Not entirely feature-complete, but the basics work.
Open source
The Document Foundation
View
psql-api
Description
License
Pricing
Publisher
A PostgreSQL RESTful API for SOA applications.
API access for all CRUD operations
JSON data format
SQL queries management
Security best practices
Before and After action code injection
Authorization methods (JWT by default)
Scalability
WEB admin interface
Source code is available under MIT license at:
Open source
Q-Bis Consult S.R.L.
View
psqlJDBC
Description
License
Pricing
Publisher
The PostgreSQL JDBC driver. It allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. It is a pure Java (Type IV) implementation, so all you need to do is download a jar file and you’re on your way.
The driver provides are reasonably complete implementation of the JDBC 3 specification in addition to some PostgreSQL specific extensions.
Open source
PostgreSQL Global Development Group
View
psqlODBC
Description
License
Pricing
Publisher
psqlODBC is the official PostgreSQL ODBC Driver.
Open source
PostgreSQL Global Development Group
View
psycopg
Description
License
Pricing
Publisher
Psycopg is the most popular PostgreSQL adapter for the Python programming language. At its core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.
Open source
Psycopg Development Team
View
slurf
Description
License
Pricing
Publisher
slurf is an easy to use postgresql frontend. You cannot use it to create tables and such, just to input,update and delete data. It is very good for end user data input (phonebook,invoices etc.).
Open source
Diomedia
View
SQL Relay
Description
License
Pricing
Publisher
SQL Relay is a persistent database connection pooling, proxying, throttling, load balancing and query routing/filtering system for PostgreSQL on Linux, Unix and Windows.
APIs are provided for C, C++, .NET, ADO.NET, Perl, Perl-DBI, Python, Python-DB, PHP, PHP PDO, Ruby, Java, TCL, Erlang, and node.js, and ODBC. Drop-in replacement libraries are provided for PostgreSQL. The APIs support advanced database operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions.
Command line clients and extensive documentation are also provided.
SQL Relay is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated or clustered databases and throttling database access.
Open source
firstworks.com
View
UniDAC
Description
License
Pricing
Publisher
Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.
UniDAC provides access to PostgreSQL, Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, SQLite, Microsoft Access, DB2, DBF, Sybase Advantage Database Server, etc.
The tool is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.4 Sydney, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.
Key features:
Direct Mode. Allows you to work with Oracle, SQL Server, MySQL, PostgreSQL, SQLite, Redshift, ASE, DBF, and NexusDB directly without involving a DB Client library, thus significantly facilitating deployment and configuration of your applications.
Mobile Development. Development for iOS and Android mobile devices using UniDAC becomes still easier, as UniDAC allows your mobile applications to work with multiple databases as simply as desktop applications do.
DB Compatibility. Our product supports the latest versions of the popular database servers like Oracle, SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, and other databases (using ODBC provider).
IDE Compatibility. Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++ Builder 10.4 Sydney, Lazarus (and FPC).
Data Type Mapping. If you want to make custom correspondence between server and Delphi data types, you can use a simple and flexible Data Type Mapping engine provided by UniDAC.
Development Platforms. All major GUI frameworks supported: develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.
Commercial
$299.95
Devart
View
Note: The PostgreSQL Global Development Group do not endorse or recommend any products listed, and cannot vouch for the quality or reliability of any of them.
