Deploying a standalone PostgreSQL server

Deploying a standalone PostgreSQL server is a basic example of provisioning and administration of a standalone PostgreSQL cluster running on a single RHEL-compatible box.

The demo exposes the database to the outside world on port 5432 with a configuration option to limit the access to a IP subnet. A local disk is used for storage with an option to use attached block storage location.

What you'll learn

Creating a PostgreSQL cluster from scratch
Asking for database user passwords interactivelly
Creating a custom firewalld service for the PostgreSQL service
Connecting to PostgreSQL with psql over SSL/TLS
Setting up automatic weekly system update
Setting up log rotation for the PostgreSQL log and max limit for system log
Doing cluster backups and restores
Creating admin tasks

Configuration options

`SERVER`	The virtual machine IP address
`SSH_KEY`	The path to the private SSH key
`LISTEN_ADDRESS`	The IP address or mask for binding PostgreSQL connections
`PGDIR`	The PostgreSQL directory on the block storage (optional)
`ADMIN`	The administrator user name that will replace root
`DB_USER`	The initial database user name
`DB_NAME`	The initial database name

Buy now

Book with code for $65 + local tax

by Josef