recover deleted data

Started by AI Rummanover 12 years ago3 messagesgeneral

rummandba@gmail.com

over 12 years ago

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

Thanks.

Kevin.Grittner@wicourts.gov

over 12 years ago

In reply to: AI Rumman (#1)

Re: recover deleted data

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*:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

rapimo@adeven.com

over 12 years ago

In reply to: AI Rumman (#1)

table inheritance and locks

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general