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

Frequently Asked Questions (FAQ) for PostgreSQL V7.1

Frequently Asked Questions (FAQ) for PostgreSQL7.2

SCO UnixWare and OpenServer specific

to be read in conjunction with the installation instructions

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

last updated: $Date: 2001/03/13 20:52:04 $

last updated: $Date: 2001/08/29 19:14:39 $

current maintainer: Billy G. Allie (Bill.Allie@mug.org)

original author: Andrew Merrill (andrew@compclass.com)

*) Readline

*) Using the UDK on OpenServer

*) Compiling PostgreSQL using the UDK

*) Reading the PostgreSQL man pages on UnixWare

*) Reading the PostgreSQL man pages

***************************************************************************

***************************************************************************

*) Reading the PostgreSQL man pages on UnixWare

*) Reading the PostgreSQL man pages

By default, the PostgreSQL man pages are installed into /usr/local/pgsql/man.

By default, UnixWare does not look there for man pages, so you will not be

able to read them.

You need to make the following changes to access the PostgreSQL man pages

from UnixWare.

1) You need to modify the MANPATH variable in /etc/default/man. I use:

By default, the PostgreSQL man pages are installed into

/usr/local/pgsql/man. By default, UnixWare does not look there for

man pages. To be able to read them you need to modify the MANPATH

variable in /etc/default/man. I use:

MANPATH=/usr/lib/scohelp/%L/man:/usr/dt/man:/usr/man:/usr/share/man:scohelp:/usr/local/man:/usr/local/pgsql/man

2) Add a line that says '1sql' to /etc/default/manSection.

3) The man pages for SQL commands are, by default, placed in section 'l'

(normally used for "l"ocal pages). UnixWare does not support the 'l'

section.

The solution I use is to move all these pages from section 'l' to a section

named '1sql'. To following KSH script will perform the move and change the

section names in the man page:

------------------------------8< CUT HERE >8------------------------------

#!/bin/ksh

cd /usr/local/pgsql/man

mv man1 man.1

mkdir man.1sql

cd /usr/local/pgsql/man/manl

for i in *.l

do

sed -e '/^\.TH/s/"l"/"1sql"/'\

-e 's/\\fR(l)/\\fR(1sql)/' $i >../man.1sql/${i%.l}.1sql

done

cd /usr/local/pgsql/man

rm -rf manl

/usr/ucb/catman -M /usr/local/pgsql/man 1

/usr/ucb/catman -M /usr/local/pgsql/man 1sql

------------------------------8< CUT HERE >8------------------------------

After running this script, you can view the man pages using the 'man'

command. They will not be usable from the scohelp system.

I am working on integrating the man pages into the scohelp system. When I

generate a PostgreSQL package for UnixWare 7.x, the man pages will be

integrated into the scohelp system.

I have not tried using the PostgreSQL man pages on OpenServer. Volunteers??

On OpenServer, some extra research needs to be invested to make the

man pages usable, because the man system is a bit different from other

platforms. Currently, PostgreSQL will not install them at all.

top_builddir = ..

include$(top_builddir)/src/Makefile.global

.NOTPARALLEL:

ifneq ($(wildcard$(srcdir)/postgres.tar.gz),)

found_html := yes

ifneq ($(wildcard$(srcdir)/man.tar.gz),)

ifneq ($(PORTNAME), sco)

found_man := yes

sqlmansect = 7

sqlmansectnum =$(shell expr X'$(sqlmansect)' : X'\([0-9]\)')

all: man1/.timestamp man$(sqlmansectnum)/.timestamp

man1/.timestampman$(sqlmansect_dummy)/.timestamp: man.tar.gz

gzip -d -c$<|$(TAR) xf -

forfilein man1/*.1;do \

mv$$file$$file.bak&&\

sed -e's/\\fR($(sqlmansect_dummy))/\\fR($(sqlmansectnum))/'$$file.bak>$$file&&\

rm$$file.bak||exit;\

@echo timestamp>man1/.timestamp

@echo timestamp>man$(sqlmansect_dummy)/.timestamp

all:

man$(sqlmansectnum)/.timestamp: man$(sqlmansect_dummy)/.timestamp

$(mkinstalldirs) man$(sqlmansectnum)

forfilein man$(sqlmansect_dummy)/*.$(sqlmansect_dummy);do \

sed -e'/^\.TH/s/"$(sqlmansect_dummy)"/"$(sqlmansect)"/'\

-e 's/\\fR($(sqlmansect_dummy))/\\fR($(sqlmansectnum))/' \

$$file >man$(sqlmansectnum)/`basename $$file | sed 's/.$(sqlmansect_dummy)$$/.$(sqlmansect)/'` || exit; \

done

@echo timestamp >$@

install: all installdirs

gzip -d -c postgres.tar.gz | ( cd $(DESTDIR)$(docdir)/html && $(TAR) xf - )

gzip -d -c man.tar.gz | ( cd $(DESTDIR)$(mandir) && $(TAR) xf - )

for file in man1/*.1 man$(sqlmansectnum)/*.$(sqlmansect) ; do \

$(INSTALL_DATA) $$file $(DESTDIR)$(mandir)/$$file || exit; \

done

installdirs:

$(mkinstalldirs)$(DESTDIR)$(mandir)$(DESTDIR)$(docdir)/html

$(mkinstalldirs) $(DESTDIR)$(docdir)/html

$(mkinstalldirs) $(addprefix $(DESTDIR)$(mandir)/man, 1 $(sqlmansectnum))

uninstall:

-rm -f $(addprefix $(DESTDIR)$(docdir)/html/, $(shell gunzip -c $(srcdir)/postgres.tar.gz | tar tf -))

-rm -f $(addprefix $(DESTDIR)$(mandir)/, $(shell gunzip -c $(srcdir)/man.tar.gz | tar tf -))

-rm -f $(addprefix $(DESTDIR)$(mandir)/, $(shell gunzip -c $(srcdir)/man.tar.gz | tar tf - | sed -e 's,man$(sqlmansect_dummy)/,man$(sqlmansectnum)/,' -e 's/.$(sqlmansect_dummy)$$/.$(sqlmansect)/'))

clean:

rm -rf man1/ man$(sqlmansectnum)/ man$(sqlmansect_dummy)/

distcleanmaintainer-clean: clean

subdir = doc/src

top_builddir = ../..

man.tar:

$(MAKE) -C sgml man

$(TAR) -cf$@ -C sgml man1manl

$(TAR) -cf$@ -C sgml man1man$(sqlmansect_dummy)

.PHONY: man

DEFAULTSECTION :=l

DEFAULTSECTION :=$(sqlmansect_dummy)

man:$(ALLSGML)

$(NSGMLS)$(NSGMLS_FLAGS)$(srcdir)/book-decl.sgml$(srcdir)/reference.sgml\

includedir_internal =$(pkgincludedir)/internal

mandir := @mandir@

sqlmansect_dummy = l

docdir := @docdir@

ifeq "$(findstring pgsql,$(docdir))" ""

};

staticchar*DeadLockMessage="Deadlock detected.\n\tSee the lock(l) manual page for a possible cause.";

LOCK_PRINT("WaitOnLock: aborting on lock",lock,lockmode);

SpinRelease(lockMethodTable->ctl->masterLock);

elog(ERROR,DeadLockMessage);

elog(ERROR,"deadlock detected");

}

%$(DLSUFFIX): %.o %$(EXPSUFF)

@echo Making shared library $@ from $*.o, $*$(EXPSUFF) and postgres.imp

$(CC) -Wl,-H512 -Wl,-bM:SRE -Wl,-bI:$(top_builddir)/src/backend/$(POSTGRES_IMP) -Wl,-bE:$*$(EXPSUFF) -o $@ $*.o $(LDFLAGS) $(LIBS) $(LDFLAGS_SL)

sqlmansect = 7

%.so: %.o

ln -fs $(top_srcdir)/src/backend/postgres _APP_

$(CC) -nostart -Xlinker -soname=$@ -o $@ _APP_ $<

sqlmansect = 7