pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Broersma Jr <rabroersma@yahoo.com>
To: PostgreSQL Administration <pgsql-admin@postgresql.org>
Subject: "global/pg_control": Permission denied
Date: Thu, 15 Nov 2007 06:50:37 -0800 (PST)
Message-ID: <584397.59877.qm@web31803.mail.mud.yahoo.com> (raw)

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.



view thread (5+ messages)  latest in thread

Message-ID: <584397.59877.qm@web31803.mail.mud.yahoo.com>
Permalink:  ../584397.59877.qm@web31803.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/584397.59877.qm@web31803.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rabroersma@yahoo.com
  Subject: Re: "global/pg_control": Permission denied
  In-Reply-To: <584397.59877.qm@web31803.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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