RE: Request of information about Postgresql database for Irix 6.4

Dear Senthil,

I am probably not much help, as I found that Postgresql installed with very
little trouble on my machine.

I am running a SGI Octane with IRIX 6.5.

I have set up a user Postgres, but that should not matter; I have, in the
past and on different machines, installed Postgres as different users than
"postgres". I do not believe that you are having problems due to your USER
not being Postgres.

I have now installed both version 6.4 and 6.4.2 (yesterday; not well tested)
on the SGI.

I used the SGI native cc and ld. The current defaults appear to be -n32. I
have installed the SGI "freeware" disk which supplies me with many GNU
items, including 'flex', 'bison', 'tar' and several others which are picked
up by ./configure. (My PATH puts the GNU items ahead of the SGI items.)

In order to get the make to complete, I needed to disable the C++ library.
There is something in the libpg++ which makes the IRIX compiler die. I have
not looked at this.

I was never able to get the Tcl/Tk interface to be recognised (SGI places
the piecies in funny places). I am not looking further into this as I am not
using it.

I have not been able yet to get the shared object libraries working; this
limits my access to plpgsql which I miss, so I am working on this. It
appears that the Postgres team does not know how to make shared libraries
for IRIX as Make.shlib has nothing for IRIX; I'll announce what I learn,
when I get a chance. I hope to get this done before the developers release
Postgresql 6.5-beta, but my schedule is quite busy at the moment.

I have not used the password options at all, so I have no idea of their
effect. Have you tried without them?

So, what did I do? I followed the INSTALL instructions exactly. As user
"postgres", I ran ./configure followed by "gmake all" and "gmake install".
My configure options looked like this:

./configure --prefix=/export/home/pgsql --oldincludedir=/usr/local/include \
    --with-perl --without-CXX --with-x

(Later, I also added the paths to my /usr/local/include and /usr/local/lib
to the configure options so my "readline" library could be picked up. That
works...)

My step 19, "initdb" ran smoothly. All the regression tests pass (int2 and
int4 fail for wording problems, not for mathematical reasons); that is, all
except those which rely on plpgsql.so. I can send you the files: make.log
and make.install.log if you wish and/or the config.[whatever].

The only hint I can offer, and it is a weak one now, is from the warning I
read in Edmund Mergl's README for the perl interface, Pg.pm
(.../src/interfaces/perl5/README). In
this file, he comments that SGI users need to use the malloc() which comes
with Perl rather than the default.  The message is not clear, but it hints
to me that there may be something wrong with some versions of the SGI
malloc().  As you are having core dumps due to memory allocations, I
_speculate_ that this may be a cause.

Good Luck,
Mark (mdalphin@amgen.com)

> ----------
> From:     Senthil Kumar Narayanasamy
> Sent:     Wednesday, January 27, 1999 1:43 PM
> To:     mdalphin@amgen.com
> Subject:     Request of information about Postgresql database for Irix
> 6.4
>
>
> Hi ,
>     Sorry for the direct mail,I am trying to install postgres in
> irix6.4 sgi Onyx2 machine, I was able to comile an link using sgi's
> native cc compiler and linker (compiled and linked with n32 option)
>
>     There is no user account called postgres in the machine,All files
> are installed in my user space, relevent environment variables are
>
> PGLIB=/d1/senthil/pgsql/lib
> PGDATA=/d1/senthil/pgsql/data
>
>     I always end up with a core dump is this because I am not user
> postgres.
>
> I have added tha the message at the end,Any ponters would be helpful.
>
> regards,
> senthil
>
>
>
> senthil@maya(4:08pm)>initdb -d --username=senthil
> Running with debug mode on.
>  initdb: using
> /d1/senthil/pgsql/lib/local1_template1.bki.source as input to create the
> template database.
>  initdb: using /d1/senthil/pgsql/lib/global1.bki.source
> as input to create the global classes.
>  initdb: using
> /d1/senthil/pgsql/lib/pg_hba.conf.sample as the host-based authentication
> control file.
>
> We are initializing the database system with username senthil (uid=18965).
>
> This user will own all the files and must also
> own the server process.
>
> Creating template database in /d1/senthil/pgsql/data/base/template1
> Running: postgres -boot -C -F -D/d1/senthil/pgsql/data -d template1
> initdb[326]: 23184 Memory fault(coredump) initdb: could not create
> template database initdb: cleaning up by wiping out
> /d1/senthil/pgsql/data/base/template1 senthil@maya(4:08pm)>
>