Re: PG 8.4 won't start on Windows Server 2008 64-bit

I ran postgres manually and got some additional information. The full
log is

2010-08-03 15:34:01 GMT DEBUG:  00000: postgres: PostmasterMain: initial
environ dump:
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:736
2010-08-03 15:34:01 GMT DEBUG:  00000:
-----------------------------------------
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:738
2010-08-03 15:34:01 GMT DEBUG:  00000:     ALLUSERSPROFILE=C:\ProgramData
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
APPDATA=C:\Users\postgres\AppData\Roaming
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     CLIENTNAME=ORC-LPT-053
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     CommonProgramFiles=c:\Program
Files (x86)\Common Files
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
CommonProgramFiles(x86)=c:\Program Files (x86)\Common Files
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     CommonProgramW6432=c:\Program
Files\Common Files
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     COMPUTERNAME=TRAVELTIMEDEV
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
ComSpec=C:\Windows\system32\cmd.exe
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     FP_NO_HOST_CHECK=NO
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     HOMEDRIVE=C:
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     HOMEPATH=\Users\postgres
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
LOCALAPPDATA=C:\Users\postgres\AppData\Local
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LOGONSERVER=\\TRAVELTIMEDEV
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     OS=Windows_NT
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROCESSOR_ARCHITECTURE=x86
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROCESSOR_ARCHITEW6432=AMD64
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROCESSOR_IDENTIFIER=Intel64
Family 6 Model 26 Stepping 5, GenuineIntel
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROCESSOR_LEVEL=6
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROCESSOR_REVISION=1a05
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     ProgramData=C:\ProgramData
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     ProgramFiles=c:\Program Files
(x86)
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     ProgramFiles(x86)=c:\Program
Files (x86)
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     ProgramW6432=c:\Program Files
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PROMPT=$P$G
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     PUBLIC=C:\Users\Public
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     SESSIONNAME=RDP-Tcp#0
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     SystemDrive=C:
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     SystemRoot=C:\Windows
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
TEMP=C:\Users\postgres\AppData\Local\Temp\2
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
TMP=C:\Users\postgres\AppData\Local\Temp\2
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     USERDOMAIN=TRAVELTIMEDEV
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     USERNAME=postgres
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     USERPROFILE=C:\Users\postgres
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     windir=C:\Windows
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
PGLOCALEDIR=C:/PostgreSQL/8.4/share/locale
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
PGSYSCONFDIR=C:/PostgreSQL/8.4/etc
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_COLLATE=English_United
States.1252
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_CTYPE=English_United
States.1252
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_MONETARY=C
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_NUMERIC=C
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_TIME=C
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:     LC_MESSAGES=C
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:741
2010-08-03 15:34:01 GMT DEBUG:  00000:
-----------------------------------------
2010-08-03 15:34:01 GMT LOCATION:  PostmasterMain,
.\src\backend\postmaster\postmaster.c:743
2010-08-03 15:34:01 GMT DEBUG:  00000: TZ "US/Eastern" matches Windows
timezone "Eastern Daylight Time"
2010-08-03 15:34:01 GMT LOCATION:  identify_system_timezone,
.\src\timezone\pgtz.c:1088
2010-08-03 11:34:01 EDT DEBUG:  00000: invoking
IpcMemoryCreate(size=37044224)
2010-08-03 11:34:01 EDT LOCATION:  CreateSharedMemoryAndSemaphores,
.\src\backend\storage\ipc\ipci.c:130
2010-08-03 11:34:01 EDT DEBUG:  00000: max_safe_fds = 987, usable_fds =
1000, already_open = 3
2010-08-03 11:34:01 EDT LOCATION:  set_max_safe_fds,
.\src\backend\storage\file\fd.c:479
2010-08-03 11:34:02 EDT DEBUG:  00000: logger shutting down
2010-08-03 11:34:02 EDT LOCATION:  SysLoggerMain,
.\src\backend\postmaster\syslogger.c:446
2010-08-03 11:34:02 EDT DEBUG:  00000: shmem_exit(0): 0 callbacks to make
2010-08-03 11:34:02 EDT LOCATION:  shmem_exit,
.\src\backend\storage\ipc\ipc.c:211
2010-08-03 11:34:02 EDT DEBUG:  00000: proc_exit(0): 0 callbacks to make
2010-08-03 11:34:02 EDT LOCATION:  proc_exit_prepare,
.\src\backend\storage\ipc\ipc.c:183
2010-08-03 11:34:02 EDT DEBUG:  00000: exit(0)
2010-08-03 11:34:02 EDT LOCATION:  proc_exit,
.\src\backend\storage\ipc\ipc.c:135

Hope this helps.
David

On 8/3/2010 11:05 AM, David R Robison wrote:
>  I installed PostgreSQL 8.4 using the one-click installer. However,
> the postgres-8.4 windows service will not start. I have checked the
> Windows Event Log but there are no entries except one saying that the
> service start timed out. I checked the pg_log directory and all that
> is logged is
>
> 2010-08-03 10:42:26 EDT DEBUG:  00000: logger shutting down
> 2010-08-03 10:42:26 EDT LOCATION:  SysLoggerMain,
> .\src\backend\postmaster\syslogger.c:446
> 2010-08-03 10:42:26 EDT DEBUG:  00000: shmem_exit(0): 0 callbacks to make
> 2010-08-03 10:42:26 EDT LOCATION:  shmem_exit,
> .\src\backend\storage\ipc\ipc.c:211
> 2010-08-03 10:42:26 EDT DEBUG:  00000: proc_exit(0): 0 callbacks to make
> 2010-08-03 10:42:26 EDT LOCATION:  proc_exit_prepare,
> .\src\backend\storage\ipc\ipc.c:183
> 2010-08-03 10:42:26 EDT DEBUG:  00000: exit(0)
> 2010-08-03 10:42:26 EDT LOCATION:  proc_exit,
> .\src\backend\storage\ipc\ipc.c:135
>
> Any ideas how to get this to work?
>
> Thanks in advance, David
>

--

David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: (757) 546-3401
e-mail: drrobison@openroadsconsulting.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526

This e-mail communication (including any attachments) may contain confidential and/or privileged material intended
solelyfor the individual or entity to which it is addressed.  If you are not the intended recipient, you should
immediatelystop reading this message and delete it from all computers that it resides on. Any unauthorized reading,
distribution,copying or other use of this communication (or its attachments) is strictly prohibited.  If you have
receivedthis communication in error, please notify us immediately.