Thread: BUG #8091: No permissions on the table file causing recovery failure

As the following raised bug is not received by the bugs mailing list.
Forwarding the same to mailing list.

http://www.postgresql.org/message-id/E1USmqv-0006X0-5X@wrigleys.postgresql.o
rg

Please check the above defect needs any handling?

Regards,
Hari babu.

On 24.04.2013 08:01, Hari Babu wrote:
> As the following raised bug is not received by the bugs mailing list.
> Forwarding the same to mailing list.
>
> http://www.postgresql.org/message-id/E1USmqv-0006X0-5X@wrigleys.postgresql.o
> rg
>
> Please check the above defect needs any handling?

> 1. create table.
> 2. change the file permissions.
> 3. Drop table.
> 4. Restart the server leads to recovery failure.

I think the answer to that is "don't do that". There is an arbitrary
number of ways you can make the system fail, if you mess with the files
in the data directory. This is just one of them.

- Heikki