Initdb questions Windows NT port
От | Joost Kraaijeveld |
---|---|
Тема | Initdb questions Windows NT port |
Дата | |
Msg-id | 000001bded38$157e1d60$0200a8c0@panoramix обсуждение исходный текст |
Список | pgsql-hackers |
Hi postgres gurus, I have problems with running initdb. As I mentioned in a precious message I cannot run postgres on a Linux machine at this moment so I have to ask instead of trying myself. And in making the situation worse, for some reason I cannot debug the program if input is redirected to a file (see question 3) but I have to use printf statements instead. I have three main questions. Running "initdb --username=Administrator -d" seems to do: 1. checking the environment setting (goes OK) 2. checking/setting file templates (goes OK) 3. checking user settings (goes OK) 4. creating directories if needed (goes OK) 5. creating template1 database (question 1) 6. creating global classes in two steps (question 2 and 3) 7. do some database filling (goes ????) Question 1. Postgres is run after creating the template1 directory saying: "Creating template database in /usr/local/pgsql/data/base/template1" "Running: postgres -boot -C -F -D/usr/local/pgsql/data -d template1" What should be the effect of running postgres at this point? At my machine it does nothing, other than run (that is , no files are created/changed etc). N.B. /usr/local/pgsql/data/base/template1/PG_VERSION is created, not by running postgres but by running pg_version after that Question 2. Postgres is run again after saying: "Creating global classes in /usr/local/pgsql/data/base" "Running: postgres -boot -C -F -D/usr/local/pgsql/data -d template1" What should be the effect of running postgres at this point? At my machine it does nothing, other than run (that is , no files are created/changed etc). N.B. /usr/local/pgsql/data/PG_VERSION is created, not by running postgres but by running pg_version after that /usr/local/pgsql/data/pg_geqo.sample, created by a simple copy /usr/local/pgsql/data/pg_hba.conf, created by a simple copy Question 3. Postgres is run again after saying: "Adding template1 database to pg_database..." "Running: postgres -boot -C -F -D/usr/local/pgsql/data -d template1 < /tmp/create.8796" (number varies) The program crashes while running. Two empty files are created: pg_class and pg_type. The program crashes because for some unknown reason no valid HeapTuple is created for pg_database. Is there anyone with a briljant idea? What could be the reason? Is it related with the fact that prevoius runs of postgres did't do anything? TIA Joost Kraaijeveld Askesis B.V. Groenewoudseweg 46 6524VB Nijmegen tel: 024-3888063 fax: 024-3608416 web: http:/www.askesis.nl
В списке pgsql-hackers по дате отправления: