Only log errors in Postgres (not all queries)

Question

I'm new to Postgres so can't seem to change the logging setting.

At the moment it logs ALL queries that are executed by any application. The app writes millions of queries a day so the log files get too big. I only need it to log any errors.

How can I change that in Postgres? I've installed it using Homebrew on Mac OS X.

Did your read this http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html — Vivek S., Mar 12 '15 at 06:03

Vivek S. · Accepted Answer · 2018-10-20T16:00:22.320

3

You need to configure in postgresql.conf(data/postgresql.conf) file

change the setting in log_statement = 'all' to get the desired value which is available in When To Log

see this SO question for more info.

edited Oct 20 '18 at 16:00

answered Mar 12 '15 at 06:09

Vivek S.

19,945
7
68
85

My configuration already seems to be set to `log_statement='none'` yet is still logging all queries. – Jacob Mar 12 '15 at 06:20
just go through http://stackoverflow.com/questions/722221/how-to-log-postgresql-queries you'll get more details about logging – Vivek S. Mar 12 '15 at 06:26

score 0 · Answer 2 · answered Feb 18 '16 at 05:29

0

@jacob You can restart the postgresql service by sudo /etc/init.d/postgresql restart or sudo service postgresql restart.

answered Feb 18 '16 at 05:29

sudalai mani

1
1
2

1

This should be a comment – ρяσѕρєя K Feb 18 '16 at 05:42
Sorry @ρяσѕρєяK I am new to here. So i did't have a permission to add a comments in others answer. – sudalai mani Feb 18 '16 at 11:26

Only log errors in Postgres (not all queries)

2 Answers2