Pgaudit set-user breaks my node

PostgreSQL
1

My Percona HA setup is up and working and I am busy with the instructions on " Enable Percona Distribution for PostgreSQL components" page.

When I do the pgaudit setup, everytime I get to the instruction pgaudit set-user “ALTER SYSTEM SET shared_preload_libraries = ‘set-user’;” it breaks my node and I have to revert back to snapshot.

$ patronictl -c /etc/patroni/patroni.yml restart cluster_2

  • Cluster: cluster_2 (7395511988029761997) ------±—±----------+
    | Member | Host | Role | State | TL | Lag in MB |
    ±-------±-------------±--------±-------------±—±----------+
    | node1 | 192.168.8.41 | Leader | running | 10 | |
    | node2 | 192.168.8.42 | Replica | start failed | | unknown |
    | node3 | 192.168.8.43 | Replica | streaming | 10 | 0 |
    ±-------±-------------±--------±-------------±—±----------+
    Any ideas why this happens?

I am using 15.7 Instructions
on Alma Linux 9.4
I have seen this in the forum
" kaushal.worxpro

Jun 2022

open the file /var/lib/pgsql/14/data/postgresql.auto.conf and
please comment this line : shared_preload_libraries = ‘“set-user”’
and then you can restart the postgresql service sudo systemctl restart postgresql-14
it will work"
So I looked at this but get a warning not to edit it manually

sudo nano /mnt/sdb/postgresql/postgresql.auto.conf

# Do not edit this file manually!
# It will be overwritten by the ALTER SYSTEM command.

I did manually edit the file but it still give me errors
2024-07-25 09:39:41,672 INFO: failed to start postgres

$ patronictl -c /etc/patroni/patroni.yml list

  • Cluster: cluster_2 (7395511988029761997) ------±—±----------+
    | Member | Host | Role | State | TL | Lag in MB |
    ±-------±-------------±--------±-------------±—±----------+
    | node1 | 192.168.8.41 | Replica | start failed | | unknown |
    | node2 | 192.168.8.42 | Replica | streaming | 11 | 0 |
    | node3 | 192.168.8.43 | Leader | running | 11 | |
    ±-------±-------------±--------±-------------±—±----------+