From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pgaudit log directory |
Date: | 2019-11-19 09:31:06 |
Message-ID: | 36aad771-a10a-785d-c681-db345c14a773@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 18/11/19 9:56 μ.μ., Dave Hughes wrote:
> Hello,
> I'm using PostgreSQL 10.5 on Linux (RHEL). I'm new to administering PostgreSQL and recently installed pgaudit. I believe I have it installed correctly and wanted to start playing with it to see
> how exactly it works.
>
> So while walking through a tutorial I found online, I saw where I can enter a statement in PostgreSQL, such as:
> ALTER SYSTEM SET pgaudit.log TO 'read, write';
> SELECT pg_reload_conf();
> Then after reading or writing to a table, you can then check "pg_log" for the audit entries. But my issue is that I can't find the log file at all?
>
> In my main PostgreSQL directory (/work/PostgreSQL/10)I do have a file called "logfile", but there are no entries from today. When I go into the pgaudit sub-directory (/work/PostegreSQL/10/pgaudit)
> I don't see any log file in there either?
pgaudit writes in the standard pgsql log.
>
> Can someone point me in the right direction?
>
> Thanks,
> Dave Hughes
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Winkless | 2019-11-19 11:37:04 | Re: REINDEX VERBOSE unknown option |
Previous Message | David Rowley | 2019-11-19 06:24:07 | Re: Partition, inheritance for storing syslog records. |