Skip site navigation (1) Skip section navigation (2)

Re: Which tool versions yield working pgsql on SunOS 4.1.4 ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: warren_spencer_1977(at)yahoo(dot)com (Warren Spencer)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Which tool versions yield working pgsql on SunOS 4.1.4 ?
Date: 2002-12-16 22:06:59
Message-ID: 28876.1040076419@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
warren_spencer_1977(at)yahoo(dot)com (Warren Spencer) writes:
> I'm attempting to install PostgreSQL on a SunOS 4.1.4 box.  So far,
> I've tried various combinations of gcc 2.95.1,.2,.3, PostgreSQL 7.1.3,
> 7.0.3, 7.3.  In some cases, gcc won't build. In others, PostgreSQL
> won't build.  But in the gcc 2.95.2/pg 7.1.3 case, I've got exactly
> the same INITDB problem as Jeff Stevens (post 2002-09-25 09:36:36
> PST):  ERROR:  syntax error at line 2658: unexpected token parse
> error.

What awk are you using?  Jeff's problem appeared to stem from using an
awk that didn't recognize the ENVIRON["foo"] construct; at any rate
something was going wrong with genbki.sh's attempt to initialize
"nextbkioid" in its main awk run.  I suppose the problem might also be
somewhere in this fragment of that script:

# Get FirstGenBKIObjectId from access/transam.h
for dir in $INCLUDE_DIRS; do
    if [ -f "$dir/access/transam.h" ]; then
        BKIOBJECTID=`grep '^#define[ 	]*FirstGenBKIObjectId' $dir/access/transam.h | $AWK '{ print $3 }'`
        break
    fi
done
export BKIOBJECTID

Anyway, play around with src/backend/catalog/genbki.sh to see if you can
see what's going on.  Correct initialization of pg_aggregate should look
like

open pg_aggregate
insert OID = 10000 ( avg 1 int8_accum numeric_avg 20 1231 1700 "{0,0,0}" )
insert OID = 10001 ( avg 1 int4_avg_accum int8_avg 23 1016 1700 "{0,0}" )
insert OID = 10002 ( avg 1 int2_avg_accum int8_avg 21 1016 1700 "{0,0}" )
...

but Jeff's output looked like

open pg_aggregate
insert OID = ( avg 1 int8_accum numeric_avg 20 1231 1700 "{0,0,0}" )
insert OID = 1 ( avg 1 int4_avg_accum int8_avg 23 1016 1700 "{0,0}" )
insert OID = 2 ( avg 1 int2_avg_accum int8_avg 21 1016 1700 "{0,0}" )
...


BTW, if you get it going with PG 7.3, please let us know.  SunOS used to
be considered a supported platform, but we've not heard any reports from
users of it in quite awhile ...

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Christopher SmithDate: 2002-12-17 02:36:59
Subject: new prepared query in plpgsql function?
Previous:From: Ian BarwickDate: 2002-12-16 21:49:58
Subject: Re: client for solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group