PostgreSQL on FlashArray Implementation and Best Practices

1. Set the permissions prior to initialization

When installing PostgreSQL from a  installation manifest the minimum required users and groups will be automatically created. 

The permissions for the C:\PGSQL directory need to be given to the user under which the postgresql service runs as. In a default environment this is the NETWORK SERVICE user , which needs to be changed to the user who will run the initdb application(any user with interactive logon capabilities). A directory for the data directory also needs to be created in the new location and given the appropriate permissions. In this example the DBTest user is given the permissions to the  C:\PGSQL\ and C:\PGSQL\Data directories and is the user under which the PostgreSQL service will run. 

2. Initialize the PostgreSQL cluster at the new location 

To initialize a new PostgreSQL cluster the initdb application is used.

The initdb application can be found in the installation directory for PostgreSQL (default location: C:\Program Files\PostgreSQL\<Version>) in the bin directory. It can then be executed with the -D argument to initialize the data directory at a new location (note do not use the root of a filesystem). Open PowerShell and execute the following , adjusting as required with additional arguments :

& 'C:\Program Files\PostgreSQL\13\bin\initdb.exe' -D C:\PGSQL\Data\

If everything is successful the output should be similar to the following :

The files belonging to this database system will be owned by user "DBtest".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default database encoding has accordingly been set to "WIN1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory C:/PGSQL/Data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... US/Pacific
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    ^"C^:^\Program^ Files^\PostgreSQL^\13^\bin^\pg^_ctl^" -D ^"C^:^\PGSQL^\Data^\^\^" -l logfile start

3. Change startup options and specify new data directory locations 

The service used to automatically start the PostgreSQL cluster needs to be deleted and recreated with the correct command to target the new PostgreSQL data directory location. To avoid conflicts with the old data directory the existing service needs to be deleted :

In the Services management dialog the PostgreSQL cluster in this example is managed by the postgresql-x64-13 service :

This service needs to be deleted , which can be done in a command terminal like PowerShell (As an Administrator enter the cmd process) with the command :

sc.exe delete postgresql-x64-13

If successful the prompt should respond with the following message :

[SC] DeleteService SUCCESS

To recreate the service with the new settings use the following command in the same command terminal, adjusting the user (-U) and data directory (-D) as required :

& 'C:\Program Files\PostgreSQL\13\bin\pg_ctl.exe' register -N "postgresql-x64-13" -U "soln\DBTest" -D "C:\PGSQL\data" -w

This recreates the windows service with the correct data directory and user startup permissions. 

Before starting the service for the first time the user must have the password entered for it , so that the service can start correctly. This can be done by going into the service properties and navigating to the Log On section. In the Log On section provide the password for the user account and select OK. 

At this point the service can be started and will now use the new data directory location. 

1. Set the permissions prior to initialization

 This user and group need to be given ownership of /pgsql and its contents (a directory called data needs to be created before running the initdb application) once a FlashArray volume has been mounted to it. This is done using the chown command :

chown -R postgres:postgres /pgsql

2. Adjust startup and environment properties

The PGDATA environment variable needs to be changed so that it persists across sessions and is used correctly when starting the PostgreSQL cluster. For systemd based systems the service configuration file needs to be altered to ensure the new database directory is used. 

Persistently set PGDATA environment variables 

The PGDATA environment variable is set in the following locations and needs to be changed :

~/.bash_profile

[ -f /etc/profile ] && source /etc/profile
PGDATA=/pgsql/data
export PGDATA
# If you want to customize your settings,
# Use the file below. This is not overridden
# by the RPMS.
[ -f /var/lib/pgsql/.pgsql_profile ] && source /var/lib/pgsql/.pgsql_profile

(SystemD) Change database directory

(As root) Identify the service file under which PostgreSQL is started in systemd (this is the .service file found after the Loaded section) :

systemctl status postgresql-13.service[root@DB-04 data]# systemctl status postgresql-13.service
● postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: https://www.postgresql.org/docs/13/static/

Sep 01 06:39:34 DB-04 systemd[1]: Starting PostgreSQL 13 database server...
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] LOG:  redirecting log output to logging collector process
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] HINT:  Future log output will appear in directory "log".
Sep 01 06:39:34 DB-04 systemd[1]: Started PostgreSQL 13 database server.
Sep 02 01:37:28 DB-04 systemd[1]: Stopping PostgreSQL 13 database server...
Sep 02 01:37:28 DB-04 systemd[1]: postgresql-13.service: Killing process 3981 (postmaster) with signal SIGKILL.
Sep 02 01:37:28 DB-04 systemd[1]: Stopped PostgreSQL 13 database server.                         

Edit the service file , altering  the Environment=PGDATA= line :

[Unit]
Description=PostgreSQL 13 database server
Documentation=https://www.postgresql.org/docs/13/static/
After=syslog.target
After=network.target

[Service]
Type=notify

User=postgres
Group=postgres

# Note: avoid inserting whitespace in these Environment= lines, or you may
# break postgresql-setup.

# Location of database directory
Environment=PGDATA=/pgsql/data

# Where to send early-startup messages from the server (before the logging
# options of postgresql.conf take effect)
# This is normally controlled by the global default set by systemd
# StandardOutput=syslog

# Disable OOM kill on the postmaster
OOMScoreAdjust=-1000
Environment=PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
Environment=PG_OOM_ADJUST_VALUE=0

ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA}
ExecStart=/usr/pgsql-13/bin/postmaster -D ${PGDATA}
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT


# Do not set any timeout value, so that systemd will not kill postmaster
# during crash recovery.
TimeoutSec=0

[Install]
WantedBy=multi-user.target

Save the file and reload SystemD :

systemctl daemon-reload

(SELinux enabled systems only)  - Change SELinux configuration to avoid service startup issues

Get the SElinux labeling for the default data directory with the following command:

ls -lh -Zd /var/lib/pgsql
drwx------ 3 postgres postgres system_u:object_r:postgresql_db_t:s0 data /var/lib/pgsql

Once you have the label change it with the following command:

semanage fcontext -a -t postgresql_db_t "/pgsql/data(/.*)?"

3.  Initialize the PostgreSQL cluster at the new location 

The initdb application is apart of the postgresql-<version>-setup binary. This can be located in /usr/pgsql-<version>/bin. The data directory can only be initialized after changing the systemd startup object. 

Before proceeding check the environment variable is correctly set through the use of the env command : 

LANG=en_US.UTF-8
HISTCONTROL=ignoredups
HOSTNAME=DB-04
USER=postgres
PWD=/var/lib/pgsql
HOME=/var/lib/pgsql
PGDATA=/pgsql/data
MAIL=/var/spool/mail/postgres
SHELL=/bin/bash
TERM=xterm-256color
SHLVL=1
LOGNAME=postgres
PATH=/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
HISTSIZE=1000
LESSOPEN=||/usr/bin/lesspipe.sh %s
_=/usr/bin/env

At this point the cluster can be initialized at a new location using initdb executed as root :

/usr/pgsql-13/bin/postgresql-13-setup initdb 

if successful the following output should be shown :

Initializing database ... 

At this point the PostgreSQL cluster can be started. 

1. Set the permissions on destination prior to migration

Permissions for the destination storage volume should be the same as the source from where the data directory is being copied. 

In this example the data directory is found in C:\Program Files\PostgreSQL\13\ :

Viewing the permissions on the source data directory the DBTest@soln.local user has Full control of the folder: 

Create a directory (in this example - data)  in the root of the target filesystem and ensure it has the same permissions as the source directory : 

 

2. Stop the PostgreSQL cluster

In the Services Management Console identify the service responsible for PostgreSQL , right click on it and select Stop. 

3. Copy the contents of the data directory to the new location , preserving existing permissions 

In a PowerShell terminal use the following command to copy the data folder and  its contents to the intended destination :

xcopy.exe 'C:\Program Files\PostgreSQL\13\data' C:\PGSQL\data /O/X/E/H/K

4. Change startup options and specify new data directory locations 

The service used to automatically start the PostgreSQL cluster needs to be deleted and recreated with the correct command to target the new PostgreSQL data directory location. To avoid conflicts with the old data directory the existing service needs to be deleted :

In the Services management dialog the PostgreSQL cluster in this example is managed by the postgresql-x64-13 service :

This service needs to be deleted , which can be done in a command terminal like PowerShell (As an Administrator enter the cmd process) with the command :

sc.exe delete postgresql-x64-13

If successful the prompt should respond with the following message :

[SC] DeleteService SUCCESS

To recreate the service with the new settings use the following command in the same command terminal, adjusting the user (-U) and data directory (-D) as required :

& 'C:\Program Files\PostgreSQL\13\bin\pg_ctl.exe' register -N "postgresql-x64-13" -U "soln\DBTest" -D "C:\PGSQL\data" -w

This recreates the windows service with the correct data directory and user startup permissions. 

Before starting the service for the first time the user must have the password entered for it , so that the service can start correctly. This can be done by going into the service properties and navigating to the Log On section. In the Log On section provide the password for the user account and select OK. 

At this point the service can be started and will now use the new data directory location. 

1. Set the permissions on destination prior to migration

The postgres user which is a member of the postgres group is created with the home directory : /var/lib/pgsql/ (also the default location for the data directory under the /version/ folder) during installation from a package or package manager. This user will be used to provide the correct permissions for the intended destination location. 

A FlashArray volume should be mounted and formatted with a file system before creating the folder and assigning the permissions.

Before assigning the permissions ensure that a directory (in this example - data) has been created. This folder will contain the data directory contents. This can be done using the mkdir command as the postgres or root user  :

mkdir /pgsql/data

This user and group need to be given ownership of /pgsql and its contents if the folders have been created by root or another user. The permissions can be assigned using the chown command :

chown -R postgres:postgres /pgsql

2. Stop the PostgreSQL cluster

In a terminal type the following command:

sudo systemctl stop postgresql-13.service

3. Copy the contents of the data directory to the new location , preserving existing permissions 

In a command terminal use the following command to copy the contents of the data directory to the intended destination:

rsync -av /var/lib/pgsql/13/data/ /pgsql/data/ 

4. Adjust startup and environment properties

The PGDATA environment variable needs to be changed so that it persists across sessions and is used correctly when starting the PostgreSQL cluster. For systemd based systems the service configuration file needs to be altered to ensure the new database directory is used. 

Persistently set PGDATA environment variables 

The PGDATA environment variable is set in the following locations and needs to be changed :

~/.bash_profile

[ -f /etc/profile ] && source /etc/profile
PGDATA=/pgsql/data
export PGDATA
# If you want to customize your settings,
# Use the file below. This is not overridden
# by the RPMS.
[ -f /var/lib/pgsql/.pgsql_profile ] && source /var/lib/pgsql/.pgsql_profile

(SystemD) Change database directory

(As root) Identify the service file under which PostgreSQL is started in systemd (this is the .service file found after the Loaded section) :

systemctl status postgresql-13.service[root@DB-04 data]# systemctl status postgresql-13.service
● postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: https://www.postgresql.org/docs/13/static/

Sep 01 06:39:34 DB-04 systemd[1]: Starting PostgreSQL 13 database server...
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] LOG:  redirecting log output to logging collector process
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] HINT:  Future log output will appear in directory "log".
Sep 01 06:39:34 DB-04 systemd[1]: Started PostgreSQL 13 database server.
Sep 02 01:37:28 DB-04 systemd[1]: Stopping PostgreSQL 13 database server...
Sep 02 01:37:28 DB-04 systemd[1]: postgresql-13.service: Killing process 3981 (postmaster) with signal SIGKILL.
Sep 02 01:37:28 DB-04 systemd[1]: Stopped PostgreSQL 13 database server.                         

Edit the service file , altering  the Environment=PGDATA= line :

[Unit]
Description=PostgreSQL 13 database server
Documentation=https://www.postgresql.org/docs/13/static/
After=syslog.target
After=network.target

[Service]
Type=notify

User=postgres
Group=postgres

# Note: avoid inserting whitespace in these Environment= lines, or you may
# break postgresql-setup.

# Location of database directory
Environment=PGDATA=/pgsql/data

# Where to send early-startup messages from the server (before the logging
# options of postgresql.conf take effect)
# This is normally controlled by the global default set by systemd
# StandardOutput=syslog

# Disable OOM kill on the postmaster
OOMScoreAdjust=-1000
Environment=PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
Environment=PG_OOM_ADJUST_VALUE=0

ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA}
ExecStart=/usr/pgsql-13/bin/postmaster -D ${PGDATA}
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT


# Do not set any timeout value, so that systemd will not kill postmaster
# during crash recovery.
TimeoutSec=0

[Install]
WantedBy=multi-user.target

Save the file and reload SystemD :

sudo systemctl daemon-reload

(SELinux enabled systems only)  - Change SELinux configuration to avoid service startup issues

Get the SElinux labeling for the default data directory with the following command:

ls -lh -Zd /var/lib/pgsql
drwx------ 3 postgres postgres system_u:object_r:postgresql_db_t:s0 data /var/lib/pgsql

Once you have the label change it with the following command:

semanage fcontext -a -t postgresql_db_t "/pgsql/data(/.*)?"

At this point the PostgreSQL cluster can be started and will use the new data directory location.

1. Mount each volume for the specific database objects and provide the correct permissions 

With the volumes connected to the initiator ensure that there is a file system and appropriate volume label created on each. 

Each volume with a file system should be mounted to the relevant mount point or provided with a distinct drive letter. 

Once mounted with a drive letter or at a specific volume ensure that the user who will own the PostgreSQL installation and service has Full control of each filesystem. 

 

2. Initialize the PostgreSQL cluster at the new location 

To initialize a new PostgreSQL cluster the initdb application is used.

The initdb application can be found in the installation directory for PostgreSQL (default location: C:\Program Files\PostgreSQL\<Version>) in the bin directory. It can then be executed with the -D argument to initialize the data directory at a new location (note do not use the root of a filesystem). Open PowerShell and execute the following , adjusting as required with additional arguments :

& 'C:\Program Files\PostgreSQL\13\bin\initdb.exe' -D C:\PGSQL\pgcluster\Data

If everything is successful the output should be similar to the following :

The files belonging to this database system will be owned by user "DBtest".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default database encoding has accordingly been set to "WIN1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory C:/PGSQL/pgcluster/Data... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... US/Pacific
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    ^"C^:^\Program^ Files^\PostgreSQL^\13^\bin^\pg^_ctl^" -D ^"C^:^\PGSQL^\pgcluster^\Data^\^\^" -l logfile start

3. Change startup options and specify new data directory locations 

The service used to automatically start the PostgreSQL cluster needs to be deleted and recreated with the correct command to target the new PostgreSQL data directory location. To avoid conflicts with the old data directory the existing service needs to be deleted :

In the Services management dialog the PostgreSQL cluster in this example is managed by the postgresql-x64-13 service :

This service needs to be deleted , which can be done in a command terminal like PowerShell (As an Administrator enter the cmd process) with the command :

sc.exe delete postgresql-x64-13

If successful the prompt should respond with the following message :

[SC] DeleteService SUCCESS

To recreate the service with the new settings use the following command in the same command terminal, adjusting the user (-U) and data directory (-D) as required :

& 'C:\Program Files\PostgreSQL\13\bin\pg_ctl.exe' register -N "postgresql-x64-13" -U "soln\DBTest" -D "C:\PGSQL\pgcluster\Data" -w

This recreates the windows service with the correct data directory and user startup permissions. 

Before starting the service for the first time the user must have the password entered for it , so that the service can start correctly. This can be done by going into the service properties and navigating to the Log On section. In the Log On section provide the password for the user account and select OK. 

4. Alter log file and continuous archiving locations 

In the data directory there should now be a postgres.conf file conbtaining relevant configuration parameters , this is where continuous archiving and the log files can be set using similar syntax to the following :

Continuous Archiving 

  archive_mode = on
  archive_command = 'cp %p C:\PGSQL\pgarchive\%f'
  wal_level = replica

Server Log file and rotation 

log_directory = 'C:\PGSQL\pglog\'
log_filename = 'postgresql-%Y%m%d_%H%M%S.log'
log_rotation_age = 365d
log_rotation_size = 8GB
log_truncate_on_rotation = off
log_line_prefix = '%t c%  

1. Mount each volume for the specific database objects and provide the correct permissions 

Ensure that each multipath device has a filesystem created for it and is mounted at the relevant locations. 

Filesystem                                       Size  Used Avail Use% Mounted on
devtmpfs                                         252G     0  252G   0% /dev
tmpfs                                            252G     0  252G   0% /dev/shm
tmpfs                                            252G   11M  252G   1% /run
tmpfs                                            252G     0  252G   0% /sys/fs/cgroup
/dev/mapper/rhel-root                            630G  7.6G  623G   2% /
/dev/mapper/rhel-home                             73G  549M   72G   1% /home
/dev/dm-8                                       1014M  242M  773M  24% /boot
/dev/mapper/3624a93708488b6dac70f42a200021650p1  599M  6.9M  592M   2% /boot/efi
tmpfs                                             51G     0   51G   0% /run/user/0
/dev/mapper/3624a9370668f1ab9b15f4bc400014267    2.0T   15G  2.0T   1% /pgarchive
/dev/mapper/3624a9370668f1ab9b15f4bc400014268    4.0T   29G  4.0T   1% /pgbackup
/dev/mapper/3624a9370668f1ab9b15f4bc400014269    256G  1.9G  255G   1% /pgcluster
/dev/mapper/3624a9370668f1ab9b15f4bc40001426a     10G  104M  9.9G   2% /pglog

After each volume has been mounted in the relevant operating system it should be provided with the correct user permissions , for example in Linux the postgres user and postgres group should own the folder eacch volume is mounted to:

drwxr-xr-x     2 postgres postgres    6 Sep  6 06:37 pgarchive
drwxr-xr-x     2 postgres postgres    6 Sep  6 06:37 pgbackup
drwxr-xr-x     2 postgres postgres    6 Sep  6 06:37 pgcluster
drwxr-xr-x     2 postgres postgres    6 Sep  6 06:37 pglog

2. Adjust startup and environment properties

The PGDATA environment variable needs to be changed so that it persists across sessions and is used correctly when starting the PostgreSQL cluster. For systemd based systems the service configuration file needs to be altered to ensure the new database directory is used. 

Persistently set PGDATA environment variables 

The PGDATA environment variable is set in the following locations and needs to be changed :

~/.bash_profile

[ -f /etc/profile ] && source /etc/profile
PGDATA=/pgcluster/data
export PGDATA
# If you want to customize your settings,
# Use the file below. This is not overridden
# by the RPMS.
[ -f /var/lib/pgsql/.pgsql_profile ] && source /var/lib/pgsql/.pgsql_profile

(SystemD) Change database directory

(As root) Identify the service file under which PostgreSQL is started in systemd (this is the .service file found after the Loaded section) :

systemctl status postgresql-13.service[root@DB-04 data]# systemctl status postgresql-13.service
● postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: https://www.postgresql.org/docs/13/static/

Sep 01 06:39:34 DB-04 systemd[1]: Starting PostgreSQL 13 database server...
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] LOG:  redirecting log output to logging collector process
Sep 01 06:39:34 DB-04 postmaster[3980]: 2021-09-01 06:39:34.427 PDT [3980] HINT:  Future log output will appear in directory "log".
Sep 01 06:39:34 DB-04 systemd[1]: Started PostgreSQL 13 database server.
Sep 02 01:37:28 DB-04 systemd[1]: Stopping PostgreSQL 13 database server...
Sep 02 01:37:28 DB-04 systemd[1]: postgresql-13.service: Killing process 3981 (postmaster) with signal SIGKILL.
Sep 02 01:37:28 DB-04 systemd[1]: Stopped PostgreSQL 13 database server.                         

Edit the service file , altering  the Environment=PGDATA= line :

[Unit]
Description=PostgreSQL 13 database server
Documentation=https://www.postgresql.org/docs/13/static/
After=syslog.target
After=network.target

[Service]
Type=notify

User=postgres
Group=postgres

# Note: avoid inserting whitespace in these Environment= lines, or you may
# break postgresql-setup.

# Location of database directory
Environment=PGDATA=/pgcluster/data

# Where to send early-startup messages from the server (before the logging
# options of postgresql.conf take effect)
# This is normally controlled by the global default set by systemd
# StandardOutput=syslog

# Disable OOM kill on the postmaster
OOMScoreAdjust=-1000
Environment=PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
Environment=PG_OOM_ADJUST_VALUE=0

ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA}
ExecStart=/usr/pgsql-13/bin/postmaster -D ${PGDATA}
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT


# Do not set any timeout value, so that systemd will not kill postmaster
# during crash recovery.
TimeoutSec=0

[Install]
WantedBy=multi-user.target

Save the file and reload SystemD :

systemctl daemon-reload

(SELinux enabled systems only)  - Change SELinux configuration to avoid service startup issues

Get the SElinux labeling for the default data directory with the following command:

ls -lh -Zd /var/lib/pgsql
drwx------ 3 postgres postgres system_u:object_r:postgresql_db_t:s0 data /var/lib/pgsql

Once you have the label change it with the following command:

semanage fcontext -a -t postgresql_db_t "/pgsql/data(/.*)?"

3.  Initialize the PostgreSQL cluster at the new location 

The initdb application is apart of the postgresql-<version>-setup binary. This can be located in /usr/pgsql-<version>/bin. The data directory can only be initialized after changing the systemd startup object. 

Before proceeding check the environment variable is correctly set through the use of the env command : 

LANG=en_US.UTF-8
HISTCONTROL=ignoredups
HOSTNAME=DB-04
USER=postgres
PWD=/var/lib/pgsql
HOME=/var/lib/pgsql
PGDATA=/pgsql/data
MAIL=/var/spool/mail/postgres
SHELL=/bin/bash
TERM=xterm-256color
SHLVL=1
LOGNAME=postgres
PATH=/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
HISTSIZE=1000
LESSOPEN=||/usr/bin/lesspipe.sh %s
_=/usr/bin/env

At this point the cluster can be initialized at a new location using initdb executed as root :

/usr/pgsql-13/bin/postgresql-13-setup initdb 

if successful the following output should be shown :

Initializing database ... 

4. Alter log file and continuous archiving locations 

In the data directory there should now be a postgres.conf file containing relevant configuration parameters , this is where continuous archiving and the log files can be set using similar syntax to the following :

Continuous Archiving 

 archive_mode = on
 archive_command = 'cp %p /pgarchive/%f'
 wal_level = replica

Server Log file and rotation 

log_directory = '/pglog'
log_filename = 'postgresql-%Y%m%d_%H%M%S.log'
log_rotation_age = 365d
log_rotation_size = 8GB
log_truncate_on_rotation = off
log_line_prefix = '%t c%