CODEWITHSUNDEEP
postgresql
kaa
kaa

Reputation: 1367

Destination of PostgreSQL logs

I tuned the server's variables almost like told here, but the log_destination is 'csvlog'. After that in the data directory:

Explain me please -- this is correct behaviour?

If log_destination is 'csvlog' -- the output file will have the *.csv extension, rather than .log?

What log_destination should be, to write logs in to the *.log file?

Thanks!

Upvotes: 2

Views: 1568

Answers (1)

Magnus Hagander
Magnus Hagander

Reputation: 25178

Yes, if log_destination is csvlog, it will write to the csvlog, which should not be surprising.

If you want it to the regular logfile, set log_destination=stderr. You also need logging_collector=on, but you already have that if csv logging is working.

Upvotes: 1

Related Questions