Configuring and Using Pivotal Postgres

Configuring PostgreSQL and Replication Manager

After installing the Pivotal Postgres software components, you must configure PostgreSQL and repmgr for clustered operation. This involves tasks such as:

  • Setting required PostgreSQL configuration parameters on each PostgreSQL host.
  • Creating required databases and the repmgr user on the PostgreSQL hosts.
  • Enabling PostgreSQL authentication for the repmgr user.
  • Configuring repmgr software on all hosts.
  • Preparing and registering primary and replcation servers.

To perform these tasks, follow the instructions in Chapter 3. Quick-start guide in the Replication Manager documentation.

Note: Pivotal does not support using the repmgr witness server, as it is not a full and complete solution for detecting split brain scenarios. Use external utilities (not provided by Pivotal) to prevent a split brain situation and to initiate fail-overs using the repmgr utilities.

For additional information about administering and using Replication Manager, see the full repmgr 4.2 Documentation.

Configuring psqlODBC

You configure psqlODBC by placing settings into a configuration file, odbc.ini, and then using an ODBC driver manager such as UnixODBC or iODBC to load the configuration file. See 7.3. Configuration Files in the PostgreSQL documentation for information about the ODBC driver configuration settings.

See also psqlODBC - PostgreSQL ODBC driver for additional HOWTOs and release-specific information associated with the driver software.

Configuring pgjdbc

In order to use the pgjdbc driver from a Java application, you must include the driver software in your CLASSPATH as described in Setting up the Class Path. See also the full documentation at The PostgreSQL JDBC Interface for information about initializing and using the JDBC driver in your Java applications.