Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-10 Thread Adrian Maier
On 8/10/07, Decibel! [EMAIL PROTECTED] wrote:
 On Fri, Aug 10, 2007 at 08:08:55AM +0300, Adrian Maier wrote:
  So it looks like this is simply a known issue that hasn't been backpatched.
  I'll simply use 8.2 .

 Ok, I'll bite... if you can use 8.2, why were you trying with 7.4
 instead? It sounds like you're paying new-car-prices for something
 that's 5 years old...

The first attempt was with 7.4 because our application is still running
on that version in production.   An upgrade is something that has to be
done, but it will take a little more time to test and do it properly.

Right now I am just doing some tests:  i happen to have access to this
PA-RISC server and was curious to see how is the application behaving
if the database is running on such a machine.
But there are no chances to use such a server in production, so my tests
are purely ... educative .


Cheers,
Adrian Maier

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-10 Thread Decibel!
On Fri, Aug 10, 2007 at 08:08:55AM +0300, Adrian Maier wrote:
 So it looks like this is simply a known issue that hasn't been backpatched.
 I'll simply use 8.2 .

Ok, I'll bite... if you can use 8.2, why were you trying with 7.4
instead? It sounds like you're paying new-car-prices for something
that's 5 years old...
-- 
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)


pgpv9MZhCTRdP.pgp
Description: PGP signature


Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-09 Thread Tom Lane
Adrian Maier [EMAIL PROTECTED] writes:
 I have just tried to compile postgresql 7.4.17  on a HP-UX 11.11 box
 (PA-RISC)   and the compliation fails in gist.

I do not think anyone cares about making 7.4.x run on platforms it did
not support before.  Use a newer PG release.

regards, tom lane

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-09 Thread Decibel!
On Thu, Aug 09, 2007 at 11:46:47AM -0400, Tom Lane wrote:
 Adrian Maier [EMAIL PROTECTED] writes:
  I have just tried to compile postgresql 7.4.17  on a HP-UX 11.11 box
  (PA-RISC)   and the compliation fails in gist.
 
 I do not think anyone cares about making 7.4.x run on platforms it did
 not support before.  Use a newer PG release.

Actually, this is PA-RISC, not the numerous emails we've gotten this
week about HPUX on ia64 (what is it with the HPUX guys this week?)

http://www.postgresql.org/docs/7.4/interactive/supported-platforms.html
indicates that HPUX on PA-RISC should work...
-- 
Decibel!, aka Jim Nasby[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)


pgpGfcyDpEN3F.pgp
Description: PGP signature


Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-09 Thread Adrian Maier
On 8/10/07, Tom Lane [EMAIL PROTECTED] wrote:
 Decibel! [EMAIL PROTECTED] writes:
  On Thu, Aug 09, 2007 at 11:46:47AM -0400, Tom Lane wrote:
  Adrian Maier [EMAIL PROTECTED] writes:
  I have just tried to compile postgresql 7.4.17  on a HP-UX 11.11 box
  (PA-RISC)   and the compliation fails in gist.
 
  I do not think anyone cares about making 7.4.x run on platforms it did
  not support before.  Use a newer PG release.

  Actually, this is PA-RISC, not the numerous emails we've gotten this
  week about HPUX on ia64 (what is it with the HPUX guys this week?)

 Oh, my mistake --- obviously hadn't consumed enough caffeine this
 morning.

 [ digs around a bit... ]  However, I might have been right for the
 wrong reasons.  I'm thinking Adrian is trying to build for 64-bit
 HPPA (a beast the 7.4 supported-platforms matrix doesn't know about),
 and is falling foul of this problem:
 http://archives.postgresql.org/pgsql-hackers/2004-03/msg01196.php
 Teodor fixed that in the 8.0 devel cycle, but couldn't back-patch it
 because it meant an on-disk layout change of gist indexes.

 What I suspect is that gcc 3.3.3 doesn't have the specific error checks
 I complained of in the above message, but simply generates bogus
 assembly code for the incorrect C code :-(

So it looks like this is simply a known issue that hasn't been backpatched.
I'll simply use 8.2 .


Thanks for your answers,
Adrian Maier

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] Compilation of pg 7.4.17 fails on HP-UX

2007-08-09 Thread Tom Lane
Adrian Maier [EMAIL PROTECTED] writes:
 On 8/10/07, Tom Lane [EMAIL PROTECTED] wrote:
 [ digs around a bit... ]  However, I might have been right for the
 wrong reasons.  I'm thinking Adrian is trying to build for 64-bit
 HPPA (a beast the 7.4 supported-platforms matrix doesn't know about),
 and is falling foul of this problem:
 http://archives.postgresql.org/pgsql-hackers/2004-03/msg01196.php

 So it looks like this is simply a known issue that hasn't been backpatched.

You didn't confirm in so many words: were you trying to build 64-bit?
I'd have expected a 32-bit build to work.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly