To disable pgAudit on an AlloyDB instance, set the value of the
alloydb.enable_pgaudit flag to
off. You can change the
value of the
alloydb.enable_pgaudit flag through the Google Cloud console
or the gcloud command.
To disable the
alloydb.enable_pgaudit flag, use the standard
instructions as described in
Configure an instance's database flags.
When you disable the
alloydb.enable_pgaudit flag, audit logging stops
immediately. However, it saves the applied pgAudit settings such as the pgaudit.log
Additionally, run the
DROP EXTENSION command by using a compatible
psql client to remove the extension state.
You disable an extension by reversing the procedure used to enable it.
- Connect a
psqlclient to the cluster's primary instance, as described in Connect a psql client to an instance.
- At the
psqlcommand prompt, connect to the database that has the extension enabled and drop the extension:
\c DB_NAME DROP EXTENSION pgaudit;
- Repeat the previous two steps to connect to other databases and create the extension in each one of them.