Logo       PBase-Foundation

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 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 CentOS 8 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 CentOS 8 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"
}
]
}
}
]
}