Postgres log type

come_flyway_with_me

I want to set up monitor but the docs say that " log_destination must contain 'csvlog'" does this mean it can only be csv or could I set it up as both stderr & csvlog? 

I think this might not work because the function "pg_catalog.pg_current_logfile()" wouldn't return the correct log file. 

Is this possible?

I don't want to change the type of our log files because we ship them to cloudwatch.

Jon_Kirkwood

Hi @come_flyway_with_me

 

Thank you for reaching out on the Redgate forums regarding your Redgate Monitor PostgreSQL question.

 I have referenced a few users configuring their state to use both stderr & csvlog for Postgres and believe this will function as anticipated.

 

In your postgresql.conf file, can you try setting the log_destination as follows: 

log_destination = 'stderr,csvlog'

 

It may require a restart of the Redgate Monitor service to reload the configuration