PostgreSQL 8.0.0 Release Candidate 3

As was anticipated, time between Release Candidate 2 and 3 was nice and
short, with more changes being made now to Documentation vs Code.

A current list of *known* supported platforms can be found at:

http://developer.postgresql.org/supported-platforms.html

We're always looking to improve that list, so we encourage anyone that is
running a platform not listed to please report on any success or failures
with Release Candidate 3.

Baring *any* coding changes (documentation != code) over the next week or
so, we *hope* that this will the final Release Candidate before Full
Release, with that being aimed for the 15th (or earlier).

As always, this release is available on all mirrors, as listed at:

http://www.postgresql.org/mirrors-ftp.html

For those using Bittorrent, David Fetter has updated the .torrents, which can
be downloaded from:

http://bt.postgresql.org

Please report any bug reports with this Release Candidate to:

pgsql-bugs(at)postgresql(dot)org

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Does this release incorporate a change to the bgwriter or was it
determined to leave it as-is until 8.1?

Regards,
Jeff Davis

On Sun, 2005-01-02 at 10:56 -0400, Marc G. Fournier wrote:
> As was anticipated, time between Release Candidate 2 and 3 was nice and
> short, with more changes being made now to Documentation vs Code.
>
> A current list of *known* supported platforms can be found at:
>
> http://developer.postgresql.org/supported-platforms.html
>
> We're always looking to improve that list, so we encourage anyone that is
> running a platform not listed to please report on any success or failures
> with Release Candidate 3.
>
> Baring *any* coding changes (documentation != code) over the next week or
> so, we *hope* that this will the final Release Candidate before Full
> Release, with that being aimed for the 15th (or earlier).
>
> As always, this release is available on all mirrors, as listed at:
>
> http://www.postgresql.org/mirrors-ftp.html
>
> For those using Bittorrent, David Fetter has updated the .torrents, which can
> be downloaded from:
>
> http://bt.postgresql.org
>
> Please report any bug reports with this Release Candidate to:
>
> pgsql-bugs(at)postgresql(dot)org
>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

On Sun, 2005-01-02 at 09:56, Marc G. Fournier wrote:
>
> As was anticipated, time between Release Candidate 2 and 3 was nice and
> short, with more changes being made now to Documentation vs Code.
>
> A current list of *known* supported platforms can be found at:
>
> http://developer.postgresql.org/supported-platforms.html
>

Are you sure this list is complete? I don't see the ps2, xbox, or
gamecube listed under supported platforms :-)

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

I also don't see MIPSEL and ARM on the list, both running debian sarge (in the build farm).

Jim

---------- Original Message -----------
From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Sent: 03 Jan 2005 08:35:19 -0500
Subject: Re: [HACKERS] [ANNOUNCE] PostgreSQL 8.0.0 Release Candidate 3

> On Sun, 2005-01-02 at 09:56, Marc G. Fournier wrote:
> >
> > As was anticipated, time between Release Candidate 2 and 3 was nice and
> > short, with more changes being made now to Documentation vs Code.
> >
> > A current list of *known* supported platforms can be found at:
> >
> > http://developer.postgresql.org/supported-platforms.html
> >
>
> Are you sure this list is complete? I don't see the ps2, xbox, or
> gamecube listed under supported platforms :-)
>
> Robert Treat
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
------- End of Original Message -------

Jeff Davis wrote:
> Does this release incorporate a change to the bgwriter or was it
> determined to leave it as-is until 8.1?

There are no bgwriter changes in RC3. We don't know yet if they will be
in 8.0 final.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Jim Buttafuoco wrote:
> I also don't see MIPSEL and ARM on the list, both running debian
> sarge (in the build farm).

The mips entry is actually a mipsel, but uname identifies them the same.
I don't see any arm machine in the build farm.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

I have both a MIPS and MIPSEL in the buildfarm. i have also reported a good build on a arm (Debian/Sarge/Netwinder)
(not yet in the build farm)

---------- Original Message -----------
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: jim(at)contactbda(dot)com
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Sent: Mon, 3 Jan 2005 22:56:22 +0100
Subject: Re: [HACKERS] [ANNOUNCE] PostgreSQL 8.0.0 Release Candidate 3

> Jim Buttafuoco wrote:
> > I also don't see MIPSEL and ARM on the list, both running debian
> > sarge (in the build farm).
>
> The mips entry is actually a mipsel, but uname identifies them the same.
> I don't see any arm machine in the build farm.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
------- End of Original Message -------

Am Dienstag, 4. Januar 2005 14:53 schrieb Jim Buttafuoco:
> I have both a MIPS and MIPSEL in the buildfarm. i have also reported a
> good build on a arm (Debian/Sarge/Netwinder) (not yet in the build farm)

Well, a build with regression test failures is not "good", in particular when
it is a regression from previously behavior.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

what failure. both my MIPS and MIPSEL system are reporting OK on the builds. The ARM failed only the "point" test.
It looks like a rounding error (ARM doesn't have a build in fp unit)

---------- Original Message -----------
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: jim(at)contactbda(dot)com
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Sent: Tue, 4 Jan 2005 15:07:38 +0100
Subject: Re: [HACKERS] [ANNOUNCE] PostgreSQL 8.0.0 Release Candidate 3

> Am Dienstag, 4. Januar 2005 14:53 schrieb Jim Buttafuoco:
> > I have both a MIPS and MIPSEL in the buildfarm. i have also reported a
> > good build on a arm (Debian/Sarge/Netwinder) (not yet in the build farm)
>
> Well, a build with regression test failures is not "good", in particular when
> it is a regression from previously behavior.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
------- End of Original Message -------

RC3 on Microsoft VirtualPC with Debian Testing passes all tests.

Marc G. Fournier wrote:
> We're always looking to improve that list, so we encourage anyone that
> is running a platform not listed to please report on any success or
> failures with Release Candidate 3.

Running a fresh install of Debian/Testing on Microsoft VirtualPC works
fine. I'm not sure if this counts as a separate platform or not, since
all it really says is that VirtualPC emulates a PC well enough. It's a
pretty nice way of running Linux servers on sales guy's windows laptop.

$ make check
[...]
======================
All 96 tests passed.
======================

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marc G. Fournier wrote:

| A current list of *known* supported platforms can be found at:
|
| http://developer.postgresql.org/supported-platforms.html
|
| We're always looking to improve that list, so we encourage anyone that
| is running a platform not listed to please report on any success or
| failures with Release Candidate 3.

I notice that Ubuntu is not yet on this list. I can confirm that
PostgreSQL 7.4.5 is supported under Ubuntu 4.10 (warty) on all platforms
(x86, amd64 and ppc) and that PostgreSQL 7.4.6 is supported under Ubuntu
5.4 (hoary) on all platforms. Version freeze for hoary is today, so that
version is fixed and the 8 series won't be officially supported until
the following release (October 2005), although installing the Debian
packages should work just fine.

- --
Stuart Bishop <stuart(dot)bishop(at)canonical(dot)com> http://www.canonical.com/
Canonical Ltd. http://www.ubuntulinux.com/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFB257ZAfqZj7rGN0oRAkvrAJ92nz1G2NkKqTCQLxoNK2SR2TT/OACffHBi
akfLOnKYf2wObq2qx7GEwME=
=885J
-----END PGP SIGNATURE-----

Welcome to the New Year all, and the final days of testing for 8.0.0.

This will hopefully be our final Release Candidate, with a Full
Release happening late next week. There are several Windows related
fixes in this Release Candidate, with a full list of changes viewable
in the Changelog available on the FTP server.

A current list of *known* supported platforms can be found at:

http://developer.postgresql.org/supported-platforms.html

We're always looking to improve that list, so we encourage anyone that is
running a platform not listed to please report on any success or failures
with Release Candidate 4.

Baring *any* coding changes (documentation != code) over the next week or so,
we *hope* that this will the final Release Candidate before Full Release,
with that being aimed for the 15th (or earlier).

As always, this release is available on all mirrors, as listed at:

http://wwwmaster.postgresql.org/download/mirrors-ftp

For those using Bittorrent, David Fetter hasn't had a chance to update the
.torrents, but should be available later today from:

http://bt.postgresql.org

Please report any bug reports with this Release Candidate to:

pgsql-bugs(at)postgresql(dot)org

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

On Fri, Jan 07, 2005 at 12:04:00PM -0400, Marc G. Fournier wrote:
>
> Welcome to the New Year all, and the final days of testing for 8.0.0.
>
> This will hopefully be our final Release Candidate, with a Full
> Release happening late next week. There are several Windows related
> fixes in this Release Candidate, with a full list of changes viewable
> in the Changelog available on the FTP server.
>
> A current list of *known* supported platforms can be found at:
>
> http://developer.postgresql.org/supported-platforms.html
>
> We're always looking to improve that list, so we encourage anyone that is
> running a platform not listed to please report on any success or failures
> with Release Candidate 4.
>
> Baring *any* coding changes (documentation != code) over the next week or
> so, we *hope* that this will the final Release Candidate before Full
> Release, with that being aimed for the 15th (or earlier).
>
> As always, this release is available on all mirrors, as listed at:
>
> http://wwwmaster.postgresql.org/download/mirrors-ftp
>
> For those using Bittorrent, David Fetter hasn't had a chance to update the
> .torrents, but should be available later today from:
>
> http://bt.postgresql.org

They're up. :)

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marc G. Fournier wrote:

| A current list of *known* supported platforms can be found at:
|
| http://developer.postgresql.org/supported-platforms.html
|
| We're always looking to improve that list, so we encourage anyone that
| is running a platform not listed to please report on any success or
| failures with Release Candidate 4.

I notice that Ubuntu is not yet on this list. I can confirm that
PostgreSQL 7.4.5 is supported under Ubuntu 4.10 (warty) on all platforms
(x86, amd64 and ppc) and that PostgreSQL 7.4.6 is supported under Ubuntu
5.4 (hoary) on all platforms. We are now in version freeze for hoary, so
that version is fixed and the 8 series won't be officially supported
until the following release (October 2005), although installing the
Debian packages should work just fine.

- --
Stuart Bishop <stuart(dot)bishop(at)canonical(dot)com> http://www.canonical.com/
Canonical Ltd. http://www.ubuntulinux.com/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFB30xFAfqZj7rGN0oRAiBDAKCNLmuZINaYvMiEone+59JLd+kr0wCgmUcK
usoKlMJe7kH8Jv+xp+oeUiU=
=7XV8
-----END PGP SIGNATURE-----

On Fri, 2005-01-07 at 17:04, Marc G. Fournier wrote:

> [...]
> A current list of *known* supported platforms can be found at:
>
> http://developer.postgresql.org/supported-platforms.html
>
> We're always looking to improve that list, so we encourage anyone that is
> running a platform not listed to please report on any success or failures
> with Release Candidate 4.
> [...]

Hi,

I've tested RC4 on Linux on the PlayStation 2 again
(compare
http://archives.postgresql.org/pgsql-hackers/2004-08/msg01339.php).

With --disable-spinlocks everything but the two floating point tests
succeeds (regression output and diffs attached).

The Playstation 2 hardware manuals confirm that the FPU has
no support for NaN and +/-Inf. That explains the regression diffs.
(EE Core User's Manual Version 5, p. 153)

In summary one might conclude that PostgreSQL 8 works on Linux on the
Playstation 2 as far as the hardware supports it.

Kind regards,
Chris.

Chris Mair wrote:
> The Playstation 2 hardware manuals confirm that the FPU has
> no support for NaN and +/-Inf. That explains the regression diffs.
> (EE Core User's Manual Version 5, p. 153)

Well, it does not readily explain that 'infinity' is rejected as invalid
input syntax. You should get an overflow or some large value, at
least.

The relevant code is in src/backend/utils/adt/float.c.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Stuart Bishop <stuart(at)stuartbishop(dot)net> writes:
> Marc G. Fournier wrote:
> | A current list of *known* supported platforms can be found at:
> | http://developer.postgresql.org/supported-platforms.html

> I notice that Ubuntu is not yet on this list. I can confirm that
> PostgreSQL 7.4.5 is supported under Ubuntu 4.10 (warty) on all platforms
> (x86, amd64 and ppc) and that PostgreSQL 7.4.6 is supported under Ubuntu
> 5.4 (hoary) on all platforms. We are now in version freeze for hoary, so
> that version is fixed and the 8 series won't be officially supported
> until the following release (October 2005), although installing the
> Debian packages should work just fine.

You seem to be under a misconception about the purpose of that list.
It has nothing to do with what Postgres releases are packaged by
various distributions. Entries on the list mean that someone has
verified that the *source code* distribution builds per instructions
and passes regression tests on that platform.

If you are trying to say that you personally have verified that for
Ubuntu, you didn't phrase it clearly.

regards, tom lane

On Sun, 2005-01-09 at 17:45, Peter Eisentraut wrote:

> Well, it does not readily explain that 'infinity' is rejected as invalid
> input syntax. You should get an overflow or some large value, at
> least.
>
> The relevant code is in src/backend/utils/adt/float.c.

You're right.
I had a look at the code.
It seems strtod() is to blame.

This sample program

#include <stdio.h>
#include <stdlib.h>
#include <errno.h>
int main()
{
char *endptr;
double val;
char *num = "Infinity";
errno = 0;
val = strtod(num, &endptr);
printf("input string is '%s'\n", num);
printf("strtod returned val = %lf\n", val);
printf("errno = %d\n", errno);
printf("endptr points to '%s'\n", endptr);
}

on the PlayStation 2 returns:

input string is 'Infinity'
strtod returned val = inf
errno = 0
endptr points to 'inity'

float.c's conversion routine cannot deal with a strtod that just eats
the 'Inf' part of 'Infinity', so the remaining 'inity' is causing the
syntax error (from line 522 in "float.c").

Consistently, this works with the so compiled version of PG:

postgres=# select 'Inf'::float8;
float8
----------
Infinity
(1 row)

Would it be worth treating this case apart in float.c, or should we just
blame the PlayStation's 2 Linux (quite old version 2.2.2) Gnu C library
to be broken?

I wonder how many implementations of strtod behave this way?
On a few other boxes of mine I've seen versions that accept 'Infinity'
as a whole or reject it as a whole

Bye, Chris.

Chris Mair <list(at)1006(dot)org> writes:
> It seems strtod() is to blame.
> ...
> on the PlayStation 2 returns:

> input string is 'Infinity'
> strtod returned val = inf
> errno = 0
> endptr points to 'inity'

> Would it be worth treating this case apart in float.c, or should we just
> blame the PlayStation's 2 Linux (quite old version 2.2.2) Gnu C library
> to be broken?

I'd just say that that version of glibc is broken. I have not seen this
behavior reported anywhere else.

In any case, I think we can update the Playstation 2 entry for 8.0 ...

regards, tom lane

On Fri, 2005-01-07 at 17:04, Marc G. Fournier wrote:

> [...]
> A current list of *known* supported platforms can be found at:
>
> http://developer.postgresql.org/supported-platforms.html
>
> We're always looking to improve that list, so we encourage anyone that
is
> running a platform not listed to please report on any success or
failures
> with Release Candidate 4.
> [...]

Hi,

one more test result: the regression test for 8.0 RC4 on a OpenBSD/sparc
says all 96 tests passed.

This was OpenBSD/sparc 3.3 with gcc 2.95.3 and GNU make 3.80 on a
SPARCstation 4.
I ran "make check" with option MAX_CONNECTIONS=10.

Bye, Chris.

PS: this is the second post of this message, the first has misteriously
disappeared 8 hours ago.

On Fri, Jan 07, 2005 at 12:04:00PM -0400, Marc G. Fournier wrote:
> A current list of *known* supported platforms can be found at:
> http://developer.postgresql.org/supported-platforms.html
> We're always looking to improve that list, so we encourage anyone that is
> running a platform not listed to please report on any success or failures
> with Release Candidate 4.

I can confirm the following two architectures successfully
completed the regression tests, running
$ gmake MAX_CONNECTIONS=10 check

Machine: SGI Altix 350
Processor: Itanium2
OS: SGI ProPack 3SP1 for Linux, Build 301r3-0407280007
Compiler: gcc 3.2.3

Machine: HP/Compaq ES45
Processor: Alpha ev68
OS: Compaq Tru64 UNIX V5.1B (Rev. 2650)
Compiler: Compaq C v6.5-011

-Mark

Tom Lane wrote:
> Stuart Bishop <stuart(at)stuartbishop(dot)net> writes:
>
>>Marc G. Fournier wrote:
>>| A current list of *known* supported platforms can be found at:
>>| http://developer.postgresql.org/supported-platforms.html
>
>
>>I notice that Ubuntu is not yet on this list. I can confirm that
>>PostgreSQL 7.4.5 is supported under Ubuntu 4.10 (warty) on all platforms
>>(x86, amd64 and ppc) and that PostgreSQL 7.4.6 is supported under Ubuntu
>>5.4 (hoary) on all platforms. We are now in version freeze for hoary, so
>>that version is fixed and the 8 series won't be officially supported
>>until the following release (October 2005), although installing the
>>Debian packages should work just fine.
>
>
> You seem to be under a misconception about the purpose of that list.
> It has nothing to do with what Postgres releases are packaged by
> various distributions. Entries on the list mean that someone has
> verified that the *source code* distribution builds per instructions
> and passes regression tests on that platform.
>
> If you are trying to say that you personally have verified that for
> Ubuntu, you didn't phrase it clearly.

My bad.

I can personally confirm that 8.0rc5 builds cleanly and passes the
regression tests under Ubuntu i386 (using the current Ubuntu 5.04/hoary
development release, now in version freeze). I can't personally confirm
the other architectures or the Ubuntu 4.10/warty release (although the
results should be identical to Debian).

The install docs require some interpretation, as by default under Ubuntu
root's password is disabled and you need to use sudo for various steps.
I don't think this is a problem, as naive Ubuntu users will generally
be using the click'n'drool pacakge manager.

--
Stuart Bishop <stuart(dot)bishop(at)canonical(dot)com> http://www.canonical.com/
Canonical Ltd. http://www.ubuntulinux.com/