CODEWITHSUNDEEP
postgresqlerror-loggingpostgresql-9.4
Jacob
Jacob

Reputation: 6477

Only log errors in Postgres (not all queries)

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.

Upvotes: 1

Views: 6978

Answers (2)

Vivek S.
Vivek S.

Reputation: 21885

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.

Upvotes: 3

sudalai mani
sudalai mani

Reputation: 1

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

Upvotes: 0

Related Questions