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? :(
Under postgres data directory something like /var/lib/postgresql/9.3/main/pg_log
The query gives you the actual log directory in any operating system.
select format('%s/%s',
current_setting('data_directory'),
current_setting('log_directory'));
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With