Thread: problem with initdb in windows nt 4.0

problem with initdb in windows nt 4.0

From
"laurentiu c"
Date:
hi everyone,

here is what happens when i try to run initdb after installing
postgresql under nt:

$>initdb –username=Postgres

We are initializing the database system with username Postgres (uid=1005).
This user will own all the files and must also own the server process.

Creating Postgres database system directory d:\usr\local\pgsql\data

Creating Postgres database system directory d:\usr\local\pgsql\data/base

Creating template database in d:\usr\local\pgsql\data/base/template1
ERROR:  mdopen: couldn't open d:\usr\local\pgsql\data/pg_variable: No such file or directory
ERROR:  mdopen: couldn't open d:\usr\local\pgsql\data/pg_variable: No
such file or directory
...............

and the last ERROR lines are repeated endlessly until i manually stop
the process. same thing if i try with another valid username. the data, base, and template1 directories are created and
alsothe first two pg_* files in template1, but apparently it doesn't continue  because it cannot create pg_class. here
iswhat i have in lib and 
bin:

$>ls /usr/local/pgsql/lib

total 2458
 247 -rw-r--r--   1 postgres everyone   505481 Dec 11 23:10 ecpg.dll
   1 -r--r--r--   1 postgres everyone      696 Dec 11 23:10
global1.bki.source
   0 -r--r--r--   1 postgres everyone        0 Dec 11 23:10
global1.description
   8 -rw-r--r--   1 postgres everyone    14522 Dec 11 23:10 libecpg.a
 945 -r--r--r--   1 postgres everyone  1934912 Dec 11 23:10
libpostgres.a
  34 -rw-r--r--   1 postgres everyone    67942 Dec 11 23:10 libpq++.a
  39 -rw-r--r--   1 postgres everyone    77886 Dec 11 23:10 libpq.a
  85 -r--r--r--   1 postgres everyone   172870 Dec 11 23:10
local1_template1.bki.source
  12 -r--r--r--   1 postgres everyone    22583 Dec 11 23:10
local1_template1.description
   2 -r--r--r--   1 postgres everyone     3407 Dec 11 23:10
pg_geqo.sample
   3 -r--r--r--   1 postgres everyone     5192 Dec 11 23:10

pg_hba.conf.sample
 336 -rw-r--r--   1 postgres everyone   686244 Dec 11 23:10 plpgsql.dll
 453 -rw-r--r--   1 postgres everyone   927681 Dec 11 23:10 pq++.dll
 293 -rw-r--r--   1 postgres everyone   598785 Dec 11 23:10 pq.dll


$>ls /usr/local/pgsql/bin

total 3506
   1 -r-xr-xr-x   1 postgres everyone     1065 Dec 11 23:10 cleardbdir
   2 -r-xr-xr-x   1 postgres everyone     2505 Dec 11 23:10 createdb
   3 -r-xr-xr-x   1 postgres everyone     4227 Dec 11 23:10 createlang
   3 -r-xr-xr-x   1 postgres everyone     4658 Dec 11 23:10 createuser
   1 -r-xr-xr-x   1 postgres everyone     1602 Dec 11 23:10 destroydb
   2 -r-xr-xr-x   1 postgres everyone     2951 Dec 11 23:10 destroylang
   2 -r-xr-xr-x   1 postgres everyone     3757 Dec 11 23:10 destroyuser
 338 -r-xr-xr-x   1 postgres everyone   691023 Dec 11 23:10 ecpg.exe
   9 -r-xr-xr-x   1 postgres everyone    17471 Dec 11 23:10 initdb
   2 -r-xr-xr-x   1 postgres everyone     3743 Dec 11 23:10 initlocation

   1 -r-xr-xr-x   1 postgres everyone      259 Dec 11 23:10 ipcclean
 217 -r-xr-xr-x   1 postgres everyone   443730 Dec 11 23:10 pg_dump.exe
   1 -r-xr-xr-x   1 postgres everyone     1803 Dec 11 23:10 pg_dumpall
 155 -r-xr-xr-x   1 postgres everyone   316368 Dec 11 23:10 pg_id.exe
 165 -r-xr-xr-x   1 postgres everyone   336531 Dec 11 23:10
pg_passwd.exe
   2 -r-xr-xr-x   1 postgres everyone     2251 Dec 11 23:10 pg_upgrade
 158 -r-xr-xr-x   1 postgres everyone   321557 Dec 11 23:10
pg_version.exe
2196 -r-xr-xr-x   1 postgres everyone  4496147 Dec 11 23:10 postgres.exe

   1 lrw-r--r--   1 postgres everyone       23 Dec 11 23:10 postmaster
-> postgres.exe
 246 -r-xr-xr-x   1 postgres everyone   503445 Dec 11 23:10 psql.exe
   1 -r-xr-xr-x   1 postgres everyone     1956 Dec 11 23:10 vacuumdb

when i installed postgresql, configure, make, and make install seemed to
execute without any serious incident, i sent their output to .log files
and checked them out with "cat *.log | grep Error" to make sure
everything went fine. i also checked the environment with
check_cygwin_setup.sh, the /etc/passwd file (local) was created.


may i ask three questions:

(1) why can't i run initdb?

(2) i have winnt 4.0 with service pack 6, cygwin-b20.1, and the
postgresql-6.5.3 sources; my gcc -v says version is 2.91.57
(egcs-1.1) : is there anythyng wrong with this configuration?

(3) why initdb --username=jkr, as indicated in the winnt install readme and update post? why not just initdb
--username=postgres;and, finally, 

(4) are both the Cygwin32 IPC package by Ludovic LANGE and
cygwin32_ipc-1.03.tar.gz necessary? it seems to me that i
can start ipc-daemon without the latter package but maybe i'm wrong (or maybe it's already there, from the cygwin
installation,
and i don't know it).

thank you very much for any help you can provide.

laurentiu





------------------------
Sent by Gamespotmail.com
GameSpot -  Where Gamers Go To Know
http://www.gamespot.com