RE: Help on PGSQL installation (Solution)

Folks,

I have already succeeded but my approach is different.=20

For searching the library, I changed the following line in
Makefile.global

#LIBPQDIR:=3D $(SRCDIR)/interfaces/libpq
LIBPQDIR:=3D /opt/postgres/lib

Then I can find the library and get a similar warning like yours,=20

/usr/lib/dld.sl: Call to mmap() failed - TEXT /opt/pgsql/lib/libpq.sl

You actually found the libraries and fail to load it, what's wrong? It
is easy,

chmod 555 libpq.sl

Bingo! Enjoy!

Barry

   From:  afaust[SMTP:afaust@Phys.UAlberta.CA]
   Sent:  Friday, September 11, 1998 07:26 AM
   To:  Barry Cheung; pgsql-admin
   Cc:  afaust
   Subject:  Re: Help on installation
=20=20=20
=20=20=20
   Hi there
=20=20=20
      I am running into a similar problem and managed to make a little
   progress.
=20=20=20
      The shared library problem can be fixed with a little
   fudge...although I dont know how security safe it is. When compiling,
   the
   ../../interfaces/libpq/libpq.sl path was hardcoded and the final
   binaries
   are not allowed to scan the SHLIB_PATH for the correct library. Using
   'chatr' on HP-UX 10.20 try ...
=20=20=20
   XXX#----------------------------
   XXX#!/bin/sh
   XXXfor file in pg_dump pg_id psql ; do
   XXX   chmod u+w $file=20=20=20
   XXX   chatr +s enable $file
   XXX   chmod u-w $file
   XXXdone
   XXX#----------------------------
=20=20=20
   'chatr +s enable ' allows the program to scan $SHLIB_PATH for
   libpq.sl.
   Just make sure you add the correct path to SHLIB_PATH.
=20=20=20
      I am still getting core dumps however.
=20=20=20
   [pneuma] > initdb --username=3Dafaust
   initdb: using /users/afaust/bin/pgsql/lib/local1_template1.bki.source
   as input to create the template database.
   initdb: using /users/afaust/bin/pgsql/lib/global1.bki.source as input
   to create the global classes.
   initdb: using /users/afaust/bin/pgsql/lib/pg_hba.conf.sample as the
   host-based authentication control file.
=20=20=20
   /usr/lib/dld.sl: Call to mmap() failed - TEXT
   /users/afaust/bin/pgsql/lib/libpq.sl
   /usr/lib/dld.sl: Permission denied
   initdb[193]: test: Specify a parameter with this command.
   /usr/lib/dld.sl: Call to mmap() failed - TEXT
   /users/afaust/bin/pgsql/lib/libpq.sl
   /usr/lib/dld.sl: Permission denied
   /usr/lib/dld.sl: Call to mmap() failed - TEXT
   /users/afaust/bin/pgsql/lib/libpq.sl
   /usr/lib/dld.sl: Permission denied
   initdb[201]: test: Specify a parameter with this command.
   We are initializing the database system with username afaust (uid=3D).
   This user will own all the files and must also own the server
   process.
=20=20=20
   initdb: creating template database in
   /users/afaust/bin/pgsql/data/base/template1
   Running: postgres -boot -C -F -D/users/afaust/bin/pgsql/data -Q
   template1
   ERROR:  pg_atoi: error in "f": can't parse "f"
   ERROR:  pg_atoi: error in "f": can't parse "f"
   initdb[267]: 17826 Memory fault(coredump)
   initdb: could not create template database
   initdb: cleaning up by wiping out
   /users/afaust/bin/pgsql/data/base/template1
=20=20=20
=20=20=20
=20=20=20
   ---------------------------------------------------------------------
   -------
   Anthony A. Faust              | Mail me with "PGP" in subject for my
   pgp key=20
   Centre for Subatomic Research | FAX:   403 492 3408
   University of Alberta         | PHONE: 403 492 5017
   Edmonton, Alberta, Canada     | Do not Fold, Spindle, or Mutilate.=20
   ---------------------------------------------------------------------
   -------
=20=20=20=