Hello

I've been installed Postgres 7.4.2 on FreeBSD system and when load
average grow up i've error in postgres like this:
ERROR: permission denied for function varchar
ERROR: permission denied for function varchar

and then postgres crashes.

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

This error occurs on Postgres version 7.4.x .
This error doesn't occur on Postgres version 7.3.x but are much more slower (even 300% slower) then version 7.4.x. and that's why 7.4.x is necessary.

Postgres configuration:
connection 50
shared_buffers 1000

In FreeBSD kernel i've increased SEMMNS and SEMMNI parameters

Can anyone help me, and tell me where is the source of problem: postgres or FreeBSD or both?
Thanks in advance.

Adam Kempa


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Adam Kempa <janus (AT) vtrip (DOT) pl> writes:
I think you've got hardware problems. Specifically, this sounds like it
could be bad RAM in an address range that doesn't get used until the
system gets sufficiently loaded. memtest86 is a widely-recommended test
program for finding bad RAM ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend