psql can't start

From: Андрей Репко <repko(at)sart(dot)must-ipra(dot)com>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: psql can't start
Date: 2004-04-22 15:55:09
Message-ID: 1849104343.20040422185509@sart.must-ipra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

Hello,

After downloading PostgreSQL tarball(21.04.2004), MinGW and MSYS,
I had compile PostgreSQL without errors. After this I run initdb
without errors too. When I run postmaster I have seen the next
messages:

D:\msys\1.0\local\pgsql\bin>postmaster.exe -i
LOG: database system was shut down at 2004-04-22 18:29:11 FLE Daylight Time
LOG: checkpoint record is at 0/A10DE0
LOG: redo record is at 0/A10DE0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 469; next OID: 17208
LOG: select() failed in statistics buffer: Unknown error
LOG: database system is ready
LOG: select() failed in statistics collector: Unknown error
LOG: statistics collector process (PID 2200) was terminated by signal 1

when I try to run psql, I have seen next message:

D:\msys\1.0\local\pgsql\bin>psql.exe
psql.exe: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

On postmaster console I seen next one message:
LOG: could not receive data from client: Unknown error
LOG: incomplete startup packet

So I run postmaster with -d 5 option and on the same situation I have
read the next messages:
D:\msys\1.0\local\pgsql\bin>postmaster.exe -i -d 5 >out
DEBUG: D:\msys\1.0\local\pgsql\bin\postmaster.exe: PostmasterMain: initial envi
ron dump:
DEBUG: -----------------------------------------
DEBUG: ALLUSERSPROFILE=D:\Documents and Settings\All Users.WINNT
DEBUG: APPDATA=D:\Documents and Settings\Administrator\Application Data

DEBUG: CommonProgramFiles=D:\Program Files\Common Files
DEBUG: COMPUTERNAME=PRG-45
DEBUG: ComSpec=D:\WINNT\system32\cmd.exe
DEBUG: FARLANG=English
DEBUG: HOMEDRIVE=D:
DEBUG: HOMEPATH=\
DEBUG: INCLUDE=D:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v
1.1\include\;D:\Program Files\Microsoft Visual Studio\VC98\atl\include;D:\Progra
m Files\Microsoft Visual Studio\VC98\mfc\include;D:\Program Files\Microsoft Visu
al Studio\VC98\include
DEBUG: LIB=D:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\
Lib\;D:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;D:\Program Files\Micr
osoft Visual Studio\VC98\lib
DEBUG: LOGONSERVER=\\PRG-45
DEBUG: MSDevDir=D:\Program Files\Microsoft Visual Studio\Common\MSDev98

DEBUG: NUMBER_OF_PROCESSORS=1
DEBUG: OS=Windows_NT
DEBUG: Os2LibPath=D:\WINNT\system32\os2\dll;
DEBUG: Path=D:\PROGRA~1\EAGLE\CODERU~1\SYSTEM;D:\PROGRA~1\Borland\CBUIL
D~1\Bin;D:\PROGRA~1\Borland\CBUILD~1\Projects\Bpl;D:\WINNT\system32;D:\WINNT;D:\
WINNT\System32\Wbem;D:\PROGRA~1\Borland\Delphi6\Bin;D:\PROGRA~1\Borland\Delphi6\
Projects\Bpl;D:\Program Files\Microsoft SQL Server\80\Tools\BINN;D:\Program File
s\BioLink Authenteon Software Appliance\Bin;D:\Program Files\Microsoft Visual St
udio\Common\Tools\WinNT;D:\Program Files\Microsoft Visual Studio\Common\MSDev98\
Bin;D:\Program Files\Microsoft Visual Studio\Common\Tools;D:\Program Files\Micro
soft Visual Studio\VC98\bin;c:\texmf\miktex\bin
DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
DEBUG: PGDATA=d:/msys/BD
DEBUG: PROCESSOR_ARCHITECTURE=x86
DEBUG: PROCESSOR_IDENTIFIER=x86 Family 15 Model 1 Stepping 2, GenuineIn
tel
DEBUG: PROCESSOR_LEVEL=15
DEBUG: PROCESSOR_REVISION=0102
DEBUG: ProgramFiles=D:\Program Files
DEBUG: PROMPT=$P$G
DEBUG: SystemDrive=D:
DEBUG: SystemRoot=D:\WINNT
DEBUG: TEMP=d:\TEMP
DEBUG: TMP=d:\TEMP
DEBUG: USERDOMAIN=PRG-45
DEBUG: USERNAME=Administrator
DEBUG: USERPROFILE=D:\Documents and Settings\Administrator
DEBUG: VS71COMNTOOLS=D:\Program Files\Microsoft Visual Studio .NET 2003
\Common7\Tools\
DEBUG: windir=D:\WINNT
DEBUG: -----------------------------------------
DEBUG: found "D:\msys\1.0\local\pgsql\bin\postgres" using argv[0]
DEBUG: invoking IpcMemoryCreate(size=10567680)
DEBUG: max_safe_fds = 987, usable_fds = 2045, already_open = 3
DEBUG: found "D:\msys\1.0\local\pgsql\bin\postmaster" using argv[0]
DEBUG: Attaching to 014B0000
LOG: database system was shut down at 2004-04-22 18:43:43 FLE Daylight Time
LOG: checkpoint record is at 0/A10FE0
LOG: redo record is at 0/A10FE0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 469; next OID: 17208
LOG: database system is ready
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: waiting on 2 children
LOG: select() failed in statistics buffer: Unknown error
LOG: select() failed in statistics collector: Unknown error
DEBUG: reaping dead processes
DEBUG: waiting on 1 children
LOG: statistics collector process (PID 840) was terminated by signal 1
DEBUG: waiting on 0 children
DEBUG: forked new backend, pid=268 socket=152
DEBUG: Attaching to 014B0000
DEBUG: Attaching to 014B0000
LOG: could not receive data from client: Unknown error
LOG: incomplete startup packet
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: waiting on 2 children
DEBUG: child process (PID 268) exited with exit code 0
DEBUG: waiting on 1 children

So, can any body help me to start Postres?

--
WBR, Andrey Repko mailto:repko(at)sart(dot)must-ipra(dot)com

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Merlin Moncure 2004-04-22 17:51:24 Re: psql can't start
Previous Message Michiel Ephraim 2004-04-20 21:57:14 Re: build annoyences