INITDB hanging on Win2000/CygWin (PGSQL 7.2.1). - Mailing list pgsql-bugs

From Josemar Dias Ferreira
Subject INITDB hanging on Win2000/CygWin (PGSQL 7.2.1).
Date
Msg-id 20020619220921.F34364@krakatoa.crie.coppe.ufrj.br
Whole thread Raw
Responses Re: INITDB hanging on Win2000/CygWin (PGSQL 7.2.1).  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Trying to install Postgres version 7.2.1 on Windows2000, using the latest
   Cygwin package, just downloaded. Default packages were installed, in addition
   to the ones mentioned in 'install.hint' file. When running 'initdb' it hangs
   after a few moments.

   Output (with --debug option):

Running with debug mode on.

initdb variables:
  PGDATA=/data2
  datadir=/usr/share/postgresql
  PGPATH=/usr/bin
  MULTIBYTE=SQL_ASCII
  MULTIBYTEID=0
  POSTGRES_SUPERUSERNAME=Administrator
  POSTGRES_BKI=/usr/share/postgresql/postgres.bki
  POSTGRES_DESCR=/usr/share/postgresql/postgres.description
  POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
  PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
The files belonging to this database system will be owned by user "Administrator
".
This user must also own the server process.

Fixing permissions on existing directory /data2... ok
creating directory /data2/base... ok
creating directory /data2/global... ok
creating directory /data2/pg_xlog... ok
creating directory /data2/pg_clog... ok
creating template1 database in /data2/base/1...


   Output for a 'ps' command (in another Cygwin session):

      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
      956       1     956        956  con  500 21:35:56 /usr/bin/bash
     1240     956    1240       1124  con  500 21:36:40 /usr/bin/sh
O     892    1240    1240       1248  con  500 21:36:42 /usr/bin/cat
     1180    1240    1240        360  con  500 21:36:43 /usr/bin/postgres
O    1236    1240    1240       1024  con  500 21:36:43 /usr/bin/sed
I    1200       1    1200       1200  con  500 21:38:20 /usr/bin/bash
     1232       1    1232       1232  con  500 21:41:12 /usr/bin/bash
     1156    1232    1156       1252  con  500 21:41:14 /usr/bin/ps

   output for 'set':

!C:='C:\extra\cygwin\bin'
ALLUSERSPROFILE='C:\Documents and Settings\All Users'
APPDATA='C:\Documents and Settings\Administrator\Application Data'
BASH=/usr/bin/bash
BASH_VERSINFO=([0]="2" [1]="05a" [2]="0" [3]="3" [4]="release" [5]="i686-pc-cygw
in")
BASH_VERSION='2.05a.0(3)-release'
COLUMNS=80
COMMONPROGRAMFILES='C:\Program Files\Common Files'
COMPUTERNAME=PRYDAIN
COMSPEC='C:\WINNT\system32\cmd.exe'
DIRSTACK=()
EUID=500
GROUPS=()
HISTFILE=/home/Administrator/.bash_history
HISTFILESIZE=500
HISTSIZE=500
HOME=/home/Administrator
HOMEDRIVE=C:
HOMEPATH='\'
HOSTNAME=PRYDAIN
HOSTTYPE=i686
IFS=$' \t\n'
LINES=25
LOGONSERVER='\\PRYDAIN'
MACHTYPE=i686-pc-cygwin
MAILCHECK=60
MAKE_MODE=unix
MANPATH=:/usr/ssl/man
NUMBER_OF_PROCESSORS=1
OLDPWD=/usr/bin
OPTERR=1
OPTIND=1
OS=Windows_NT
OS2LIBPATH='C:\WINNT\system32\os2\dll;'
OSTYPE=cygwin
PATH=/usr/local/bin:/usr/bin:/bin:/cygdrive/c/WINNT/system32:/cygdrive/c/WINNT:/
cygdrive/c/WINNT/System32/Wbem:/cygdrive/c/extra/PWRS/shared
PATHEXT='.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
PIPESTATUS=([0]="0")
PPID=1
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER='x86 Family 5 Model 4 Stepping 3, GenuineIntel'
PROCESSOR_LEVEL=5
PROCESSOR_REVISION=0403
PROGRAMFILES='C:\Program Files'
PROMPT='$P$G'
PS1=$'\\[\\033]0;\\w\\007\n\\033[32m\\]\\u@\\h \\[\\033[33m\\w\\033[0m\\]\n$ '
PS2='> '
PS4='+ '
PWD=/home/Administrator
SHELL=/bin/bash
SHELLOPTS=braceexpand:hashall:histexpand:monitor:history:interactive-comments:em
acs
SHLVL=1
SQLANY='C:\SQLAny50\Win32;'
SYSTEMDRIVE=C:
SYSTEMROOT='C:\WINNT'
TEMP=/cygdrive/c/DOCUME~1/ADMINI~1/LOCALS~1/Temp
TERM=cygwin
TMP=/cygdrive/c/DOCUME~1/ADMINI~1/LOCALS~1/Temp
UID=500
USER=Administrator
USERDOMAIN=PRYDAIN
USERNAME=administrator
USERPROFILE='C:\Documents and Settings\Administrator'
WINDIR='C:\WINNT'
_=ps
i=/etc/profile.d/openssl.sh

   Thanks in advance.


   J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: WHERE =NULL malfunction in release 7.2
Next
From: Michael Meskes
Date:
Subject: Re: ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)