PostgreSQL 9.5

Installation Notes

Welcome to the PostgreSQL 9.5 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 Linux builds of this installer have been tested on a variety of different versions of 32 and 64bit Linux distributions, including Amazon Linux, CentOS 6 and above, Ubuntu 14.04 and above, Redhat Enterprise Linux 6 and above and SLES SP3. The Mac OS X build has been tested on OS X 10.6 (Snow Leopard) 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:

The current pl/Python is dynamically linked with Python's shared library in the LanguagePack 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.

Windows Service Account

Prior to version 9.2, the Windows port used a service account called 'postgres' by default. From 9.2 onwards, the special 'NT AUTHORITY\NetworkService' account is used instead. If you need to use an alternative account, for example, to allow the database server to use server-side COPY with files on a network share, run the installer with a command line option such as --serviceaccount postgres.

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.

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.

This software was packaged by EnterpriseDB