![]() pgpass file must exist on each server where the password protected instance will be protected. pgpass file is required for the utility psql for unattended (non-terminal or scripted) connections. Please set the appropriate file permissions to restrict access to the file. pgpass file must be located in the home directory of the PostgreSQL Operating System User. pgpass file must contain a valid and tested entry for each PostgreSQL Database Administrator User requiring a password. pgpass credentials file on each server in the cluster where the resource will be protected. Password Protected database instances require a password entry for the PostgreSQL Database Administrator User to exist in the. The following is an example of a pg_hba.conf entry to enable local client connects for the PostgreSQL Database Administrator User:Įnabling Password Protected (Instance requires a Password for Connections) If the PostgreSQL database instance will not be password protected or will not require a password for local client connections from the PostgreSQL Database Administrator User, then an entry must exist allowing local trust connections. No Password Protection (Instance is not Password Protected) ![]() It is required that the instance be started with the backend option -o “–p ” specified to the pg_ctl utility. The PostgreSQL instance must be started manually prior to hierarchy creation. Once under LifeKeeper protection, LifeKeeper will handle the start and stop of the database. The PostgreSQL database name should contain alphanumeric characters only.Īfter creating your database, you should disable automatic startup of the PostgreSQL database instance. The PostgreSQL transaction log directory must reside on a shared file system. The PostgreSQL instance data directory must reside on a shared file system. The initdb command must be run as the PostgreSQL Operating System User. The PostgreSQL data directory should be initialized using the initdb utility, specifying the –D option. In addition, please note the following recommendations: Follow the instructions in your PostgreSQL Administration Guide to create your database.
0 Comments
Leave a Reply. |