PostgreSQL 14

Installation Notes

Welcome to the PostgreSQL 14 Installation Wizard.

Legal Bits

First the boring legal stuff. The software bundled together in this package is released under a number of different Open Source licences. By using any component of this installation package, you agree to abide by the terms and conditions of it’s licence.

The PostgreSQL Server, pgAdmin and the installer itself are released under the PostgreSQL License.

This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit. (http://www.openssl.org/)

Supported Operating Systems

The macOS build has been tested on 10.14 and above, including 11.x (BigSur) for x86_64 and ARM64 architectures. The Windows builds of this installer have been tested on variety of different versions of 64bit Windows platforms like Windows 2016 and above. Please let us know if the installer does not operate as expected on your operating system, and where possible, we will try to add support

Procedural Languages

The procedural languages pl/Perl, pl/Python and pl/Tcl are included in this distribution of PostgreSQL. The server has been built using the LanguagePack community distributions of those language interpreters. To use any of the these languages from within PostgreSQL, download and install the appropriate interpreters and ensure they are included in the PATH variable under which the database server will be started. The versions used are shown below - newer minor (bugfix) releases may also work, but have not been tested:

NOTE: On Windows we are keeping older Perl version

The current pl/Python is dynamically linked with Python's shared library in the LanguagePack v2.x installers. Some distributions of Python interpreters (including ActivePython) on Linux do not carry a dynamic library of Python. Such interpreters would no longer be functional with pl/Python.We strongly recommend the users to use LanguagePack installers for pl/Perl, pl/Python and pl/Tcl. The beta installers might see plperl extension failing on x86_64 architecture

pl/pgsql Debugger

The package includes EnterpriseDB's pl/pgsql debugger plugin which may be used by the debugger UI in pgAdmin to help with development of your database functions. The debugger plugin is disabled by default for performance reasons. To enable it, follow the following steps:

  1. Edit the postgresql.conf file in the data directory and modify the shared_preload_libraries config option to look like the following, if running on Linux or Mac:
     
    shared_preload_libraries = '$libdir/plugin_debugger.so'
     
    or if you are on Windows:
     
    shared_preload_libraries = '$libdir/plugin_debugger.dll'
     
  2. Restart the PostgreSQL server.
     
  3. Run CREATE EXTENSION pldbgapi; in the database you wish to debug using psql or the pgAdmin query tool.

For further information, please see the pgAdmin online help, and the debugger plugin README file.

Important Note with regards to ICU

PostgreSQL Server 14 is compiled with ICU 67.x. The server versions upto v12 used either ICU 53.x or 57.x. Hence, if you use pg_upgrade for a major version upgrade and have ICU collated indexes, then you need to reindex the indexes.

Technical Support

For Installer support, please use the EnterpriseDB forums at http://forums.enterprisedb.com/, or if you need a more formal support arrangement, a list of providers can be found on the PostgreSQL website.

For PostgreSQL support, please use the appropriate mailing list. A complete list may be found at http://www.postgresql.org/lists.html.

For pgAdmin support, please use the pgadmin-support@postgresql.org mailing list.

This software was packaged by EnterpriseDB