Обсуждение: [HACKERS] I could not see any row in audit table
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 bigserial PRIMARY KEY, schema_name text NOT NULL, TABLE_NAME text NOT NULL, relid oid NOT NULL, session_user_name text, action_tstamp_tx TIMESTAMP WITH TIME ZONE NOT NULL, action_tstamp_stm TIMESTAMP WITH TIME ZONE NOT NULL, action_tstamp_clk TIMESTAMP WITH TIME ZONE NOT NULL, transaction_id BIGINT, application_name text, client_addr inet, client_port INTEGER, client_query text NOT NULL, action CHAR(1) NOT NULL CHECK (action IN ('I','D','U', 'T')), row_data hstore, changed_fields hstore, statement_only BOOLEAN NOT NULL );Now this table contains 50 GB of data , But when taking its backup using pg_dump and after restoring , it show that it has zero row.
How to see the restored data?
--
With Regards!
Shailesh Singh
Shailesh Singh
On 25 January 2017 at 13:28, Shailesh Singh <shailesh.singh1988@gmail.com> 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 That is not part of PostgreSQL proper. Please use the pgsql-general mailing list or Stack Overflow to discuss issues not related to the core code of the PostgreSQL project. -- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services