Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: PostgreSQL Administration <pgsql-admin(at)postgresql(dot)org>, General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] "global/pg_control": Permission denied
Date: 2007-11-15 18:19:49
Message-ID: 20071115181948.GA17793@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Richard Broersma Jr wrote:
> --- On Thu, 11/15/07, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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.

In response to

pgsql-admin by date

Next:From: Trent PingenotDate: 2007-11-15 21:02:35
Subject: PG Service won't start
Previous:From: Richard Broersma JrDate: 2007-11-15 18:09:12
Subject: Re: [GENERAL] "global/pg_control": Permission denied

pgsql-general by date

Next:From: Andrew SullivanDate: 2007-11-15 18:30:13
Subject: Re: Postgresql and resource isolation
Previous:From: Joshua D. DrakeDate: 2007-11-15 18:19:19
Subject: Re: Postgresql and resource isolation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group