From: | Shailesh Singh <shailesh(dot)singh1988(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fwd: I could not see any row in audit table |
Date: | 2017-01-25 17:57:47 |
Message-ID: | CANLO8r_qF3ZbHCxYio-X_GVSZcfGGa90brYVP-qQbP2DSebfnQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
--
With Regards!
Shailesh Singh
From | Date | Subject | |
---|---|---|---|
Next Message | ProPAAS DBA | 2017-01-25 20:30:11 | Re: psql only works with -h (even localhost) |
Previous Message | Alfredo Palhares | 2017-01-25 17:36:12 | Tips on maintaining several pg_hba files |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-01-25 17:58:30 | Re: Checksums by default? |
Previous Message | Peter Eisentraut | 2017-01-25 17:55:25 | Re: pdf versus single-html |