RE: Request of information about Postgresql database for Irix 6.4

Hello Mark,
    Thanks for the reply,
I am a student in State University ,Buffalo,NY. Even though I know c,and
unix stuff,I haven't compiled huge programs like this one ,We need this
datadata base for a project (virtual factory project

http://wings.buffalo.edu/academic/department/eng/mae/vrlab/)

    I have managed it to compile and install in a sun node ,and it
is working fine.
    I understand that one needs libraries and header files for doing
any embedded sql programming ,I have got those libraries,
    I am going to write few programs and see how it works.
(client in sgi Onyx and server in a sun enterprise 3500).
    I'll contact you in case of any problem.

Thanks for your help,
besht wishes,
senthil


On Wed, 27 Jan 1999, Dalphin, Mark wrote:

#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)>
#>
#

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                        Senthil Kumar Narayanasamy
                     http://www.eng.buffalo.edu/~senthil
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Home:                                                 Office:
1525,Amherst Manor Drive, #804,                       809, Furnas Hall
Williamsville,                                        University at Buffalo
NY, 14221.                                           Buffalo, NY 14260
Ph: (716)632-3135                                     Ph:(716)645 2593 x2260
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~