Обсуждение: 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)>
>
RE: Request of information about Postgresql database for Irix 6.4
От
Senthil Kumar Narayanasamy
Дата:
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~