Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

 
Reply to this topicStart new topic
> problem z uruchomieniem postgreSQL po instalacji
piotrek_ka
post
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
Go to the top of the page
+Quote Post
Zbłąkany
post
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"
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 Użytkowników czyta ten temat (1 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Aktualny czas: 21.08.2025 - 17:20