Description
On PostgreSQL 15, I enabled pgaudit by adding it to the preload stanza, and then enabled it inside database "foo." It ate up way too much log space. So, I dropped it.
DROP EXTENSION pgaudit;
The result is this:
foo-# \dx
List of installed extensions
Name | Version | Schema | Description
--------------------+---------+------------+------------------------------------------------------------------------
ltree | 1.2 | public | data type for hierarchical tree-like structures
pg_repack | 1.4.8 | public | Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_statements | 1.10 | public | track planning and execution statistics of all SQL statements executed
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(4 rows)
The foo.audit schema was left behind, so I dropped it.
And now the database is generating gigabytes of error logs. (Sorry about the json)
{"timestamp":"2024-07-19 15:56:29.133 CDT","user":"foo_hq","dbname":"foo","pid":3505487,"remote_host":"10.3.31.62","remote_port":46878,"session_id":"669ad2e1.357d4f","line_num":1717,"ps":"PARSE","session_start":"2024-07-19 15:56:01 CDT","vxid":"12/5128","txid":0,"error_severity":"ERROR","state_code":"42P01","message":"relation \"resource_audit_entry_data\" does not exist","statement":"INSERT INTO \"resource_audit_entry_data\" (\"audit_entry_id\",\"action_nm\",\"type_nm\",\"info_txt\",\"state_nm\",\"object_uri\",\"user_nm\",\"remote_address_txt\",\"trace_id_txt\",\"application_nm\",\"entry_dttm\",\"http_method_nm\",\"http_query_txt\",\"http_status_cd\",\"administrative_action_flg\",\"session_sig\") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)","cursor_position":13,"application_name":"audit","backend_type":"client backend","query_id":0}
How do I disable what I assume are some kind of event triggers?