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';