pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
"global/pg_control": Permission denied
5+ messages / 2 participants
[nested] [flat]

* "global/pg_control": Permission denied
@ 2007-11-15 14:50 Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 16:06 ` Re: "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Richard Broersma Jr @ 2007-11-15 14:50 UTC (permalink / raw)
  To: pgsql-admin

Last night,

My desktop (acting as a db-server for my discipline's group) has it power cycled this morning at 4:10 (I am not sure what triggered the power cycle).  When the computer restarted itself PostgreSQL failed to start on its own.  I attempted to start it manually but encounter the following error.  If I need to, I can re-install postgres and restore a dump file that I took last night. But I would like to discover why this happened so that I can hopefully prevent it from reoccurring in the future.

...
C:\Program Files\PostgreSQL\8.2\bin>pg_ctl start -D ..\data
server starting

C:\Program Files\PostgreSQL\8.2\bin>2007-11-15 06:36:13 PANIC:  could not open control file "global/pg_control": Permission denied

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
...

I don't know if this is related, but I also saw an error raised in the windows event viewer by Postgres when postgres attempted to restart itself after the power cycle:

...
2007-11-15 06:26:26 FATAL:  invalid value for parameter "log_statement_stats": 1
...

Also right before the power cycled I saw this warning:

...
Windows saved user JEG\BroersR registry while an application or service was still using the registry during log off. The memory used by the user's registry has not been freed. The registry will be unloaded when it is no longer in use. 

 This is often caused by services running as a user account, try configuring the services to run in either the LocalService or NetworkService account.

For more information, see Help and Support Center at 
http://go.microsoft.com/fwlink/events.asp
...

Regards, Richard Broersma Jr.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: "global/pg_control": Permission denied
  2007-11-15 14:50 "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
@ 2007-11-15 16:06 ` Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 17:27   ` Re: [GENERAL] "global/pg_control": Permission denied Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 1 reply; 5+ messages in thread

From: Richard Broersma Jr @ 2007-11-15 16:06 UTC (permalink / raw)
  To: pgsql-admin; General PostgreSQL List <pgsql-general@postgresql.org>

--- 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?

Regards,
Richard Broersma Jr.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [GENERAL] "global/pg_control": Permission denied
  2007-11-15 14:50 "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 16:06 ` Re: "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
@ 2007-11-15 17:27   ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  2007-11-15 18:09     ` Re: [GENERAL] "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Alvaro Herrera @ 2007-11-15 17:27 UTC (permalink / raw)
  To: Richard Broersma Jr <rabroersma@yahoo.com>; +Cc: pgsql-admin; General PostgreSQL List <pgsql-general@postgresql.org>

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"



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [GENERAL] "global/pg_control": Permission denied
  2007-11-15 14:50 "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 16:06 ` Re: "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 17:27   ` Re: [GENERAL] "global/pg_control": Permission denied Alvaro Herrera <alvherre@alvh.no-ip.org>
@ 2007-11-15 18:09     ` Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 18:19       ` Re: [GENERAL] "global/pg_control": Permission denied Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 1 reply; 5+ messages in thread

From: Richard Broersma Jr @ 2007-11-15 18:09 UTC (permalink / raw)
  To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: pgsql-admin; General PostgreSQL List <pgsql-general@postgresql.org>

--- 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?

Regards,
Richard Broersma Jr.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [GENERAL] "global/pg_control": Permission denied
  2007-11-15 14:50 "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 16:06 ` Re: "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
  2007-11-15 17:27   ` Re: [GENERAL] "global/pg_control": Permission denied Alvaro Herrera <alvherre@alvh.no-ip.org>
  2007-11-15 18:09     ` Re: [GENERAL] "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
@ 2007-11-15 18:19       ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 0 replies; 5+ messages in thread

From: Alvaro Herrera @ 2007-11-15 18:19 UTC (permalink / raw)
  To: Richard Broersma Jr <rabroersma@yahoo.com>; +Cc: pgsql-admin; General PostgreSQL List <pgsql-general@postgresql.org>

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-11-15 18:19 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-15 14:50 "global/pg_control": Permission denied Richard Broersma Jr <rabroersma@yahoo.com>
2007-11-15 16:06 ` Richard Broersma Jr <rabroersma@yahoo.com>
2007-11-15 17:27   ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2007-11-15 18:09     ` Richard Broersma Jr <rabroersma@yahoo.com>
2007-11-15 18:19       ` Alvaro Herrera <alvherre@alvh.no-ip.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox