Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: problem z uruchomieniem postgreSQL po instalacji
Forum PHP.pl > Forum > Bazy danych > PostgreSQL
piotrek_ka
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#
Zbłąkany
A pokaż wynik komendy: strace -o postgresql ./pg_ctl -D /boot/home/webserver/databases start
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.