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

[David R Robison <drrobison@xxxxxxxxxxxxxxxxxxxxxxx>]

 I uninstalled 8.4 and installed 8.3 with the same results. Any 
thoughts? David

On 8/3/2010 11:37 AM, David R Robison wrote:
>  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@xxxxxxxxxxxxxxxxxxxxxxx
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 solely for the individual or entity to which it is addressed.  If you are not the intended recipient, you should immediately stop 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 received this communication in error, please notify us immediately.



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general