Richard Broersma Jr wrote: > --- On Thu, 11/15/07, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> 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