Re: [HACKERS] How good is FreeBSD for postgres ?

On Mon, 17 May 1999, The Hermit Hacker wrote:

> Date: Mon, 17 May 1999 00:35:00 -0300 (ADT)
> From: The Hermit Hacker <scrappy(at)hub(dot)org>
> To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
> Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] How good is FreeBSD for postgres ?
>
>
> Will look at them right now...

I see you did a job ! Postgres 6.5 cvs works now under FreeBSD 3.1 release
(elf) as on my lovely Linux box ! Almost all regression tests passed
except float8, horology and geometry and rules (could somebody correct
pgsql <-> postgres in .out).

I think it would be useful to apply these fixes to 6.4.2 too.

Regards,
Oleg

PS.

10:05:47[nature]:/usr/home/postgres/cvs/pgsql/src/test/regress$ diff results/flo
at8.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
1

>
> On Mon, 17 May 1999, Oleg Bartunov wrote:
>
> > I read across /usr/ports/databases/postgresql on my FreeBSD 3.1 release
> > elf machine and found a lot of patches to postgres 6.4.2
> > It seems they are didn't applied - I checked 6.5 cvs.
> > What is the status of this port ? Is there is a chance to apply them
> > into 6.5 release ?
> >
> >
> > Regards,
> >
> > Oleg
> >
> > On Sun, 16 May 1999, Tom Lane wrote:
> >
> > > Date: Sun, 16 May 1999 10:03:32 -0400
> > > From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > > To: The Hermit Hacker <scrappy(at)hub(dot)org>
> > > Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-hackers(at)postgreSQL(dot)org
> > > Subject: Re: [HACKERS] How good is FreeBSD for postgres ?
> > >
> > > The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> > > > All known problems...I've always run PostgreSQL under FreeBSD, and have
> > > > yet to notice a problem with a -release version of it...
> > > > The regression tests are "base Linux", and some of the generated error
> > > > messages are different between the systems and/or rounding is slighty
> > > > different...
> > >
> > > The backend crashes that he's showing in some of the tests are not
> > > known problems (to me anyway). Any ideas? Oleg, can you provide
> > > debugger backtraces from the corefiles those crashes generate?
> > >
> > > regards, tom lane
> > >
> >
> > _____________________________________________________________
> > 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
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>

_____________________________________________________________
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