=====================================================

Frequently Asked Questions (FAQ) forPostgresSQL V6.1

Frequently Asked Questions (FAQ) forPostgreSQL V6.1

IRIX Specific

TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ

=====================================================

last updated: FriJun 13 09:54:00 BST 1997

last updated: FriSep 19 11:51: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?

+1.6) The make fails with the following message:

ld32: ERROR 4: Conflicting flag setting: -call_shared

This file is divided approximately as follows:

1.*) InstallingPostgres95

2.*) UninstallingPostgres95

3.*) ExtendingPostgres95

1.*) InstallingPostgreSQL

2.*) UninstallingPostgreSQL

3.*) ExtendingPostgreSQL

Questions answered:

1.1) What extra items do I need to installPostgres95 under Irix?

1.1) What extra items do I need to installPostgreSQL 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?

1.5) Can I install PostgreSQL under Irix 6.x?

1.6) The make fails with the following message:

ld32: ERROR 4: Conflicting flag setting: -call_shared

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

----------------------------------------------------------------------

Section 1: InstallingPostgres95

Section 1: InstallingPostgreSQL

----------------------------------------------------------------------

1.1) What extra items do I need to installPostgres95 under Irix?

1.1) What extra items do I need to installPostgreSQL 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)

(This is part of the GNU fileutils package)

You may choose to install the following:

a) GNU readline library (if you wish psql to have readline

CUSTOM_INSTALL=ginstall

For an explanation as to why this is a good idea, see Question 2.1

Ginstall is part of the GNU fileutils package.

1.5) Can I install PostgreSQL under Irix 6.4?

1.5) Can I install PostgreSQL under Irix 6.x?

Irix 6.4 has a bug in ld which mishandles the addresses of

Irix 6.2-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>)

to Silicon Graphics.

One option is to use the Gnu version of ld. Alternatively,

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

$(OBJS): $(DIRS:%=%.dir)

1.6) The make fails with the following message:

ld32: ERROR 4: Conflicting flag setting: -call_shared

If gmake fails in .../src/backend while building obj/ACCESS.o

with a message from ld32, you can work around this by using

ld for the LD environment variable rather than cc.

The problem has been observed under Irix 5.3 when compiling both

Postgres95-1.09 and PostgreSQL-6.2Beta6, but on some systems

these appear to compile with no such problems.

Fix supplied by Brian Sanders (bsanders@netcom.com,

brian@fresnelsoft.com)

----------------------------------------------------------------------

Section 2: DeinstallingPostgres95

Section 2: DeinstallingPostgreSQL

----------------------------------------------------------------------

2.1) Why can't I move the executable files?

----------------------------------------------------------------------

Section 3: ExtendingPostgres95

Section 3: ExtendingPostgreSQL

----------------------------------------------------------------------

3.1) How do I compile a C program to create a function for extending

Here is a sample command line:

cc -I/usr/local/postgres95/include/ -I/usr/local/postgres95/src/backend

cc -I/usr/local/PostgreSQL/include/ -I/usr/local/PostgreSQL/src/backend

-shared -o funcs.so funcs.c