Re: PG 8.4 won't start on Windows Server 2008 64-bit
От | David R Robison |
---|---|
Тема | Re: PG 8.4 won't start on Windows Server 2008 64-bit |
Дата | |
Msg-id | 4C5837BA.1040108@openroadsconsulting.com обсуждение исходный текст |
Ответ на | PG 8.4 won't start on Windows Server 2008 64-bit (David R Robison <drrobison@openroadsconsulting.com>) |
Ответы |
Re: PG 8.4 won't start on Windows Server 2008 64-bit
(David R Robison <drrobison@openroadsconsulting.com>)
Re: PG 8.4 won't start on Windows Server 2008 64-bit (Craig Ringer <craig@postnewspapers.com.au>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: