Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to take error logs in postgresql

Tags:

postgresql

In postgresql am change following settings for postgresql.conf file.But,logging file is display empty.I want to log all error returned from postgresql.

log_destination = 'stderr,csvlog,syslog'

logging_collector = on

log_directory = 'pg_log'

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'

syslog_facility = 'LOCAL7'

syslog_ident = 'postgres' log_min_duration_statement = 0    

log_statement = 'all'
like image 246
kokila Avatar asked Apr 23 '26 21:04

kokila


1 Answers

Set the following:

log_min_error_statement = error
log_min_messages = error

Don't forget to run pg_ctl reload after changing postgresql.conf.

like image 125
Laurenz Albe Avatar answered Apr 30 '26 03:04

Laurenz Albe



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!