problem with initdb in windows nt 4.0 - Mailing list pgsql-ports
From | laurentiu c |
---|---|
Subject | problem with initdb in windows nt 4.0 |
Date | |
Msg-id | EB99D18EF72B3D11780100807CFB3258@laurentiu.c.gamespotmail.com Whole thread Raw |
List | pgsql-ports |
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
pgsql-ports by date: