Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group