
EDB Postgres Advanced Server 12 - RPM installation
===================================================

This document is applicable to version 12 of EDB Postgres Advanced Server.  
Please note that commands documented in this README do not apply to versions 
prior to 12.  The Advanced Server RPM installers are tested and supported 
on the following 64 bit Linux platforms:

  * Red Hat Enterprise Linux (x86_64) 7.x and 8.x
  * CentOS (x86_64) 7.x and 8.x

The EDB Postgres Advanced Server RPM installer is split into multiple packages 
so you can 'pick and choose' which components you would like to install, and the
dependencies that are required.  The server RPMs are distributed in the following packages:

edb-as12:                      The Advanced Server Meta installer installs the 
                               server and its core supporting components.
edb-as12-server:               Key clients and libraries, and core documentation
edb-as12-server-client:        Client software required to access Advanced Server
edb-as12-server-contrib:       The contrib source tree, as well as selected binaries
edb-as12-server-core:          Server executables and data files
edb-as12-server-devel:         Development libraries and include files
edb-as12-server-docs:          Extra documentation, such as the tutorial files
edb-as12-server-indexadvisor:  Index Advisor for EDB Postgres Advanced Server
edb-as12-server-libs:          Client shared libraries
edb-as12-server-plperl:        PL/Perl procedural language
edb-as12-server-plpython:      PL/Python procedural language
edb-as12-server-pltcl:         PL/Tcl procedural language
edb-as12-server-sqlprofiler:   SQL Profiler for EDB Postgres Advanced Server
edb-as12-server-sqlprotect:    SQL Protect for EDB Postgres Advanced Server
edb-as12-server-sslutils:      SSL Utils for EDB Postgres Advanced Server

For detailed information about the available Advanced Server RPM installers and
their contents, please see the EDB Postgres Advanced Server Installation Guide, 
available at https://www.enterprisedb.com/resources/product-documentation

Installed File Locations
------------------------
To be in compliance with the Linux FHS, the EDB Postgres Advanced Server RPMs install 
files in a manner not consistent with the Advanced Server graphical installers. 

When installed with an RPM package, the Advanced Server files are located:

Executables:            /usr/edb/as12/bin
Libraries:              /usr/edb/as12/lib
Documentation:          /usr/edb/as12/share/doc
Contrib:                /usr/edb/as12/share/contrib
                        /usr/edb/as12/share/doc/contrib
Data:                   /var/lib/edb/as12/data
Backup area:            /var/lib/edb/as12/backups
Templates:              /usr/edb/as12/share
Procedural Languages:   /usr/edb/as12/lib
Development Headers:    /usr/edb/as12/include
Other shared data:      /usr/edb/as12/share
Documentation SGML:     /usr/edb/as12/share/doc


The Advanced Server Database Superuser
======================================

The installation process creates a database superuser named 'enterprisedb'.  By default, 
this user is UID 26 and GID 26. The user has the default shell set to bash, and the 
home directory set to /var/lib/edb.  This user also has no default password -- in order 
to be able to su to it from a non-root account or login as 'enterprisedb' you will need 
to use the passwd command to set a password for the user.


GRAND UNIFIED CONFIGURATION (GUC) FILE
======================================

Advanced Server has many tunable parameters; the postgresql.conf file, located in
/var/lib/edb/as12/data/postgresql.conf is the master configuration file for the
server.  The RPM installs the default configuration of the postgresql.conf file; you 
will need to tune the parameters to customize your installation.  

After modifying the postgresql.conf or pg_hba.conf file, you must restart the server 
or reload the configuration parameters for the change to take effect; for detailed 
information about Advanced Server configuration parameters, please see the EDB Postgres 
Advanced Server Guide, available at: 

https://www.enterprisedb.com/resources/product-documentation

Allowing Nonlocal Connections
-----------------------------
You may want to modify the configuration file to allow nonlocal TCP/IP socket connections.  
To update the configuration, use your choice of editor to edit the postgresql.conf file. 
Uncomment the 'listen_addresses' parameter and set the value to '*' to instruct the postmaster 
to accept nonlocal connections.  You'll also need to adjust pg_hba.conf accordingly to allow 
connections from the client.

For more information about modifying the pg_hba.conf file, please see the PostgreSQL 
Core Documentation.

Configuring Logging Preferences
-------------------------------
By default, the postmaster's stderr log is directed into files placed in the
log subdirectory of the data directory (/var/lib/edb/as12/data/log).
The default configuration rotates among seven files, one for each day of the week.  
To customize logging preferences, modify parameters in the postgresql.conf file; for 
detailed information about the parameters that control logging, please consult the 
EDB Postgres Advanced Server Guide.


Contrib Modules
===============

The contents of the contrib tree are packaged into the -contrib package and are processed 
with make and make install.  You will find documentation in /usr/edb/as12/share/doc for 
these modules.  Most of the modules are in /usr/edb/as12/lib for loadable modules, and 
binaries are in /usr/edb/as12/bin.  In the future these files may be split out, depending 
upon function and dependencies.


Upgrading an Advanced Server Installation
=========================================

These RPMs do not support any sort of major version upgrading process other 
than that documented in the regular documentation.  You must dump, upgrade, initdb, 
and restore your data to perform a major version update. These steps are not 
required for minor version updates.


For More Information about Advanced Server
==========================================

For more information about EDB Postgres Advanced Server and its supporting components, or
to review online documentation, visit https://www.enterprisedb.com.
