Specifying an Alternative PostgreSQL Data Directory on RHEL

The default data directory for PostgreSQL 9.5 is /var/lib/pgsql/9.5/data. If you do not need to change the directory, skip this topic.

Important The steps below use the example alternative directory in the following steps is /external-vol/pgdata-9.5.

1. Complete one of the following based on the version of Red Hat Enterprise Linux(RHEL).
   • RHEL 6:
     1. Create and edit /etc/sysconfig/pgsql/postgresql-9.5.
     2. Add the following line then save and close the file:

        PGDATA=/external-vol/pgdata-9.5 
        					 
        				  

   • RHEL 7:
     1. Create and edit /etc/systemd/system/postgresql-9.5.service.
     2. Add the following content:

        .include /lib/systemd/system/postgresql-9.5.service
        [Service]
        Environment=PGDATA=/external-vol/pgdata-9.5
        

2. Set the PGDATA environment variable to point to the custom data directory. This is necessary for the Xpress Insight Server installer to find the custom data directory: export PGDATA="/external-vol/pgdata-9.5"

© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.