| From: | Dave Hughes <dhughes20(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org | 
| Subject: | pgaudit log directory | 
| Date: | 2019-11-18 19:56:20 | 
| Message-ID: | CAFTBbFCb6bnYXq8VgBDA55=6g9tRrzKE44UMbDP9nQkEoDGVcA@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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?
Can someone point me in the right direction?
Thanks,
Dave Hughes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miles Elam | 2019-11-18 20:01:33 | Re: ERROR: there is no unique constraint matching given keys for referenced table "audit_p" | 
| Previous Message | Shatamjeev Dewan | 2019-11-18 18:58:24 | RE: ERROR: there is no unique constraint matching given keys for referenced table "audit_p" |