pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mensinger, Oliver <Oliver.Mensinger@rossmann.de>
To: zz_11@mail.bg
To: pgsql-admin@postgresql.org
Subject: Re: How to restore updated records
Date: Tue, 12 Jun 2007 13:53:20 +0200
Message-ID: <A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de> (raw)
References: <1181583306.d9d10231a3c6c@mail.bg>

Ivan,

if you have configured WAL archiving, you may want to look at http://www.postgresql.org/docs/8.1/static/backup-online.html, especially paragraph '23.3.4. Timelines'.

List: Maybe someone already hacked the postmaster to extract deleted records?!

HTH, Oliver.

-----Ursprüngliche Nachricht-----
Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von zz_11@mail.bg
Gesendet: Montag, 11. Juni 2007 19:35
An: pgsql-admin@postgresql.org
Betreff: [ADMIN] How to restore updated records



Hi all.
Sorry for my problem.
I am using pg on ~100 servers fro 5 y. without any problems,
but this time I make a big mistake.

A have a table tasks with about 20000 records.
The table have ID as pk and some other fields.

I typed : update tasks set c1='sss';
instead update tasks setc1='sss' where id=10;

And the pg updated all my table tasks.

I do not have any backup on this table.
Exists any way to restore the data>
After the mistake I stopped to execute any commands to this
database and also I DO NOT HAVE running vacuum, vacuum
analyze ot vacuum full analyze on this table.

I know pg stores the old copy of data, but I do not have any
idea how to restore this deleted records.

Pls., point me to any solution for this problem.

Many thanks and best regards,
ivan.

-----------------------------

SCENA - Единственото БЕЗПЛАТНО списание за мобилни комуникации и технологии.
http://www.bgscena.com/


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org



view thread (5+ messages)  latest in thread

Message-ID: <A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de>
Permalink:  ../A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de/
Also on:    postgresql.org/message-id/A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Oliver.Mensinger@rossmann.de, zz_11@mail.bg
  Subject: Re: How to restore updated records
  In-Reply-To: <A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de>
  References: <1181583306.d9d10231a3c6c@mail.bg> <A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox