2.3.2. Database Partitioning

Procedure 2.1. Creating and Mounting a Database Partition

1. Log in to the database server as root. For Embedded Databases, this is the same server as the Red Hat Satellite.
2. Create the postgres user.

   # useradd -d /var/lib/pgsql -M -r -s /bin/bash -U postgres
   

   Copy to Clipboard Toggle word wrap
3. Add the mount point in /etc/fstab. For example:

   UUID="xxxxxxxx-xxxx-xxxx" /opt/rh/postgresql92/root/var/lib/pgsql  ext4  defaults  0 0
   

   Copy to Clipboard Toggle word wrap

   Important

   Red Hat does not support storing the database on a network filesystem.
4. Mount the partition to /opt/rh/postgresql92/root/var/lib/pgsql and change ownership to postgres:postgres:

   # mkdir -p /opt/rh/postgresql92/root/var/lib/pgsql
   # mount /opt/rh/postgresql92/root/var/lib/pgsql
   # chown postgres:postgres /opt/rh/postgresql92/root/var/lib/pgsql
   # chmod 700 /opt/rh/postgresql92/root/var/lib/pgsql
   # restorecon -Rv /opt/rh/postgresql92/root/var/lib/pgsql
   

   Copy to Clipboard Toggle word wrap