Обсуждение: recover deleted data

Поиск
Список
Период
Сортировка

recover deleted data

От
AI Rumman
Дата:
Is there any way to recover deleted record in Postgresql 9.2 if we don't have any backup.

Thanks.

Re: recover deleted data

От
Kevin Grittner
Дата:
AI Rumman <rummandba@gmail.com> wrote:

> Is there any way to recover deleted record in Postgresql 9.2 if
> we don't have any backup.

I would recommend following the advice here *immediately*:

http://wiki.postgresql.org/wiki/Corruption

Any recoverable data may be disappearing through normal maintenance
operations as long as the server is running.

Then follow the advice in the "What next?" section of that page.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


table inheritance and locks

От
Manuel Kniep
Дата:
Hi,

If I aquire a lock on table B which is inherited from table A, Table A seems to be also locked (postgres 9.2).
Is there a way to get around it ?

I couldn't find any information about this behavior in the documentation.

Thanks

Manuel Kniep