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 also
the first two pg_* files in template1, but apparently it
stops because it cannot create pg_class. here is what i have in lib and
bin:
$>ls –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 –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
