From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: HPUX FAQ update
Date: Mon, 19 Feb 2001 20:03:38 -0500 (EST)
Message-ID: <200102200103.UAA15653@candle.pha.pa.us> (raw)
In-Reply-To: <9769.982627490@sss.pgh.pa.us>
The CVS are the master copies. The only issue is that the web site is
not updated until at night, unless you do it from the hub.org command
line.
> Bruce,
> I seem to recall you saying that the CVS copies of the
> platform-specific FAQs are not the master copies. If that's correct,
> would you install the attached updated version of FAQ_HPUX into the
> right places, or else tell me how to do it?
>
> regards, tom lane
>
>
> =======================================================
> Frequently Asked Questions (FAQ) for PostgreSQL 7.1
> HP-UX Specific
> TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
> =======================================================
> last updated: $Date: 2001/02/19 17:30:01 $
>
> current maintainer: Tom Lane (tgl@sss.pgh.pa.us)
> original author: Tom Lane (tgl@sss.pgh.pa.us)
>
>
> Questions covered here:
> 1.1) What do I need to install PostgreSQL on HP-UX?
> 1.2) Anything special about the build/install procedure?
> 1.3) yacc dies trying to process src/backend/parser/gram.y.
> 1.4) Linking the main postgres executable fails, complaining that
> there's no "alloca" function.
> 1.5) OK, it seemed to build and install, but the regression test fails.
>
>
> ----------------------------------------------------------------------
> Section 1: Installing PostgreSQL
> ----------------------------------------------------------------------
>
> 1.1) What do I need to install PostgreSQL on HP-UX?
>
> PostgreSQL 7.1 is known to build and pass regression test on HPUX 10.20,
> given appropriate system patch levels and build tools. It should work on
> other HPUX 9.* and 10.* releases for Series 700/800 machines, too (prior
> Postgres releases were tested on 9.03 and 9.05). I have heard nonspecific
> reports of problems on HPUX 11; more info and/or patches would be
> appreciated!
>
> Aside from the PostgreSQL source distribution, you will need GNU make
> (HP's make will not do), and either GNU gcc or HP's full ANSI C compiler.
> If you intend to build from CVS sources rather than a distribution tarball,
> you will also need flex (GNU lex) and bison (GNU yacc).
>
> I'd also recommend making sure you are fairly up-to-date on HP patches,
> particularly if you are using HPUX 9. At a minimum, if you are on HPUX 9,
> you *must* have PHSS_4630 (libm update) or a successor patch; otherwise
> Postgres' date/time functions will misbehave. On general principles you
> should be current on libc and ld/dld patches, as well as compiler patches
> if you are using HP's C compiler. (The only other presently known failure
> from out-of-date system libraries is that on HPUX 10.10, the backend will
> crash after the second error message in a session unless you have upgraded
> libc to PHCO_16722 or later.)
>
> See HP's support websites, such as http://us-support.external.hp.com/,
> for free copies of their latest patches.
>
>
> 1.2) Anything special about the build/install procedure?
>
> If you have both HP's C compiler and GCC's, then you might want to
> explicitly select the compiler to use when you run `configure':
> CC=cc ./configure
> for HP's C compiler, or
> CC=gcc ./configure
> for GCC. If you omit this setting then configure will pick gcc.
>
> Note also that configure will default to no optimization for cc;
> you'll probably want to override that, say with
> CC=cc CFLAGS=+O2 ./configure
>
> The default install target location is /usr/local/pgsql, which
> (particularly on HPUX 10) you might want to change to something under
> /opt. If so, use the --prefix switch to configure.
>
> If you want to build the C++ client library (libpq++) then you need
> to use a C++ compiler from the same source as the C compiler; mixing
> HP and GNU compilers doesn't work. If you have both C++ compilers
> in your PATH, keep an eye on whether configure picks the right one.
> If it makes the wrong choice, set the environment variable CXX:
> CC=gcc CXX=g++ ./configure --with-CXX
> or
> CC=cc CXX=aCC ./configure --with-CXX
>
>
> 1.3) yacc dies trying to process src/backend/parser/gram.y.
>
> HP's yacc doesn't create its tables large enough to handle the Postgres
> grammar (a lot of other vendors' yaccs have this problem too). The
> preferred solution is to use GNU bison instead. If you don't want to
> do that for some reason, it's possible to increase yacc's table sizes
> enough to cope. With a pre-6.4 PostgreSQL grammar, I was able to get
> HPUX 9's yacc to work by setting YFLAGS to
> -d -Np2000 -Ns3000 -Nm100000 -Nl2000 -Na30000 -Nc10000
> (You can edit YFLAGS either in the template file before running
> configure, or in src/Makefile.global afterwards.) Later PostgreSQL
> releases might require even larger tables, but this should do for
> a starting point.
>
> Note that this shouldn't affect you if you are using a distribution
> tarball, but it does matter if you pull the sources from the CVS server.
>
>
> 1.4) Linking the main postgres executable fails, complaining that
> there's no "alloca" function.
>
> You're using an old version of GNU bison. Update to 1.28 or later,
> and re-make the bison output files. Or build with gcc, or update to
> HPUX 10, either of which will provide support for alloca.
>
>
> 1.5) OK, it seemed to build and install, but the regression test fails.
>
> There are several "expected failures" due to differences between HPUX
> and the regression test reference platform used by the PostgreSQL group.
> All of these should be compensated for by the regression test comparison
> mechanism, with the possible exception of some low-order-digit differences
> in the geometry tests (depending on which compiler and math library
> versions you use).
>
> Any other error is cause for suspicion. In particular, if you see
> failures in the datetime test on HPUX 9, you probably forgot to
> install the libm patch PHSS_4630 --- see item 1.1 above.
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us
Subject: Re: HPUX FAQ update
In-Reply-To: <200102200103.UAA15653@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox