![]() |
![]() ![]() |
![]() |
![]()
Post
#1
|
|
Grupa: Zarejestrowani Postów: 10 Pomógł: 0 Dołączył: 13.10.2007 Ostrzeżenie: (0%) ![]() ![]() |
Witam.
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 .... 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# Ten post edytował piotrek_ka 4.06.2008, 20:31:39 |
|
|
![]() ![]()
Post
#2
|
|
![]() Administrator serwera Grupa: Developerzy Postów: 521 Pomógł: 13 Dołączył: 2.04.2004 Skąd: 52°24' N 16°56' E Ostrzeżenie: (0%) ![]() ![]() |
A pokaż wynik komendy: strace -o postgresql ./pg_ctl -D /boot/home/webserver/databases start
-------------------- Środowisko: Gentoo 2008.0 | Apache | PHP5 | PostgreSQL | MySQL | Postfix
Workstation: Gentoo 2008.0 | Firefox Thomas Alva Edison: "Aby coś wynaleźć wystarczy odrobina wyobraźni i sterta złomu ..." Odpowiedź na każde pytanie typu "Jak ...": "Nie da się, to nie PostgreSQL" |
|
|
![]() ![]() |
![]() |
Aktualny czas: 21.08.2025 - 17:20 |