Обсуждение: [HACKERS] Irix-specific FAQ
=====================================================
Frequently Asked Questions (FAQ) for PostgresSQL V6.1
IRIX Specific
TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
=====================================================
last updated: Fri Jun 13 09:54:00 BST 1997
current maintainer: Andrew C.R. Martin (martin@biochem.ucl.ac.uk)
original author: Andrew C.R. Martin (martin@biochem.ucl.ac.uk)
Changes in this version (* = modified, + = new, - = removed):
+1.5) Can I install PostgreSQL under Irix 6.4?
This file is divided approximately as follows:
1.*) Installing Postgres95
2.*) Uninstalling Postgres95
3.*) Extending Postgres95
Questions answered:
1.1) What extra items do I need to install Postgres95 under Irix?
1.2) What changes do I need to make to src/Makefile.global?
1.3) What are the references in X11_LIB to libsocket and libnsl in
src/Makefile.global?
1.4) Are there any other changes I should make?
1.5) Can I install PostgreSQL under Irix 6.4?
2.1) Why can't I move the executable files?
3.1) How do I compile a C program to create a function for extending
Postgres95
- ----------------------------------------------------------------------
Section 1: Installing Postgres95
- ----------------------------------------------------------------------
1.1) What extra items do I need to install Postgres95 under Irix?
You *must* have the following installed:
a) Gnu make (installed as gmake)
You are recommended to install the following:
a) GNU install (installed as ginstall)
You may choose to install the following:
a) GNU readline library (if you wish psql to have readline
support).
b) tcl/tk (if you wish to compile pgtclsh)
1.2) What changes do I need to make to src/Makefile.global or
src/Makefile.custom?
The easiest way to do this is to use the customize script in
the src directory.
You *must* set the following variables:
PORTNAME= irix5
You will also need to change the following to match your own
installation:
POSTGRESDIR
If you switch on the USE_TCL option, you will need to set these:
TCL_INCDIR=
TCL_LIBDIR=
TCL_LIB =
TK_INCDIR=
TK_LIBDIR=
TK_LIB =
You may also make any other changes you need as documented in
the INSTALL file and in Makefile.global
1.3) What are the references in X11_LIB to libsocket and libnsl in
src/Makefile.global?
This was a problem in 1.08 (they are Sun Solaris specific).
It is fixed in 1.09 and above.
1.4) Are there any other changes I should make?
If you have installed the GNU install program (ginstall), you
should add the following line to src/Makefile.custom:
CUSTOM_INSTALL=ginstall
For an explanation as to why this is a good idea, see Question 2.1
1.5) Can I install PostgreSQL under Irix 6.4?
Irix 6.4 has a bug in ld which mishandles the addresses of
static procedures when object files are assembled into
larger object files using 'ld -r'. This bug has been reported
to Silicon Graphics. The following patch should be applied as
a workaround. (Supplied by Bob Bruccoleri <bruc@bms.com>)
*** ./backend/Makefile.orig Thu May 22 00:00:15 1997
- --- ./backend/Makefile Thu Jun 5 16:47:27 1997
***************
*** 54,60 ****
all: postgres $(POSTGRES_IMP) global1.bki.source local1_template1.bki.source
postgres: $(OBJS) ../utils/version.o
! $(CC) -o postgres $(OBJS) ../utils/version.o $(LDFLAGS)
$(OBJS): $(DIRS:%=%.dir)
- --- 54,64 ----
all: postgres $(POSTGRES_IMP) global1.bki.source local1_template1.bki.source
postgres: $(OBJS) ../utils/version.o
! # $(CC) -o postgres $(OBJS) ../utils/version.o $(LDFLAGS)
! -rm -f *.o
! find . -name "*.o" -exec cp \{\} . \;
! rm -f SUBSYS.o
! $(CC) -o postgres *.o ../utils/version.o $(LDFLAGS)
$(OBJS): $(DIRS:%=%.dir)
- ----------------------------------------------------------------------
Section 2: Deinstalling Postgres95
- ----------------------------------------------------------------------
2.1) Why can't I move the executable files?
By default, the IRIX port uses the BSD compatible version of
install from /usr/bin/X11. If you read the man page for this
version of install, you will see that it is not meant for
end-user use; it has the interesting side-effect of chowning
files it installs to root.
You should still be able to delete the files as you (the
postgres user) will own the directory in which they are
stored.
The normal IRIX install program cannot be used easily as it
takes its arguments in the reverse order. It is therefore
recommended to use the GNU version of install (ginstall).
See Question 1.4
- ----------------------------------------------------------------------
Section 3: Extending Postgres95
- ----------------------------------------------------------------------
3.1) How do I compile a C program to create a function for extending
Postgres95
Here is a sample command line:
cc -I/usr/local/postgres95/include/ -I/usr/local/postgres95/src/backend
-shared -o funcs.so funcs.c
- ----------------------------------------------------------------------------
Dr. Andrew C.R. Martin University College London
EMAIL: (Work) martin@biochem.ucl.ac.uk (Home) andrew@stagleys.demon.co.uk
URL: http://www.biochem.ucl.ac.uk/~martin
Tel: (Work) +44(0)171 419 3890 (Home) +44(0)1372 275775
------------------------------
Just would like to point out a minor thing... there are still references to Postgres95, shouldn't this be PostgreSQL? On Fri, 13 Jun 1997, Andrew Martin wrote: >===================================================== >Frequently Asked Questions (FAQ) for PostgresSQL V6.1 >IRIX Specific >TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ >===================================================== >last updated: Fri Jun 13 09:54:00 BST 1997 > >current maintainer: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) >original author: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) > > >Changes in this version (* = modified, + = new, - = removed): >+1.5) Can I install PostgreSQL under Irix 6.4? > >This file is divided approximately as follows: >1.*) Installing Postgres95 >2.*) Uninstalling Postgres95 >3.*) Extending Postgres95 [...snipped...] Mike __ Michael J. Maravillo Philippines Online System Administrator PGP KeyID: 470AED9D InfoDyne, Incorporated http://www.philonline.com.ph/~mmj/ 4A N&M Bldg, 1184 Chino Roces, Makati ------------------------------
> Just would like to point out a minor thing... there are still > references to Postgres95, shouldn't this be PostgreSQL? > > On Fri, 13 Jun 1997, Andrew Martin wrote: > >===================================================== > >Frequently Asked Questions (FAQ) for PostgresSQL V6.1 > >IRIX Specific > >TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ > >===================================================== > >last updated: Fri Jun 13 09:54:00 BST 1997 > > > >current maintainer: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) > >original author: Andrew C.R. Martin (martin@biochem.ucl.ac.uk) > > > > > >Changes in this version (* = modified, + = new, - = removed): > >+1.5) Can I install PostgreSQL under Irix 6.4? > > > >This file is divided approximately as follows: > >1.*) Installing Postgres95 > >2.*) Uninstalling Postgres95 > >3.*) Extending Postgres95 > [...snipped...] > > Mike > __ > Michael J. Maravillo Philippines Online > System Administrator PGP KeyID: 470AED9D InfoDyne, Incorporated > http://www.philonline.com.ph/~mmj/ 4A N&M Bldg, 1184 Chino Roces, Makati > > Oops! I'd fixed the Linux one, but not the Irix one. Here's a patch to what I supplied before. You can get the latest version from http://www.biochem.ucl.ac.uk/~martin/pgsql/irix.faq 2c2 < Frequently Asked Questions (FAQ) for PostgresSQL V6.1 - --- > Frequently Asked Questions (FAQ) for PostgreSQL V6.1 16,18c16,18 < 1.*) Installing Postgres95 < 2.*) Uninstalling Postgres95 < 3.*) Extending Postgres95 - --- > 1.*) Installing PostgreSQL > 2.*) Uninstalling PostgreSQL > 3.*) Extending PostgreSQL 22c22 < 1.1) What extra items do I need to install Postgres95 under Irix? - --- > 1.1) What extra items do I need to install PostgreSQL under Irix? 30c30 < Postgres95 - --- > PostgreSQL 33c33 < Section 1: Installing Postgres95 - --- > Section 1: Installing PostgreSQL 36c36 < 1.1) What extra items do I need to install Postgres95 under Irix? - --- > 1.1) What extra items do I need to install PostgreSQL under Irix? 121c121 < Section 2: Deinstalling Postgres95 - --- > Section 2: Deinstalling PostgreSQL 143c143 < Section 3: Extending Postgres95 - --- > Section 3: Extending PostgreSQL 146c146 < Postgres95 - --- > PostgreSQL 150c150 < cc -I/usr/local/postgres95/include/ -I/usr/local/postgres95/src/backend - --- > cc -I/usr/local/PostgreSQL/include/ -I/usr/local/PostgreSQL/src/backend - ---------------------------------------------------------------------------- Dr. Andrew C.R. Martin University College London EMAIL: (Work) martin@biochem.ucl.ac.uk (Home) andrew@stagleys.demon.co.uk URL: http://www.biochem.ucl.ac.uk/~martin Tel: (Work) +44(0)171 419 3890 (Home) +44(0)1372 275775 ------------------------------