Обсуждение: Which tool versions yield working pgsql on SunOS 4.1.4 ?

Hi,

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.

If anyone could point me in the right direction for version
combinations, or how to cure the initdb problem, I would sincerely
appreciate it!

Many thanks,

ws

Get 7.3.  7.1.3 is too old.

---------------------------------------------------------------------------

Warren Spencer wrote:
> Hi,
>
> 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.
>
> If anyone could point me in the right direction for version
> combinations, or how to cure the initdb problem, I would sincerely
> appreciate it!
>
> Many thanks,
>
> ws
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

warren_spencer_1977@yahoo.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