Re: WAL to get back data in 7.4.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: doris riedl <doris(dot)riedl(at)univie(dot)ac(dot)at>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: WAL to get back data in 7.4.
Date: 2006-04-05 02:48:36
Message-ID: 23173.1144205316@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

doris riedl <doris(dot)riedl(at)univie(dot)ac(dot)at> writes:
> I have a postgres version 7.4.
> Today I overwrote some data with an update statement, but only saw it after
> I quit the database.
> Can I use WAL to get back the data? - I know the time of my failure up to
> one minute exact.

Nope, the infrastructure to do that didn't exist before PG 8.0, and even
then it requires keeping backups that you don't have. Sorry ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message James Long 2006-04-05 07:37:48 How to append records into a file which has serial unique IDs?
Previous Message Luis Silva 2006-04-04 23:01:02 for loop help