How good is FreeBSD for postgres ?

Hi,

I have to work with postgres under freeBSD 3.1-RELEASE and as I'm
completely dummy in FreeBSD I'm wondering if there are problems
with running postgres (6.5).

I installed 6.5 cvs and after playing with kernel (config. shared memory)
I ran regression tests.There were much more tests failures than in
case of my lovely :-) Linux.
Is this a known problem with latest 6.5 cvs or it's my fault ?
I used gcc 2.7.2.1.

float8 .. failed
geometry .. failed
create_function_2 .. failed
triggers .. failed
sanity_check .. failed
misc .. failed
alter_table .. failed
rules .. failed
plpgsql .. failed

I attached below some diffs.

Regards,

Oleg

diff results/float8.out expected/float8.out

190,191d189
< ERROR: floating point exception! The last floating point operation either exc
eeded legal ranges or was a divide by zero
< QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
192a191,192
> QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
> ERROR: pow() result is out of range
198,206c198
< bad| ?column?
< ---+--------------------
< | 1
< |7.39912306090513e-16
< | 0
< | 0
< | 1
< (5 rows)
<
---
> ERROR: exp() result is out of range
223a216
> ERROR: Input '10e-400' is out of range for float8
224a218
> ERROR: Input '-10e-400' is out of range for float8

diff results/create_function_2.out expected/create_function_2.out
41,44d40
< pqReadData() -- backend closed the channel unexpectedly.
< This probably means the backend terminated abnormally
< before or while processing the request.
< We have lost the connection to the backend, so further processing is impossibl
e. Terminating.

diff results/triggers.out expected/triggers.out
39,42c39,285
< pqReadData() -- backend closed the channel unexpectedly.
< This probably means the backend terminated abnormally
< before or while processing the request.
< We have lost the connection to the backend, so further processing is impossibl
e. Terminating.
---
> QUERY: insert into fkeys2 values (30, '3', 2);
..... cutted .....

diff results/sanity_check.out expected/sanity_check.out
13,14d12
< fkeys |t
< fkeys2 |t
29d26
< pkeys |t
34c31
< (26 rows)
---
> (23 rows)

diff results/misc.out expected/misc.out
9,12c9,514
< pqReadData() -- backend closed the channel unexpectedly.
< This probably means the backend terminated abnormally
< before or while processing the request.
< We have lost the connection to the backend, so further processing is impossibl
e. Terminating.
---
> QUERY: UPDATE tmp
....... cutted .....

diff results/plpgsql.out expected/plpgsql.out
875d874
< ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen '/usr/loca
l/pgsql/lib/plpgsql.so' failed. (/usr/local/pgsql/lib/plpgsql.so: Undefined symb
ol "CurrentMemoryContext")
877d875
< ERROR: Can't find function plpgsql_call_handler in file /usr/local/pgsql/lib/
plpgsql.so
879d876
< ERROR: Can't find function plpgsql_call_handler in file /usr/local/pgsql/lib/
plpgsql.so
.... cutted ...

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83