BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied - Mailing list pgsql-bugs

From tsialiam@gmail.com
Subject BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied
Date
Msg-id E1SpfTr-0004sc-RC@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied  (Craig Ringer <ringerc@ringerc.id.au>)
Re: BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6735
Logged by:          Petros Tsialiamanis
Email address:      tsialiam@gmail.com
PostgreSQL version: 8.3.5
Operating system:   WinXP Pro SP3
Description:=20=20=20=20=20=20=20=20

Hi,=20
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) :=20

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"=20
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=3DC:\Documents and Settings\All Users
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     APPDATA=3DC:\Documents and Settings\pss-svc\Application Data
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     CommonProgramFiles=3DC:\Program Files\Common Files
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     COMPUTERNAME=3DPETROS-XP
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     ComSpec=3DC:\WINDOWS\system32\cmd.exe
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     FP_NO_HOST_CHECK=3DNO
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     HOMEDRIVE=3DC:
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     HOMEPATH=3D\Documents and Settings\pss-svc
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LOGONSERVER=3D\\PETROS-XP
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     NUMBER_OF_PROCESSORS=3D1
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     OS=3DWindows_NT
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:
    Path=3DC:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PATHEXT=3D.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PGDATA=3DC:/Documents and Settings/All Users/Application
Data/ABC/XYZ/data/pgsql
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PGLOCALEDIR=3DC:/Program Files/ABC/pgsql/share/locale
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PGSYSCONFDIR=3DC:/Program Files/ABC/pgsql/etc
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PROCESSOR_ARCHITECTURE=3Dx86
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PROCESSOR_IDENTIFIER=3Dx86 Family 6 Model 42 Stepping 7,
GenuineIntel
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PROCESSOR_LEVEL=3D6
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PROCESSOR_REVISION=3D2a07
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     ProgramFiles=3DC:\Program Files
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     PROMPT=3D$P$G
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     SESSIONNAME=3DConsole
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     SystemDrive=3DC:
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     SystemRoot=3DC:\WINDOWS
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     TEMP=3DC:\DOCUME~1\pss-svc\LOCALS~1\Temp
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     TMP=3DC:\DOCUME~1\pss-svc\LOCALS~1\Temp
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     USERDOMAIN=3DPETROS-XP
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     USERNAME=3Dpss-svc
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     USERPROFILE=3DC:\Documents and Settings\pss-svc
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     windir=3DC:\WINDOWS
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LC_COLLATE=3DEnglish_United States.1252
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LC_CTYPE=3DEnglish_United States.1252
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LC_MONETARY=3DC
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LC_NUMERIC=3DC
LOCATION:  PostmasterMain, .\src\backend\postmaster\postmaster.c:738
DEBUG:  00000:     LC_TIME=3DC
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=3D37281792)
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

pgsql-bugs by date:

Previous
From: maxim.boguk@gmail.com
Date:
Subject: BUG #6736: Hot-standby replica crashed after failover:
Next
From: Daniele Varrazzo
Date:
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment