Postgresql – PGAUDIT on RHEL 7.4

postgresqlpostgresql-9.6postgresql-extensions

I have download PostGreSQL 9.6 and pgaudit 9.6 from my RHEL repository. I have installed the rpm.

How to I verify it is installed correctly? I have not been able to find good directions.

It seems that I should perhaps

psql -c "CREATE EXTENSION pgaudit"

After install, but I am not sure. When I do try this, I get

-bash-4.2$  psql -c "CREATE EXTENSION pgaudit;"
ERROR:  could not open extension control file "/usr/pgsql-9.6/share/extension/pgaudit.control": No such file or directory

Best Answer

I found out that you have to have

"shared_preload_libraries='pgaudit'"

in the configuration file. Then, this command verifies it is working

SHOW shared_preload_libraries;

Related Solutions

Postgresql – How to upgrade PostgreSQL minor releases without a dump/restore

If you are doing a minor version upgrade, nothing will or should touch your data directory. If you are using binary packages, just run whatever upgrade procedure they provide (apt/yum upgrade, etc.). If building from source, just do make install over the old files and then restart the server (pg_ctl restart or whatever you're using).

The documentation could perhaps be amended to say that you could even install the new binaries before restarting the server.

PostgreSQL not running on Mac

The problem can also be attributed to a crashed process that left postmaster.pid file behind.

$ brew services stop postgresql
# adjust path accordingly to your install, e.g. `/opt/homebrew/var/postgres/postmaster.pid`
$ rm /usr/local/var/postgres/postmaster.pid 
$ brew services start postgresql

Best Answer

Related Solutions

Postgresql – How to upgrade PostgreSQL minor releases without a dump/restore

PostgreSQL not running on Mac

Related Question