Re: BUG #8091: No permissions on the table file causing recovery failure - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #8091: No permissions on the table file causing recovery failure
Date
Msg-id 51780271.8080303@vmware.com
Whole thread Raw
In response to BUG #8091: No permissions on the table file causing recovery failure  (Hari Babu <haribabu.kommi@huawei.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: umberto.brighetti@gmail.com
Date:
Subject: BUG #8113: odbc
Next
From: support@securenetterm.com
Date:
Subject: BUG #8114: Peer authentication in cgi-perl