How can we help you today? How can we help you today?

Postgres log type

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.
come_flyway_with_me
0

Comments

1 comment

Sort by
  • 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

    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.