views:

32

answers:

2

Recently reinstalled postgre 8.3 on my Ubuntu 8.04 after update. Used EnterpriseDB package. I can connect to the database locally, I see system DB postgres but I can't configure it because I can't find config files. Searched through entire hard drive and found only samples like pg_hba.conf.sample

Where they are?

A: 

Run

sudo updatedb

followed by

locate postgresql.conf
Steven Schlansker
finally got postgresql.conf.sample again ))
pukipuki
+2  A: 

Or ask your database:

SHOW config_file;

Frank Heikens
they are in data directory... default user can't get there thus I couldn't find them.
pukipuki
That's the default location, but you can change this when you start PostgreSQL. See pg_clt -D, check http://www.postgresql.org/docs/current/interactive/app-pg-ctl.html
Frank Heikens