BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied

From: tsialiam(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied
Date: 2012-07-13 13:00:23
Message-ID: E1SpfTr-0004sc-RC@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6735
Logged by: Petros Tsialiamanis
Email address: tsialiam(at)gmail(dot)com
PostgreSQL version: 8.3.5
Operating system: WinXP Pro SP3
Description:

Hi,
The first time I started the postgresql server as 'Local System' user and I
created the PGDATA. Now I am trying to start the postgresql server again as
'pss-svc' user which is member of Administrators group and I take the
following error message (I've changed the debug log level) :

C:\Documents and Settings\pss-svc>"C:\Program
Files\ABC\pgsql\bin\pg_ctl.exe" -W start -D "C:\Documents and Settings\All
Users\Application Data\ABC\XYZ\data\pgsql" -o "-p 9432"
DEBUG: 00000: postgres: PostmasterMain: initial environ dump:
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:733
DEBUG: 00000: -----------------------------------------
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:735
DEBUG: 00000: ALLUSERSPROFILE=C:\Documents and Settings\All Users
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: APPDATA=C:\Documents and Settings\pss-svc\Application Data
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: CommonProgramFiles=C:\Program Files\Common Files
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: COMPUTERNAME=PETROS-XP
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: ComSpec=C:\WINDOWS\system32\cmd.exe
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: FP_NO_HOST_CHECK=NO
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: HOMEDRIVE=C:
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: HOMEPATH=\Documents and Settings\pss-svc
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LOGONSERVER=\\PETROS-XP
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: NUMBER_OF_PROCESSORS=1
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: OS=Windows_NT
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000:
Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PGDATA=C:/Documents and Settings/All Users/Application
Data/ABC/XYZ/data/pgsql
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PGLOCALEDIR=C:/Program Files/ABC/pgsql/share/locale
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PGSYSCONFDIR=C:/Program Files/ABC/pgsql/etc
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PROCESSOR_ARCHITECTURE=x86
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PROCESSOR_IDENTIFIER=x86 Family 6 Model 42 Stepping 7,
GenuineIntel
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PROCESSOR_LEVEL=6
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PROCESSOR_REVISION=2a07
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: ProgramFiles=C:\Program Files
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: PROMPT=$P$G
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: SESSIONNAME=Console
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: SystemDrive=C:
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: SystemRoot=C:\WINDOWS
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: TEMP=C:\DOCUME~1\pss-svc\LOCALS~1\Temp
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: TMP=C:\DOCUME~1\pss-svc\LOCALS~1\Temp
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: USERDOMAIN=PETROS-XP
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: USERNAME=pss-svc
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: USERPROFILE=C:\Documents and Settings\pss-svc
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: windir=C:\WINDOWS
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LC_COLLATE=English_United States.1252
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LC_CTYPE=English_United States.1252
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LC_MONETARY=C
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LC_NUMERIC=C
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: LC_TIME=C
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG: 00000: -----------------------------------------
LOCATION: PostmasterMain, .\src\backend\postmaster\postmaster.c:740
DEBUG: 00000: mapped win32 error code 80 to 17
LOCATION: _dosmaperr, .\src\port\win32error.c:182
DEBUG: 00000: TZ "Europe/London" matches Windows timezone "GMT Daylight
Time"
LOCATION: identify_system_timezone, .\src\timezone\pgtz.c:1027
DEBUG: 00000: invoking IpcMemoryCreate(size=37281792)
LOCATION: CreateSharedMemoryAndSemaphores,
.\src\backend\storage\ipc\ipci.c:128
DEBUG: 00000: mapped win32 error code 5 to 13
LOCATION: _dosmaperr, .\src\port\win32error.c:182
PANIC: 42501: could not open control file "global/pg_control": Permission
denied
LOCATION: ReadControlFile, .\src\backend\access\transam\xlog.c:3904

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ryan Kelly 2012-07-13 13:24:19 Re: BUG #6734: create table (like ...) fails if an index has a comment
Previous Message daniele.varrazzo 2012-07-13 12:00:14 BUG #6734: create table (like ...) fails if an index has a comment