Re: [GENERAL] [ADMIN] "global/pg_control": Permission denied

Richard Broersma Jr wrote:
> --- On Thu, 11/15/07, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> > What is the problem with the file?
>
> I looked at the pg_control file, postgres had the proper permission to it.
>
> > Why is it not accessible to Postgres?
> > My guess is that something (antivirus?) was messing with
> > the file when the system died.
>
> It seems that last night a windows service pack as added. I noticed that the global directory was marked as (grey-ed)read-only. I removed the read-only flag and postgres started up :-). I restarted my antivirus and postgres is still working.
>
> Is the global directory supposed to be marked read only?

I don't think so. Postgres writes to it.

-- 
Alvaro Herrera                  
http://www.amazon.com/gp/registry/5ZYLFMCVHXC
We take risks not to escape from life, but to prevent life escaping from us.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match