CODEWITHSUNDEEP
postgresql
eugene
eugene

Reputation: 41685

pg_log directory for postgresql in ubuntu?

I followed instruction on http://pydanny-event-notes.readthedocs.org/en/latest/DjangoConEurope2012/10-steps-to-better-postgresql-performance.html

it says to set log_directory = pg_log

where's that directory in ubuntu? :(

Upvotes: 11

Views: 22582

Answers (2)

klin
klin

Reputation: 121644

The query gives you the actual log directory in any operating system.

select format('%s/%s', 
    current_setting('data_directory'),
    current_setting('log_directory'));

Upvotes: 12

pmverma
pmverma

Reputation: 1703

Under postgres data directory something like /var/lib/postgresql/9.3/main/pg_log

Upvotes: 16

Related Questions