Обсуждение: initdb failure
Hi!
I received the following error after attempting to initialize the database
within Cygwin.
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /user/local/pgsql/data/ba
initdb: failed
initdb: removing data directory "/user/local/pgsql/data"
Any help is appreciated. Here is my configuration dump:
$ cygcheck -s
Cygwin Configuration Diagnostics
Current System Time: Fri Aug 06 10:48:18 2004
Windows XP Home Edition Ver 5.1 Build 2600
Path: C:\cygwin\usr\local\bin
C:\cygwin\bin
C:\cygwin\bin
C:\cygwin\usr\X11R6\bin
c:\WINDOWS\system32
c:\WINDOWS
c:\WINDOWS\System32\Wbem
c:\Program Files\PuTTY
c:\java\apache-ant-1.6.1\bin
c:\java\j2sdk1.4.2_04
.\
Output from C:\cygwin\bin\id.exe (nontsec)
UID: 1006(John) GID: 513(None)
513(None)
Output from C:\cygwin\bin\id.exe (ntsec)
UID: 1006(John) GID: 513(None)
0(root) 513(None)
544(Administrators) 545(Users)
SysDir: C:\WINDOWS\System32
WinDir: C:\WINDOWS
HOME = `C:\cygwin\home\John'
MAKE_MODE = `unix'
PWD = `/home/John'
USER = `John'
Use `-r' to scan registry
c: hd NTFS 28576Mb 28% CP CS UN PA FC
d: hd FAT 62Mb 67% CP UN FLASH DISK
e: cd N/A N/A
C:\cygwin / system binmode
C:\cygwin/bin /usr/bin system binmode
C:\cygwin/lib /usr/lib system binmode
. /cygdrive system binmode,cygdrive
Found: C:\cygwin\bin\awk.exe
Found: C:\cygwin\bin\bash.exe
Found: C:\cygwin\bin\cat.exe
Found: C:\cygwin\bin\cp.exe
Not Found: cpp (good!)
Found: C:\cygwin\bin\find.exe
Not Found: gcc
Not Found: gdb
Found: C:\cygwin\bin\grep.exe
Not Found: ld
Found: C:\cygwin\bin\ls.exe
Not Found: make
Found: C:\cygwin\bin\mv.exe
Found: C:\cygwin\bin\rm.exe
Found: C:\cygwin\bin\sed.exe
Found: C:\cygwin\bin\sh.exe
Found: C:\cygwin\bin\tar.exe
61k 2003/08/09 C:\cygwin\bin\cygbz2-1.dll
7k 2003/10/19 C:\cygwin\bin\cygcrypt-0.dll
841k 2004/03/17 C:\cygwin\bin\cygcrypto-0.9.7.dll
45k 2001/04/25 C:\cygwin\bin\cygform5.dll
35k 2002/01/09 C:\cygwin\bin\cygform6.dll
48k 2003/08/09 C:\cygwin\bin\cygform7.dll
28k 2003/07/20 C:\cygwin\bin\cyggdbm-3.dll
30k 2003/08/11 C:\cygwin\bin\cyggdbm-4.dll
19k 2003/03/22 C:\cygwin\bin\cyggdbm.dll
15k 2003/07/20 C:\cygwin\bin\cyggdbm_compat-3.dll
15k 2003/08/11 C:\cygwin\bin\cyggdbm_compat-4.dll
107k 2004/07/06 C:\cygwin\bin\cyggettextlib-0-14-1.dll
17k 2004/07/06 C:\cygwin\bin\cyggettextpo-0.dll
190k 2004/07/06 C:\cygwin\bin\cyggettextsrc-0-14-1.dll
17k 2001/06/28 C:\cygwin\bin\cyghistory4.dll
29k 2003/08/10 C:\cygwin\bin\cyghistory5.dll
991k 2004/07/06 C:\cygwin\bin\cygiconv-2.dll
22k 2001/12/13 C:\cygwin\bin\cygintl-1.dll
37k 2003/08/10 C:\cygwin\bin\cygintl-2.dll
54k 2004/07/06 C:\cygwin\bin\cygintl-3.dll
26k 2001/04/25 C:\cygwin\bin\cygmenu5.dll
20k 2002/01/09 C:\cygwin\bin\cygmenu6.dll
29k 2003/08/09 C:\cygwin\bin\cygmenu7.dll
156k 2001/04/25 C:\cygwin\bin\cygncurses++5.dll
175k 2002/01/09 C:\cygwin\bin\cygncurses++6.dll
226k 2001/04/25 C:\cygwin\bin\cygncurses5.dll
202k 2002/01/09 C:\cygwin\bin\cygncurses6.dll
224k 2003/08/09 C:\cygwin\bin\cygncurses7.dll
15k 2001/04/25 C:\cygwin\bin\cygpanel5.dll
12k 2002/01/09 C:\cygwin\bin\cygpanel6.dll
19k 2003/08/09 C:\cygwin\bin\cygpanel7.dll
62k 2003/12/11 C:\cygwin\bin\cygpcre-0.dll
63k 2003/04/11 C:\cygwin\bin\cygpcre.dll
9k 2003/12/11 C:\cygwin\bin\cygpcreposix-0.dll
61k 2003/04/11 C:\cygwin\bin\cygpcreposix.dll
108k 2001/06/28 C:\cygwin\bin\cygreadline4.dll
148k 2003/08/10 C:\cygwin\bin\cygreadline5.dll
171k 2004/03/17 C:\cygwin\bin\cygssl-0.9.7.dll
61k 2003/12/04 C:\cygwin\bin\cygz.dll
1126k 2004/05/26 C:\cygwin\bin\cygwin1.dll
Cygwin DLL version info:
DLL version: 1.5.10
DLL epoch: 19
DLL bad signal mask: 19005
DLL old termios: 5
DLL malloc env: 28
API major: 0
API minor: 116
Shared data: 4
DLL identifier: cygwin1
Mount registry: 2
Cygnus registry name: Cygnus Solutions
Cygwin registry name: Cygwin
Program options name: Program Options
Cygwin mount registry name: mounts v2
Cygdrive flags: cygdrive flags
Cygdrive prefix: cygdrive prefix
Cygdrive default prefix:
Build date: Tue May 25 22:07:00 EDT 2004
CVS tag: cr-0x5e6
Shared id: cygwin1S4
Cygwin Package Information
Package Version
_update-info-dir 00227-1
ash 20040127-1
base-files 2.6-1
base-passwd 1.1-1
bash 2.05b-16
bzip2 1.0.2-5
crypt 1.1-1
cygrunsrv 1.0-1
cygwin 1.5.10-3
diffutils 2.8.7-1
editrights 1.01-1
fileutils 4.1-2
findutils 4.1.7-4
gawk 3.1.4-3
gdbm 1.8.3-7
grep 2.5-1
groff 1.18.1-2
gzip 1.3.5-1
less 381-1
libbz2_1 1.0.2-5
libgdbm 1.8.0-5
libgdbm-devel 1.8.3-7
libgdbm3 1.8.3-3
libgdbm4 1.8.3-7
libgettextpo0 0.14.1-1
libiconv2 1.9.2-1
libintl1 0.10.40-1
libintl2 0.12.1-3
libintl3 0.14.1-1
libncurses5 5.2-1
libncurses6 5.2-8
libncurses7 5.3-4
libpcre 4.1-1
libpcre0 4.5-1
libreadline4 4.1-2
libreadline5 4.3-5
login 1.9-7
man 1.5k-3
mktemp 1.5-3
ncurses 5.3-4
openssl 0.9.7d-1
postgresql 7.4.3-1
readline 4.3-5
sed 4.0.9-2
sh-utils 2.0.15-4
tar 1.13.25-5
termcap 20021106-2
terminfo 5.3_20030726-1
texinfo 4.2-4
textutils 2.0.21-1
which 1.5-2
zlib 1.2.1-1
Use -h to see help about each section
Thanks!
John Wilcher
Hello, That would be because cygserver is not running or not included in your path. If you search the list a few folks have posted scripts which can be used on XP Home to start the db. Mike On Fri, 2004-08-06 at 09:59, John Wilcher wrote: > Hi! > > I received the following error after attempting to initialize the database > within Cygwin. > > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /user/local/pgsql/data/ba > > initdb: failed > initdb: removing data directory "/user/local/pgsql/data" > > Any help is appreciated. Here is my configuration dump: > > $ cygcheck -s > > Cygwin Configuration Diagnostics > Current System Time: Fri Aug 06 10:48:18 2004 > > Windows XP Home Edition Ver 5.1 Build 2600 > > Path: C:\cygwin\usr\local\bin > C:\cygwin\bin > C:\cygwin\bin > C:\cygwin\usr\X11R6\bin > c:\WINDOWS\system32 > c:\WINDOWS > c:\WINDOWS\System32\Wbem > c:\Program Files\PuTTY > c:\java\apache-ant-1.6.1\bin > c:\java\j2sdk1.4.2_04 > .\ > > Output from C:\cygwin\bin\id.exe (nontsec) > UID: 1006(John) GID: 513(None) > 513(None) > > Output from C:\cygwin\bin\id.exe (ntsec) > UID: 1006(John) GID: 513(None) > 0(root) 513(None) > 544(Administrators) 545(Users) > > SysDir: C:\WINDOWS\System32 > WinDir: C:\WINDOWS > > HOME = `C:\cygwin\home\John' > MAKE_MODE = `unix' > PWD = `/home/John' > USER = `John' > > Use `-r' to scan registry > > c: hd NTFS 28576Mb 28% CP CS UN PA FC > d: hd FAT 62Mb 67% CP UN FLASH DISK > e: cd N/A N/A > > C:\cygwin / system binmode > C:\cygwin/bin /usr/bin system binmode > C:\cygwin/lib /usr/lib system binmode > . /cygdrive system binmode,cygdrive > > Found: C:\cygwin\bin\awk.exe > Found: C:\cygwin\bin\bash.exe > Found: C:\cygwin\bin\cat.exe > Found: C:\cygwin\bin\cp.exe > Not Found: cpp (good!) > Found: C:\cygwin\bin\find.exe > Not Found: gcc > Not Found: gdb > Found: C:\cygwin\bin\grep.exe > Not Found: ld > Found: C:\cygwin\bin\ls.exe > Not Found: make > Found: C:\cygwin\bin\mv.exe > Found: C:\cygwin\bin\rm.exe > Found: C:\cygwin\bin\sed.exe > Found: C:\cygwin\bin\sh.exe > Found: C:\cygwin\bin\tar.exe > > 61k 2003/08/09 C:\cygwin\bin\cygbz2-1.dll > 7k 2003/10/19 C:\cygwin\bin\cygcrypt-0.dll > 841k 2004/03/17 C:\cygwin\bin\cygcrypto-0.9.7.dll > 45k 2001/04/25 C:\cygwin\bin\cygform5.dll > 35k 2002/01/09 C:\cygwin\bin\cygform6.dll > 48k 2003/08/09 C:\cygwin\bin\cygform7.dll > 28k 2003/07/20 C:\cygwin\bin\cyggdbm-3.dll > 30k 2003/08/11 C:\cygwin\bin\cyggdbm-4.dll > 19k 2003/03/22 C:\cygwin\bin\cyggdbm.dll > 15k 2003/07/20 C:\cygwin\bin\cyggdbm_compat-3.dll > 15k 2003/08/11 C:\cygwin\bin\cyggdbm_compat-4.dll > 107k 2004/07/06 C:\cygwin\bin\cyggettextlib-0-14-1.dll > 17k 2004/07/06 C:\cygwin\bin\cyggettextpo-0.dll > 190k 2004/07/06 C:\cygwin\bin\cyggettextsrc-0-14-1.dll > 17k 2001/06/28 C:\cygwin\bin\cyghistory4.dll > 29k 2003/08/10 C:\cygwin\bin\cyghistory5.dll > 991k 2004/07/06 C:\cygwin\bin\cygiconv-2.dll > 22k 2001/12/13 C:\cygwin\bin\cygintl-1.dll > 37k 2003/08/10 C:\cygwin\bin\cygintl-2.dll > 54k 2004/07/06 C:\cygwin\bin\cygintl-3.dll > 26k 2001/04/25 C:\cygwin\bin\cygmenu5.dll > 20k 2002/01/09 C:\cygwin\bin\cygmenu6.dll > 29k 2003/08/09 C:\cygwin\bin\cygmenu7.dll > 156k 2001/04/25 C:\cygwin\bin\cygncurses++5.dll > 175k 2002/01/09 C:\cygwin\bin\cygncurses++6.dll > 226k 2001/04/25 C:\cygwin\bin\cygncurses5.dll > 202k 2002/01/09 C:\cygwin\bin\cygncurses6.dll > 224k 2003/08/09 C:\cygwin\bin\cygncurses7.dll > 15k 2001/04/25 C:\cygwin\bin\cygpanel5.dll > 12k 2002/01/09 C:\cygwin\bin\cygpanel6.dll > 19k 2003/08/09 C:\cygwin\bin\cygpanel7.dll > 62k 2003/12/11 C:\cygwin\bin\cygpcre-0.dll > 63k 2003/04/11 C:\cygwin\bin\cygpcre.dll > 9k 2003/12/11 C:\cygwin\bin\cygpcreposix-0.dll > 61k 2003/04/11 C:\cygwin\bin\cygpcreposix.dll > 108k 2001/06/28 C:\cygwin\bin\cygreadline4.dll > 148k 2003/08/10 C:\cygwin\bin\cygreadline5.dll > 171k 2004/03/17 C:\cygwin\bin\cygssl-0.9.7.dll > 61k 2003/12/04 C:\cygwin\bin\cygz.dll > 1126k 2004/05/26 C:\cygwin\bin\cygwin1.dll > Cygwin DLL version info: > DLL version: 1.5.10 > DLL epoch: 19 > DLL bad signal mask: 19005 > DLL old termios: 5 > DLL malloc env: 28 > API major: 0 > API minor: 116 > Shared data: 4 > DLL identifier: cygwin1 > Mount registry: 2 > Cygnus registry name: Cygnus Solutions > Cygwin registry name: Cygwin > Program options name: Program Options > Cygwin mount registry name: mounts v2 > Cygdrive flags: cygdrive flags > Cygdrive prefix: cygdrive prefix > Cygdrive default prefix: > Build date: Tue May 25 22:07:00 EDT 2004 > CVS tag: cr-0x5e6 > Shared id: cygwin1S4 > > > Cygwin Package Information > Package Version > _update-info-dir 00227-1 > ash 20040127-1 > base-files 2.6-1 > base-passwd 1.1-1 > bash 2.05b-16 > bzip2 1.0.2-5 > crypt 1.1-1 > cygrunsrv 1.0-1 > cygwin 1.5.10-3 > diffutils 2.8.7-1 > editrights 1.01-1 > fileutils 4.1-2 > findutils 4.1.7-4 > gawk 3.1.4-3 > gdbm 1.8.3-7 > grep 2.5-1 > groff 1.18.1-2 > gzip 1.3.5-1 > less 381-1 > libbz2_1 1.0.2-5 > libgdbm 1.8.0-5 > libgdbm-devel 1.8.3-7 > libgdbm3 1.8.3-3 > libgdbm4 1.8.3-7 > libgettextpo0 0.14.1-1 > libiconv2 1.9.2-1 > libintl1 0.10.40-1 > libintl2 0.12.1-3 > libintl3 0.14.1-1 > libncurses5 5.2-1 > libncurses6 5.2-8 > libncurses7 5.3-4 > libpcre 4.1-1 > libpcre0 4.5-1 > libreadline4 4.1-2 > libreadline5 4.3-5 > login 1.9-7 > man 1.5k-3 > mktemp 1.5-3 > ncurses 5.3-4 > openssl 0.9.7d-1 > postgresql 7.4.3-1 > readline 4.3-5 > sed 4.0.9-2 > sh-utils 2.0.15-4 > tar 1.13.25-5 > termcap 20021106-2 > terminfo 5.3_20030726-1 > texinfo 4.2-4 > textutils 2.0.21-1 > which 1.5-2 > zlib 1.2.1-1 > Use -h to see help about each section > > Thanks! > > John Wilcher > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings