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 postgresql.org/docs/9.1/static/runtime-config-logging.html — Vivek S.
– Vivek S., Commented Mar 12, 2015 at 6:03

Vivek S. · Accepted Answer · 2018-10-20 16:00:22Z

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, 2018 at 16:00

answered Mar 12, 2015 at 6:09

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacob Over a year ago

My configuration already seems to be set to log_statement='none' yet is still logging all queries.

Vivek S. Over a year ago

just go through stackoverflow.com/questions/722221/… you'll get more details about logging

sudalai mani · Accepted Answer · 2016-02-18 05:29:46Z

0

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

answered Feb 18, 2016 at 5:29

sudalai mani

11 silver badge2 bronze badges

2 Comments

ρяσѕρєя K Over a year ago

This should be a comment

sudalai mani Over a year ago

Sorry @ρяσѕρєяK I am new to here. So i did't have a permission to add a comments in others answer.

Collectives™ on Stack Overflow

Only log errors in Postgres (not all queries)

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related