13.3 Manually Modifying Configuration Files

Table of Contents Previous Next


13 Database Management : 13.3 Manually Modifying Configuration Files

The postgresql.conf file determines Postgres server behavior as it pertains to auditing, authentication, file locations, resource usage, query planning, statistic gathering, error handling and more.
The pg_hba.conf file controls the type of authentication that should be used when a client application connects to an EDB Ark service. By default, the pg_hba.conf file is configured to require clients to provide a valid md5-encrypted password.
The pg_ident.conf file contains user mappings for external authentication methods (like LDAP or GSSAPI). Each entry within the pg_ident.conf file maps an external user name to his corresponding Postgres user name.
The pgpool.conf file determines the behavior of EDB Ark as it pertains to load balancing.
1.
ssh to the node of the cluster that contains the file you wish to modify. For information about using ssh to connect to the server, see Section 13.1.1, Using ssh to Access a Server.
When you add or remove nodes from a cluster, EDB Ark takes a backup of your pg_hba.conf and pgpool.conf configuration files. Configuration file backups are appended with the date that the backup was taken and a unique identifier; for example, pg_hba.conf.20140319-140903 identifies a backup of the pg_hba.conf file.

13 Database Management : 13.3 Manually Modifying Configuration Files

Table of Contents Previous Next