Re: how to get the deleted data

From: Brian Modra <brian(at)zwartberg(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to get the deleted data
Date: 2010-05-06 05:30:05
Message-ID: m2n5a9699851005052230j863823b8jecaa1400fc73c807@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/05/2010, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> Unauthorized user deleted some critical data from the database.
> I don't have any log.
>
> Is it possible to get what was the command used to delete the data?
>

Is your server saving WAL's?
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaume Calm 2010-05-06 07:57:28 I need to take metadata from a shell script.
Previous Message AI Rumman 2010-05-06 05:04:39 how to get the deleted data