Re: [GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Adrian Klaver
On 01/25/2017 09:57 AM, Shailesh Singh wrote: Dear Adrian Klaver, I have used pg_dump to take backup eg: pg_dump my_db > /dbbackup/audit_table.sql To be clear you dumped the entire database, not just the audit table, correct? Meant to ask before, are you dumping/restoring between the same P

Re: [GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Shailesh Singh
Dear Adrian Klaver, I have used pg_dump to take backup eg: pg_dump my_db > /dbbackup/audit_table.sql And I have restored it using psql command eg: psql my_test_db < /dbbackup/audit_table.sql before it has had also created necessay hstore extension for my new db " *my_test_db*" There is no err

Re: [GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Adrian Klaver
On 01/25/2017 03:03 AM, Shailesh Singh wrote: Dear Group Member , I had configured the audit trigger for my datbase following the below document url: *https://wiki.postgresql.org/wiki/Audit_trigger_91plus * Now my audit table : CREA

Re: [GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Raymond O'Donnell
On 25/01/17 11:03, Shailesh Singh wrote: Dear Group Member , I had configured the audit trigger for my datbase following the below document url: *https://wiki.postgresql.org/wiki/Audit_trigger_91plus * Now my audit table : CREATE TA

[GENERAL] Fwd: I could not see any row in audit table

2017-01-25 Thread Shailesh Singh
Dear Group Member , I had configured the audit trigger for my datbase following the below document url: *https://wiki.postgresql.org/wiki/Audit_trigger_91plus * Now my audit table : CREATE TABLE audit.logged_actions ( event_id bigser