| From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
|---|---|
| To: | Frank Church <vfclists(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is there a way to recover deleted records if database has not been vacuumed? |
| Date: | 2012-07-02 10:06:18 |
| Message-ID: | CALnrrJRT+Ao_qQyj_YZWGAEkQfSSg=-HNNB+ANLj_DLy4BHinQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 2, 2012 at 3:21 PM, Frank Church <vfclists(at)gmail(dot)com> wrote:
>
> I am using Django to develop an app and I think I must have done a syncdb
> (which deletes all records) without realizing it.
>
> I have not vacuumed that database and I have also made a copy of the data
> directory.
>
> Is there some way to recover the deleted records?
>
>
You can perform Point in time recovery to recover the deleted records,if
you have enabled database in WAL archiving mode.
Below URL provides more information of the Point-in-time recovery on
PostgreSQL
http://www.mkyong.com/database/postgresql-point-in-time-recovery-incremental-backup/
Thanks & Regards,
Raghu Ram
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2012-07-02 10:46:56 | Re: is there any query so that I may find the list of columns those have rules? |
| Previous Message | Frank Church | 2012-07-02 09:51:33 | Is there a way to recover deleted records if database has not been vacuumed? |