PostgreSQL

PostgreSQL Database Server

If you want to customize your database there is an optional pbase-preconfig-postgres rpm. Either the platform default version is installed with the pbase-postgres or you may select version from the pbase-postgres11 repository.

Also provided is the the pbase-adminer rpm to install the Adminer database tool.

Postgres - using the default repo

yum -y install http://pbase-foundation.com/pbase-repo.rpm
yum -y install pbase-preconfig-postgres
yum -y install pbase-postgres

Postgres 11 - using the postgresql.org repo

yum -y install pbase-preconfig-postgres11
yum -y install pbase-postgres11

Postgres 11 - using the postgresql.org repo - on EL8 only

yum -y install pbase-preconfig-postgres11
yum -y --disablerepo=appstream install postgresql11-server postgresql11-contrib
yum -y install pbase-postgres11

Postgres 12 - using the postgresql.org repo

yum -y install pbase-preconfig-postgres12
yum -y install pbase-postgres12

Postgres 12 - using the postgresql.org repo - on EL8 only

yum -y install pbase-preconfig-postgres12
yum -y --disablerepo=appstream install postgresql12-server postgresql12-contrib
yum -y install pbase-postgres12

Configuration Options

The pbase-preconfig-postgres rpm creates a sample configuration file that can be customized:

{
  "pbase_postgres": [
    {
      "default": {
        "hostName": "localhost",
        "port": "5432",
        "startService": true,
        "enableRemoteAccess": true,
        "install": true,
        "database": [
          {
            "name": "app_db",
            "user": "appuser",
            "password": "shomeddata"
          }
        ]
      }
    }
  ]
}

Similarly, the pbase-preconfig-postgres11 and pbase-preconfig-postgres12 rpms create a sample configuration file that can be customized:

{
  "pbase_postgres11": [
    {
      "default": {
        "hostName": "localhost",
        "port": "5432",
        "startService": true,
        "enableRemoteAccess": true,
        "install": true,
        "database": [
          {
            "name": "app_db",
            "user": "appuser",
            "password": "shomeddata"
          }
        ]
      }
    }
  ]
}