postgresqlubuntuconfiguration

Where does PostgreSQL store configuration/conf files?

I have recently installed PostgreSQL on Ubuntu with the EnterpriseDB package. I can connect to the database locally, but I can't configure it because I can't find config files. I searched through entire hard drive and found only samples like pg_hba.conf.sample

Where are the PostgreSQL .conf files?

Solution

  • Or ask your database:

    $ psql -U postgres -c 'SHOW config_file'

    or, if logged in as the ubuntu user:

    $ sudo -u postgres psql -c 'SHOW config_file'