pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed[SQL] Restore deleted records
4+ messages / 4 participants
[nested] [flat]
* [SQL] Restore deleted records
@ 1999-03-20 14:44 Eugenia Bulakh <jane@mistral.ru>
0 siblings, 0 replies; 4+ messages in thread
From: Eugenia Bulakh @ 1999-03-20 14:44 UTC (permalink / raw)
To: pgsql-sql
Hello.
I accidentally deleted some recordes from my table. How can I restore
them? Is it possible in 6.4.2?
In earler versions I used 'Time travel' feature, which allows a user to
run a historical queries. But in 6.3 it was removed. Can I do it another
way?
Thanks in advance.
Jane.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Restore deleted records
@ 2003-08-26 09:37 Konstantin Petrenko <kostik@esir.ru>
2003-08-26 20:02 ` Re: Restore deleted records CoL <col@mportal.hu>
0 siblings, 1 reply; 4+ messages in thread
From: Konstantin Petrenko @ 2003-08-26 09:37 UTC (permalink / raw)
To: pgsql-sql
Hello.
I accidentally deleted some recordes from my table. How can I restore
them? Is it possible in 7.3.3?
Thanks
Konstantin Petrenko.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Restore deleted records
2003-08-26 09:37 Restore deleted records Konstantin Petrenko <kostik@esir.ru>
@ 2003-08-26 20:02 ` CoL <col@mportal.hu>
2003-08-27 12:36 ` Re: Restore deleted records Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 4+ messages in thread
From: CoL @ 2003-08-26 20:02 UTC (permalink / raw)
To: pgsql-sql
Hi,
Konstantin Petrenko wrote, On 8/26/2003 11:37 AM:
> Hello.
>
> I accidentally deleted some recordes from my table. How can I restore
> them? Is it possible in 7.3.3?
if you have a dump, or you are still in a transaction, you can rollback.
C.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Restore deleted records
2003-08-26 09:37 Restore deleted records Konstantin Petrenko <kostik@esir.ru>
2003-08-26 20:02 ` Re: Restore deleted records CoL <col@mportal.hu>
@ 2003-08-27 12:36 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2003-08-27 12:36 UTC (permalink / raw)
To: CoL <col@mportal.hu>; +Cc: pgsql-sql
> Konstantin Petrenko wrote, On 8/26/2003 11:37 AM:
>
> >Hello.
> >
> >I accidentally deleted some recordes from my table. How can I restore
> >them? Is it possible in 7.3.3?
> if you have a dump, or you are still in a transaction, you can rollback.
I avoided responding earlier, hoping you could get some more detailed help.
Besides recovering from backup (or not committing the transaction if by
some chance you haven't already) you can probably get back data from the
deleted rows if you haven't run a vacuum since committing the delete.
I don't know the specifics of how to do this, but the initial step will
be to shut the database cluster down and make a copy of it before running
vacuum. Once vacuum has been run, the old tuples will start being written
over and you won't have a reliable way to recover the data. If you have
alrerady done a vacuum full, you probably won't be able to much of anything
back.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-08-27 12:36 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-20 14:44 [SQL] Restore deleted records Eugenia Bulakh <jane@mistral.ru>
2003-08-26 09:37 Restore deleted records Konstantin Petrenko <kostik@esir.ru>
2003-08-26 20:02 ` CoL <col@mportal.hu>
2003-08-27 12:36 ` Bruno Wolff III <bruno@wolff.to>
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