psql can't start - Mailing list pgsql-hackers-win32
From | Андрей Репко |
---|---|
Subject | psql can't start |
Date | |
Msg-id | 1849104343.20040422185509@sart.must-ipra.com Whole thread Raw |
List | 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@sart.must-ipra.com
pgsql-hackers-win32 by date: