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


No, I do not have WAL archiving.
I hope some one have done the hacking in postmaster.
If no one have done this, my idea was to change the vacuum
(or make e new copy).
I am not familiar with pg code, but as I know by running
vacuum, pg marks deleted records as free, and my idea was to
mark this records as real record in the database (if it is
possible).

regards,
ivan.

> 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.
>
> -----Ursprungliche 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by
> donating at
>
>                 http://www.postgresql.org/about/donate
>
>
>




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

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




view thread (5+ messages)  latest in thread

Message-ID: <1181665149.b014150a4b253@mail.bg>
Permalink:  ../1181665149.b014150a4b253@mail.bg/
Also on:    postgresql.org/message-id/1181665149.b014150a4b253@mail.bg

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: zz_11@mail.bg
  Subject: Re: How to restore updated records
  In-Reply-To: <1181665149.b014150a4b253@mail.bg>

* 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