I turned on Log Streams and sent them to papertrail. However, my logs are filling up with database connection strings like the following. How do I turn them off?
I found this - https://community.render.com/t/postgres-logs-filled-with-constant-connection-logs/4706 - but when I went to the Render dashboard > database_name > Info > Access Control, deleted the entry for “0.0.0.0/0”, saved, and restarted the database, these logs are still showing up in papertrail.
Feb 25 07:30:27 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [3-1] user=postgres,db=postgres,app=[unknown],client=::1,LOG: connection authorized: user=postgres database=postgres application_name=psql SSL enabled (protocol=TLSv1.2, cipher=A6AE2679-DD51-487E-BF09-500B41E45769, bits=256)
Feb 25 07:30:27 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [1-1] user=[unknown],db=[unknown],app=[unknown],client=::1,LOG: connection received: host=::1 port=48354
Feb 25 07:30:27 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [4-1] user=postgres,db=postgres,app=psql,client=::1,LOG: disconnection: session time: 0:00:00.106 user=postgres database=postgres host=::1 port=48354
Feb 25 07:30:37 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [1-1] user=[unknown],db=[unknown],app=[unknown],client=::1,LOG: connection received: host=::1 port=33220
Feb 25 07:30:37 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [4-1] user=postgres,db=postgres,app=psql,client=::1,LOG: disconnection: session time: 0:00:00.192 user=postgres database=postgres host=::1 port=33220
Feb 25 07:30:37 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [3-1] user=postgres,db=postgres,app=[unknown],client=::1,LOG: connection authorized: user=postgres database=postgres application_name=psql SSL enabled (protocol=TLSv1.2, cipher=A6AE2679-DD51-487E-BF09-500B41E45769, bits=256)
Feb 25 07:30:37 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [2-1] user=postgres,db=postgres,app=[unknown],client=::1,LOG: connection authenticated: identity="postgres" method=md5 (/pgdata/dpg-brglslcurpraq1a53gqj-a/pg_hba.conf:90)
Feb 25 07:30:47 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [1-1] user=[unknown],db=[unknown],app=[unknown],client=::1,LOG: connection received: host=::1 port=46626
Feb 25 07:30:47 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [4-1] user=postgres,db=postgres,app=psql,client=::1,LOG: disconnection: session time: 0:00:00.052 user=postgres database=postgres host=::1 port=46626
Feb 25 07:30:47 dpg-brglslcurpraq1a53gqj-a-5f8b449494-wqp85 dpg-wqp85 [2-1] user=postgres,db=postgres,app=[unknown],client=::1,LOG: connection authenticated: identity="postgres" method=md5 (/pgdata/dpg-brglslcurpraq1a53gqj-a/pg_hba.conf:90)