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

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