Обсуждение: Re: [ADMIN] "global/pg_control": Permission denied

Поиск
Список
Период
Сортировка

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

От
Richard Broersma Jr
Дата:
--- On Thu, 11/15/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:

> My desktop (acting as a db-server for my discipline's
> group) has it power cycled this morning at 4:10
>...
> C:\Program
> Files\PostgreSQL\8.2\bin>2007-11-15 06:36:13
> PANIC:  could not open control file
> "global/pg_control": Permission denied
>...

Does anyone have any comments on how to restore db operation after encounter this failure?  Do I need to go as far have
re-installingPostgres and restoring from a dump? 

Regards,
Richard Broersma Jr.

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

От
Alvaro Herrera
Дата:
Richard Broersma Jr wrote:
> --- On Thu, 11/15/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
> > My desktop (acting as a db-server for my discipline's
> > group) has it power cycled this morning at 4:10
> >...
> > C:\Program
> > Files\PostgreSQL\8.2\bin>2007-11-15 06:36:13
> > PANIC:  could not open control file
> > "global/pg_control": Permission denied
> >...
>
> Does anyone have any comments on how to restore db operation after
> encounter this failure?  Do I need to go as far have re-installing
> Postgres and restoring from a dump?

What is the problem with the file?  Why is it not accessible to
Postgres?

My guess is that something (antivirus?) was messing with the file when
the system died.

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"

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

От
Richard Broersma Jr
Дата:
--- 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
stillworking. 

Is the global directory supposed to be marked read only?

Regards,
Richard Broersma Jr.

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

От
Alvaro Herrera
Дата:
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
stillworking. 
>
> 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.