Zaisntalowałem postgreSQL 7.3.4 (ostatnia wersja dostępna na moją platforme - BeOS), wywołałem skrypt initdb. Czy muszę coś jeszcze zrobić aby baza działała? U mnie nie chce działać i takie lawinowe błędy się pokazują:
Kod
baron@unknown:~/config/bin# ./initdb
The files belonging to this database system will be owned by user "baron".
This user must also own the server process.
creating directory /boot/home/webserver/databases... ok
creating directory /boot/home/webserver/databases/base... ok
creating directory /boot/home/webserver/databases/global... ok
creating directory /boot/home/webserver/databases/pg_xlog... ok
creating directory /boot/home/webserver/databases/pg_clog... ok
creating template1 database in /boot/home/webserver/databases/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
./postmaster -D /boot/home/webserver/databases
or
./pg_ctl -D /boot/home/webserver/databases -l logfile start
baron@unknown:~/config/bin# ./pg_ctl -D /boot/home/webserver/databases start
postmaster successfully started
baron@unknown:~/config/bin# DEBUG: database system was shut down at 2008-06-04 17:10:48 GMT
DEBUG: checkpoint record is at 0/109664
DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
PGSTAT: select(2): Operation now in progress
DEBUG: server process (pid 8795) exited with exit code 1
DEBUG: terminating any other active server processes
DEBUG: statistics collector process (pid 8793) exited with exit code 1
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
PGSTAT: select(2): Operation now in progress
DEBUG: database system was interrupted at 2008-06-04 17:10:59 GMT
DEBUG: checkpoint record is at 0/109664
DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/1096A4
DEBUG: redo is not required
DEBUG: statistics collector process (pid 8796) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8799) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8801) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8803) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8805) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8807) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8809) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8811) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8813) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8815) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8817) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8819) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8821) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8823) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8825) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8827) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8829) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8833) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8835) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8837) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8839) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8841) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8843) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8845) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8847) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8849) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8851) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8853) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8855) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8857) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: database system is ready
DEBUG: statistics collector process (pid 8859) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: server process (pid 8862) exited with exit code 1
DEBUG: terminating any other active server processes
DEBUG: statistics collector process (pid 8861) exited with exit code 1
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8863) exited with exit code 1
DEBUG: database system was interrupted at 2008-06-04 17:11:02 GMT
DEBUG: checkpoint record is at 0/1096A4
DEBUG: redo record is at 0/1096A4; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/1096E4
DEBUG: redo is not required
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8866) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8868) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8870) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8872) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8874) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8876) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8878) exited with exit code 1
PGSTAT: select(2): Operation now in progress
....
The files belonging to this database system will be owned by user "baron".
This user must also own the server process.
creating directory /boot/home/webserver/databases... ok
creating directory /boot/home/webserver/databases/base... ok
creating directory /boot/home/webserver/databases/global... ok
creating directory /boot/home/webserver/databases/pg_xlog... ok
creating directory /boot/home/webserver/databases/pg_clog... ok
creating template1 database in /boot/home/webserver/databases/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
./postmaster -D /boot/home/webserver/databases
or
./pg_ctl -D /boot/home/webserver/databases -l logfile start
baron@unknown:~/config/bin# ./pg_ctl -D /boot/home/webserver/databases start
postmaster successfully started
baron@unknown:~/config/bin# DEBUG: database system was shut down at 2008-06-04 17:10:48 GMT
DEBUG: checkpoint record is at 0/109664
DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
PGSTAT: select(2): Operation now in progress
DEBUG: server process (pid 8795) exited with exit code 1
DEBUG: terminating any other active server processes
DEBUG: statistics collector process (pid 8793) exited with exit code 1
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
PGSTAT: select(2): Operation now in progress
DEBUG: database system was interrupted at 2008-06-04 17:10:59 GMT
DEBUG: checkpoint record is at 0/109664
DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/1096A4
DEBUG: redo is not required
DEBUG: statistics collector process (pid 8796) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8799) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8801) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8803) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8805) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8807) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8809) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8811) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8813) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8815) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8817) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8819) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8821) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8823) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8825) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8827) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8829) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8833) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8835) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8837) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8839) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8841) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8843) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8845) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8847) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8849) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8851) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8853) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8855) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8857) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: database system is ready
DEBUG: statistics collector process (pid 8859) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: server process (pid 8862) exited with exit code 1
DEBUG: terminating any other active server processes
DEBUG: statistics collector process (pid 8861) exited with exit code 1
DEBUG: all server processes terminated; reinitializing shared memory and semaphores
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8863) exited with exit code 1
DEBUG: database system was interrupted at 2008-06-04 17:11:02 GMT
DEBUG: checkpoint record is at 0/1096A4
DEBUG: redo record is at 0/1096A4; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/1096E4
DEBUG: redo is not required
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8866) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8868) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8870) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8872) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8874) exited with exit code 1
PGSTAT: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8876) exited with exit code 1
PGSTATBUFF: select(2): Operation now in progress
DEBUG: statistics collector process (pid 8878) exited with exit code 1
PGSTAT: select(2): Operation now in progress
....
i tak aż do zabicia procesu. O co tu może chodzić?
------------------------------------
Kod
baron@unknown:~/config/bin# ./postgres -D /boot/home/webserver/databases
DEBUG: database system was shut down at 2008-06-04 21:27:19 GMT
DEBUG: checkpoint record is at 0/10A450
DEBUG: redo record is at 0/10A450; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
FATAL 1: Database "baron" does not exist in the system catalog.
DEBUG: shutting down
DEBUG: database system is shut down
baron@unknown:~/config/bin#
DEBUG: database system was shut down at 2008-06-04 21:27:19 GMT
DEBUG: checkpoint record is at 0/10A450
DEBUG: redo record is at 0/10A450; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
FATAL 1: Database "baron" does not exist in the system catalog.
DEBUG: shutting down
DEBUG: database system is shut down
baron@unknown:~/config/bin#