Pg_Log Directory for Postgresql in Ubuntu?

Pg_Log Directory for Postgresql in Ubuntu?

I followed instruction on

it says to set log_directory = pg_log

where's that directory in ubuntu? :(

2 Answers

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

1

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Marcus Vance
Author

Marcus Vance

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.