Wo stelle ich meine `pg_hba.conf'-Datei in EnterpriseDB für OS X ab

1322
David West

Ich habe eine pg_hba.conf.sampleDatei, aber keine pg_hba.confDatei. Ich möchte einen machen und ihn an die richtige Stelle bringen. Wo lege ich hin pg_hba.conf?

0

1 Antwort auf die Frage

0
Dirk Thannhäuser

According to EnterpriseDB documentation (Chapter 18.2 File locations):

By default, all three configuration files are stored in the database cluster's data directory.

http://www.enterprisedb.com/docs/en/8.4/pg/runtime-config-file-locations.html#GUC-HBA-FILE

have a look in your postgres.conf for the 'data_directory' setting

another way to get the location of your data_directory is to execute a SQL query with admin privileges

For example: 

postgres=# SHOW data_directory; data_directory ----------------- /var/pgsql/data

and it might look as follows: 

[root@host /var/pgsql/data]# ls base pg_clog pg_ident.conf pg_notify pg_stat_tmp pg_tblspc PG_VERSION postgresql.conf postmaster.pid global pg_hba.conf pg_multixact pg_serial pg_subtrans pg_twophase pg_xlog postmaster.opts

If the pg_hba.conf is not present here, put it into the directory which has been provided by the SHOW data_directory SQL query

Verwandte Probleme