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 error while restoring data. After Restoring when i issued select count(*) from audit.logged_actions ; , it shows zero row count , Some thing related to *toastble *i found as my table uses extended data type size , but till now not able to view data after restoring. On Wed, Jan 25, 2017 at 7:56 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > 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 >> <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. >> > > What was the dump command you used? > > Where there any errors during the restore? > > >> >> How to see the restored data? >> ** >> >> -- >> With Regards! >> Shailesh Singh >> >> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- With Regards! Shailesh Singh
