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?
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'
Ubuntu 13.04 installed using software centre :
The location for mine is:
/etc/postgresql/9.1/main/postgresql.conf