Large Postgres logs

By default Crunchy Bridge databases have logging for specific users that connect to the database as well as slow queries. If you're connecting to your database with the default Postgres super user, or individual user roles each query to your database will be logged. This can result in larger than desired Postgres log files being retained and consuming excessive disk space. We recommend by default connecting with application role and not the postgres role. If you have already set things up with your postgres super user role and do not wish to change you can disable auditing for that role:

Disabling logs for users

You can disable audit logs for individual users directly within the settings panel for a given team.

To disable logging for the Postgres super user you can connect to your database with the postgres user and run:

ALTER USER postgres SET pgaudit.log='none';