postgres 7.4.x na FreeBSD

Thread View: pl.comp.os.freebsd

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Adam Kempa Thu, 20 May 2004 13:26

#57823

Author: Adam Kempa
Date: Thu, 20 May 2004 13:26

26 lines
2168 bytes

Witam

Zainstalowalem Postgresa 7.4.2 na FreeBSD 4.9
Przy duzych obciazeniach bazy wypisuje bledy typu:

ERROR:  permission denied for function varchar
ERROR:  permission denied for function varchar

Po czy nastepuje pad postgresa

LOG:  server process (PID 9787) was terminated by signal 11
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  all server processes terminated; reinitializing
FATAL:  the database system is starting up

Tego typu bledy pojawiaja sie tylko w wersjach 7.4.x. Wersja 7.3.x chodzi duzo stabilniej ale wolniej, nawet o 3 razy, przy niektorych zapytaniach.
Postgres jest skonfigurowany na 50 polaczen, shared_buffers na 1000. W jadrze FreeBSD byly zwiekaszane parametry SEMMNS i SEMMNI.

Czy ktos wie co moze byc przyczyna tych bledow i restartow?


Pozdrawiam
Adam Kempa

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads