Thread: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

From
Devrim GÜNDÜZ
Date:
Hi,

I'm getting the following failure on RHEL 4:

http://www.gunduz.org/temp/regression.out
http://www.gunduz.org/temp/regression.diffs

Here is the Makefile.regress that I use while building RPMs on 8.4:

https://projects.commandprompt.com/public/pgcore/repo/rpm/redhat/8.4/postgresql/EL-4/Makefile.regress

Is that with the Makefile, or with OS?

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr                  http://www.gunduz.org

Re: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

From
Tom Lane
Date:
Devrim GÜNDÜZ <devrim@gunduz.org> writes:
> I'm getting the following failure on RHEL 4:

> http://www.gunduz.org/temp/regression.out
> http://www.gunduz.org/temp/regression.diffs

This test is checking whether you have working 64-bit-tzdata support.
It seems you don't.

If you built with --with-system-tzdata, and RHEL4 doesn't include
64-bit tzdata files, then this failure would be expected.  (I'm not
totally sure about the second premise, but some quick digging in
the specfile's changelog suggests that Red Hat only started to
support 64-bit tzdata in RHEL5.)

I'm not sure whether to recommend not using --with-system-tzdata.
If you don't then routine platform updates of tzdata won't help
Postgres; that might or might not be worse than not having working
post-2038 DST calculations.
        regards, tom lane


Re: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

From
Devrim GÜNDÜZ
Date:
On Mon, 2009-04-13 at 15:31 -0400, Tom Lane wrote:
> > I'm getting the following failure on RHEL 4:
>
> > http://www.gunduz.org/temp/regression.out
> > http://www.gunduz.org/temp/regression.diffs
>
> This test is checking whether you have working 64-bit-tzdata support.
> It seems you don't.
>
> If you built with --with-system-tzdata, and RHEL4 doesn't include
> 64-bit tzdata files, then this failure would be expected.  (I'm not
> totally sure about the second premise, but some quick digging in
> the specfile's changelog suggests that Red Hat only started to
> support 64-bit tzdata in RHEL5.)

So what changed between 8.3 and 8.4? Same box can build 8.3 with
--with-system-tzdata .

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr                  http://www.gunduz.org

Re: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

From
Tom Lane
Date:
Devrim GÜNDÜZ <devrim@gunduz.org> writes:
> On Mon, 2009-04-13 at 15:31 -0400, Tom Lane wrote:
>> This test is checking whether you have working 64-bit-tzdata support.
>> It seems you don't.

> So what changed between 8.3 and 8.4? Same box can build 8.3 with
> --with-system-tzdata . 

We didn't have 64-bit tzdata support before --- it's a new test covering
new functionality.
        regards, tom lane


Re: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1

From
Devrim GÜNDÜZ
Date:
On Tue, 2009-04-14 at 11:16 -0400, Tom Lane wrote:
> > So what changed between 8.3 and 8.4? Same box can build 8.3 with
> > --with-system-tzdata .
>
> We didn't have 64-bit tzdata support before --- it's a new test
> covering new functionality.

Thanks Tom.

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr                  http://www.gunduz.org