diff options
Diffstat (limited to 'databases/postgresql84-server/files')
20 files changed, 211 insertions, 271 deletions
diff --git a/databases/postgresql84-server/files/dot.cshrc.in b/databases/postgresql84-server/files/dot.cshrc.in new file mode 100644 index 000000000000..a326041bff7b --- /dev/null +++ b/databases/postgresql84-server/files/dot.cshrc.in @@ -0,0 +1,13 @@ +set path = ( %%PREFIX%%/%%PG_PREFIX%%bin $path ) + +setenv PGLIB %%PREFIX%%/%%PG_PREFIX%%lib + +# note: PGDATA can be overridden by the -D startup option +setenv PGDATA $HOME/data + +#You might want to set some locale stuff here +#setenv PGDATESTYLE ISO +#setenv LC_ALL sv_SE.ISO_8859-1 + +# if you want to make regression tests use this TZ +#setenv TZ PST8PDT diff --git a/databases/postgresql84-server/files/dot.profile.in b/databases/postgresql84-server/files/dot.profile.in index 3d8ca9ac4641..4aca6aadd19a 100644 --- a/databases/postgresql84-server/files/dot.profile.in +++ b/databases/postgresql84-server/files/dot.profile.in @@ -1,10 +1,12 @@ -PATH=${PATH}:%%PREFIX%%/pgsql/bin -PGLIB=%%PREFIX%%/pgsql/lib +# both new and old layout's paths, but new path first... +PATH=%%PREFIX%%/%%PG_PREFIX%%bin:${PATH} + +PGLIB=%%PREFIX%%/%%PG_PREFIX%%lib # note: PGDATA can be overridden by the -D startup option -PGDATA=%%PREFIX%%/pgsql/data +PGDATA=${HOME}/data -export PATH MANPATH PGLIB PGDATA +export PATH PGLIB PGDATA #You might want to set some locale stuff here #PGDATESTYLE=ISO diff --git a/databases/postgresql84-server/files/patch-aj b/databases/postgresql84-server/files/patch-aj index 4231fc94ede9..94c0d6d79991 100644 --- a/databases/postgresql84-server/files/patch-aj +++ b/databases/postgresql84-server/files/patch-aj @@ -1,67 +1,118 @@ ---- bin/pg_passwd/pg_passwd.c.orig Mon Apr 17 05:45:18 2000 -+++ bin/pg_passwd/pg_passwd.c Sat May 20 17:54:59 2000 -@@ -18,11 +18,15 @@ - - #endif +--- src/bin/pg_passwd/pg_passwd.c.orig Sat Mar 24 01:54:55 2001 ++++ src/bin/pg_passwd/pg_passwd.c Wed Apr 18 04:54:14 2001 +@@ -7,6 +7,12 @@ + #include <errno.h> + #include <time.h> + #include <ctype.h> ++ ++#if defined(__FreeBSD__) ++#include <pwd.h> /* defines _PASSWORD_LEN, max # of characters in a password */ ++#include <sys/time.h> /* gettimeofday for password salt */ ++#endif ++ + #define issaltchar(c) (isalnum((unsigned char) (c)) || (c) == '.' || (c) == '/') -+#ifndef _POSIX_SOURCE -+# define _PASSWORD_LEN 128 /* max length, not containing NULL */ + #ifdef HAVE_TERMIOS_H +@@ -23,18 +29,31 @@ + * We assume that the output of crypt(3) is always 13 characters, + * and that at most 8 characters can usefully be sent to it. + * ++ * For FreeBSD, take these values from /usr/include/pwd.h + * Postgres usernames are assumed to be less than NAMEDATALEN chars long. + */ ++#if defined(__FreeBSD__) ++#define CLEAR_PASSWD_LEN _PASSWORD_LEN ++#define CRYPTED_PASSWD_LEN _PASSWORD_LEN /* max length, not containing NULL */ ++#define SALT_LEN 10 ++#else + #define CLEAR_PASSWD_LEN 8 /* not including null */ + #define CRYPTED_PASSWD_LEN 13 /* not including null */ ++#define SALT_LEN 3 +#endif + - char *comname; - static void usage(FILE *stream); ++static unsigned char itoa64[] = /* 0 ... 63 => ascii - 64 */ ++ "./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"; ++ + + const char *progname; + + static void usage(void); ++static void to64(char *s, long v, int n); static void read_pwd_file(char *filename); static void write_pwd_file(char *filename, char *bkname); --static void encrypt_pwd(char key[9], char salt[3], char passwd[14]); -+static void encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]); + static void encrypt_pwd(char key[CLEAR_PASSWD_LEN + 1], +- char salt[3], ++ char salt[SALT_LEN], + char passwd[CRYPTED_PASSWD_LEN + 1]); static void prompt_for_username(char *username); static void prompt_for_password(char *prompt, char *password); - -@@ -150,7 +154,7 @@ - - if (q != NULL) - *(q++) = '\0'; -- if (strlen(p) != 13) -+ if (strlen(p) > _PASSWORD_LEN) - { - fprintf(stderr, "WARNING: %s: line %d: illegal password length.\n", - filename, npwds + 1); -@@ -214,7 +218,7 @@ +@@ -47,6 +66,15 @@ + printf("Report bugs to <pgsql-bugs@postgresql.org>.\n"); } - static void --encrypt_pwd(char key[9], char salt[3], char passwd[14]) -+encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]) ++static void ++to64(char *s, long v, int n) ++{ ++ while (--n >= 0) { ++ *s++ = itoa64[v&0x3f]; ++ v >>= 6; ++ } ++} ++ + typedef struct { - int n; + char *uname; +@@ -154,7 +182,7 @@ + if (q != NULL) + *(q++) = '\0'; -@@ -246,9 +250,9 @@ +- if (strlen(p) != CRYPTED_PASSWD_LEN && strcmp(p, "+") != 0) ++ if (strlen(p) > CRYPTED_PASSWD_LEN && strcmp(p, "+") != 0) + { + fprintf(stderr, "%s:%d: warning: invalid password length\n", + filename, npwds + 1); +@@ -221,15 +249,25 @@ - #ifdef NOT_USED - static int --check_pwd(char key[9], char passwd[14]) -+check_pwd(char key[9], char passwd[_PASSWORD_LEN+1]) + static void + encrypt_pwd(char key[CLEAR_PASSWD_LEN + 1], +- char salt[3], ++ char salt[SALT_LEN], + char passwd[CRYPTED_PASSWD_LEN + 1]) { -- char shouldbe[14]; -+ char shouldbe[_PASSWORD_LEN+1]; - char salt[3]; - - salt[0] = passwd[0]; -@@ -256,7 +260,7 @@ - salt[2] = '\0'; - encrypt_pwd(key, salt, shouldbe); - -- return strncmp(shouldbe, passwd, 13) == 0 ? 1 : 0; -+ return strncmp(shouldbe, passwd, _PASSWORD_LEN) == 0 ? 1 : 0; - } - - #endif -@@ -332,7 +336,7 @@ - char salt[3]; - char key[9], - key2[9]; -- char e_passwd[14]; -+ char e_passwd[_PASSWORD_LEN+1]; - int i; ++#if !defined(__FreeBSD__) + int n; +- ++#endif + /* select a salt, if not already given */ + if (salt[0] == '\0') + { ++#if defined(__FreeBSD__) ++ struct timeval tv; ++ srandomdev(); ++ gettimeofday(&tv,0); ++ to64(&salt[0], random(), 3); ++ to64(&salt[3], tv.tv_usec, 3); ++ to64(&salt[6], tv.tv_sec, 2); ++ salt[8] = '\0'; + srand(time(NULL)); ++#else + do + { + n = rand() % 256; +@@ -241,6 +279,7 @@ + } while (!issaltchar(n)); + salt[1] = n; + salt[2] = '\0'; ++#endif + } - comname = argv[0]; + /* get encrypted password */ +@@ -335,7 +374,7 @@ + char *filename; + char bkname[MAXPGPATH]; + char username[NAMEDATALEN]; +- char salt[3]; ++ char salt[SALT_LEN]; + char key[CLEAR_PASSWD_LEN + 1], + key2[CLEAR_PASSWD_LEN + 1]; + char e_passwd[CRYPTED_PASSWD_LEN + 1]; diff --git a/databases/postgresql84-server/files/patch-ar b/databases/postgresql84-server/files/patch-ar deleted file mode 100644 index c5c8096fc141..000000000000 --- a/databases/postgresql84-server/files/patch-ar +++ /dev/null @@ -1,11 +0,0 @@ ---- configure.orig Sun Oct 10 14:37:07 1999 -+++ configure Sun Oct 10 14:37:29 1999 -@@ -1429,7 +1429,7 @@ - ELF_SYS=true - else - rm -rf conftest* -- if test "X$elf" = "Xyes" -+ if test "X$PORTOBJFORMAT" = "Xelf" - then - ELF_SYS=true - else diff --git a/databases/postgresql84-server/files/patch-as b/databases/postgresql84-server/files/patch-as deleted file mode 100644 index 3282168c4aed..000000000000 --- a/databases/postgresql84-server/files/patch-as +++ /dev/null @@ -1,11 +0,0 @@ ---- Makefile.global.in.orig Sun Dec 6 00:08:56 1998 -+++ Makefile.global.in Sat Feb 27 04:23:12 1999 -@@ -79,7 +79,7 @@ - POSTMANDIR= $(POSTGRESDIR)/man - - # Where the formatted documents (e.g., the reference manual) get installed. --POSTDOCDIR= $(POSTGRESDIR)/doc -+POSTDOCDIR= !!PREFIX!!/share/doc/pgsql - - # Where the header files necessary to build frontend programs get installed. - HEADERDIR= $(POSTGRESDIR)/include diff --git a/databases/postgresql84-server/files/patch-at b/databases/postgresql84-server/files/patch-at deleted file mode 100644 index 93e68a708211..000000000000 --- a/databases/postgresql84-server/files/patch-at +++ /dev/null @@ -1,11 +0,0 @@ ---- ../doc/Makefile.orig Sun Nov 29 06:30:13 1998 -+++ ../doc/Makefile Mon Jun 21 17:00:13 1999 -@@ -12,7 +12,7 @@ - # - #---------------------------------------------------------------------------- - --PGDOCS= $(POSTGRESDIR)/doc -+PGDOCS= $(POSTDOCDIR) - SRCDIR= ../src - - TAR= tar diff --git a/databases/postgresql84-server/files/patch-au b/databases/postgresql84-server/files/patch-au deleted file mode 100644 index 340521b49482..000000000000 --- a/databases/postgresql84-server/files/patch-au +++ /dev/null @@ -1,58 +0,0 @@ ---- configure.in.orig Sun Nov 5 05:03:47 2000 -+++ configure.in Mon Dec 4 02:36:15 2000 -@@ -299,13 +299,28 @@ - [ --with-tcl build Tcl interfaces and pgtclsh ], - [ - case "$withval" in -- y | ye | yes) USE_TCL=true; USE_TK=true; AC_MSG_RESULT(enabled) ;; -+ y | ye | yes) USE_TCL=true; AC_MSG_RESULT(enabled) ;; - *) USE_TCL=; USE_TK=; AC_MSG_RESULT(disabled) ;; - esac - ], - [ USE_TCL=; USE_TK=; AC_MSG_RESULT(disabled) ] - ) - -+dnl We include tk support with tcl unless user says --without-tk -+if test USE_TCL = true -+then -+AC_MSG_CHECKING(setting USE_TK) -+AC_ARG_WITH( -+ tk, -+ [ --without-tk build Tcl *without* Tk ], -+ [ -+ case "$withval" in -+ y | ye | yes) USE_TK=true; USE_TK=true; AC_MSG_RESULT(enabled) ;; -+ *) USE_TK=n; AC_MSG_RESULT(disabled) ;; -+ esac -+ ] -+) -+fi - export USE_TCL - export USE_TK - -@@ -482,7 +497,7 @@ - #endif - ], - ELF_SYS=true, --[if test "X$elf" = "Xyes" -+[if test "X$PORTOBJFORMAT" = "Xyes" - then - ELF_SYS=true - else -@@ -1248,10 +1263,15 @@ - else - AC_MSG_RESULT($TCL_CONFIG_SH) - AC_SUBST(TCL_CONFIG_SH) -+ . ${TCL_CONFIG_SH} -+ AC_SUBST(TCL_LIB_SPEC) - fi - fi - --USE_TK=$USE_TCL # If TCL is disabled, disable TK -+USE_TK=${USE_TK:=$USE_TCL} # If TCL is disabled, disable TK -+ # otherwise -- enable unless explicitly -+ # disabled -+ - - dnl Check for Tk configuration script tkConfig.sh - if test "$USE_TK" = true diff --git a/databases/postgresql84-server/files/patch-av b/databases/postgresql84-server/files/patch-av deleted file mode 100644 index 49b35f9e8dc1..000000000000 --- a/databases/postgresql84-server/files/patch-av +++ /dev/null @@ -1,17 +0,0 @@ ---- interfaces/libpq/fe-connect.c Sun May 21 17:19:53 2000 -+++ interfaces/libpq/fe-connect.c Fri Sep 15 13:53:52 2000 -@@ -801 +801 @@ -- sprintf(conn->errorMessage, -+ printfPQExpBuffer(&conn->errorMessage, -@@ -809 +809 @@ -- sprintf(conn->errorMessage, "PQconnectDB() -- couldn't read postmaster response: errno=%d\n%s\n", -+ printfPQExpBuffer(&conn->errorMessage, "PQconnectDB() -- couldn't read postmaster response: errno=%d\n%s\n", -@@ -822 +822 @@ -- sprintf(conn->errorMessage, -+ printfPQExpBuffer(&conn->errorMessage, -@@ -832 +832 @@ -- sprintf(conn->errorMessage, -+ printfPQExpBuffer(&conn->errorMessage, -@@ -850 +850 @@ -- strcpy(conn->errorMessage, -+ printfPQExpBuffer(&conn->errorMessage, diff --git a/databases/postgresql84-server/files/patch-ba b/databases/postgresql84-server/files/patch-ba deleted file mode 100644 index 586d725c536a..000000000000 --- a/databases/postgresql84-server/files/patch-ba +++ /dev/null @@ -1,17 +0,0 @@ ---- interfaces/jdbc/Makefile.orig Sun Nov 5 05:03:53 2000 -+++ interfaces/jdbc/Makefile Fri Dec 8 03:16:17 2000 -@@ -10,10 +10,10 @@ - - FIND = find - IDL2JAVA = idltojava -fno-cpp -fno-tie --JAR = jar --JAVA = java --JAVAC = javac -g --JAVADOC = javadoc -+JAR = !!JAVA_HOME!!/bin/jar -+JAVA = !!JAVA_HOME!!/bin/java -+JAVAC = !!JAVA_HOME!!/bin/javac -+JAVADOC = !!JAVA_HOME!!/bin/javadoc - RM = rm -f - TOUCH = touch - diff --git a/databases/postgresql84-server/files/patch-bb b/databases/postgresql84-server/files/patch-bb deleted file mode 100644 index ea0f1732dcb0..000000000000 --- a/databases/postgresql84-server/files/patch-bb +++ /dev/null @@ -1,13 +0,0 @@ ---- pl/tcl/Makefile~ Sat Apr 29 19:45:42 2000 -+++ pl/tcl/Makefile Sat May 20 22:42:22 2000 -@@ -71,7 +71,9 @@ - CFLAGS+= $(TCL_SHLIB_CFLAGS) $(TCL_DEFS) - - CFLAGS+= -I$(SRCDIR)/include -I$(SRCDIR)/backend $(PGSQL_INCLUDES) -- -+ -+CFLAGS+= -I$(TCL_INCDIR) -+ - # - # Uncomment the following to enable the unknown command lookup - # on the first of all calls to the call handler. See the doc diff --git a/databases/postgresql84-server/files/patch-bc b/databases/postgresql84-server/files/patch-bc deleted file mode 100644 index ff747fb84a2f..000000000000 --- a/databases/postgresql84-server/files/patch-bc +++ /dev/null @@ -1,5 +0,0 @@ ---- bin/pg_ctl/postmaster.opts.default.sample~ Mon Apr 17 05:45:17 2000 -+++ bin/pg_ctl/postmaster.opts.default.sample Tue May 23 02:46:30 2000 -@@ -1 +1 @@ -- -+-i -o "-F" diff --git a/databases/postgresql84-server/files/patch-bd b/databases/postgresql84-server/files/patch-bd deleted file mode 100644 index 341696bfb087..000000000000 --- a/databases/postgresql84-server/files/patch-bd +++ /dev/null @@ -1,42 +0,0 @@ -Here are the two extra patch files that will allow PostgreSQL to -compile and run on Alpha. The DB is 64-bit capable so really only a few -bits of configuration for FreeBSD were needed. - ---- backend/main/main.c.orig Wed Aug 30 16:05:39 2000 -+++ backend/main/main.c Wed Aug 30 16:06:10 2000 -@@ -14,7 +14,7 @@ - */ - #include <unistd.h> - --#if defined(__alpha__) && !defined(linux) -+#if defined(__alpha__) && !defined(linux) && !defined(__FreeBSD__) - #include <sys/sysinfo.h> - #include "machine/hal_sysinfo.h" - #define ASSEMBLER - - - - - - - ---- include/port/freebsd.h.orig Tue Jul 13 16:12:49 1999 -+++ include/port/freebsd.h Wed Aug 30 21:12:51 2000 -@@ -3,6 +3,12 @@ - #if defined(__i386__) - #define NEED_I386_TAS_ASM - #define HAS_TEST_AND_SET -+typedef unsigned char slock_t; -+#endif -+ -+#if defined (__alpha__) -+#define HAS_TEST_AND_SET -+typedef long int slock_t; - #endif - - #if defined(__sparc__) -@@ -28,4 +34,3 @@ - /* # undef HAS_TEST_AND_SET */ - #endif - --typedef unsigned char slock_t; diff --git a/databases/postgresql84-server/files/patch-be b/databases/postgresql84-server/files/patch-be deleted file mode 100644 index 2f8c3c55566f..000000000000 --- a/databases/postgresql84-server/files/patch-be +++ /dev/null @@ -1,9 +0,0 @@ -This patches let you disable Tk even if you have it installed and -makes sure the TCL-library is added as a dependency for libpgtcl. ---- interfaces/libpgtcl/Makefile.in Tue Mar 7 20:58:36 2000 -+++ interfaces/libpgtcl/Makefile.in Wed Sep 20 08:57:28 2000 -@@ -29,3 +29,3 @@ - --SHLIB_LINK+= $(LIBPQ) -+SHLIB_LINK+= $(LIBPQ) @TCL_LIB_SPEC@ - diff --git a/databases/postgresql84-server/files/patch-contrib-retep-build b/databases/postgresql84-server/files/patch-contrib-retep-build new file mode 100644 index 000000000000..30df3a0e72c9 --- /dev/null +++ b/databases/postgresql84-server/files/patch-contrib-retep-build @@ -0,0 +1,10 @@ +--- contrib/retep/build.xml~ Fri Mar 16 22:50:36 2001 ++++ contrib/retep/build.xml Wed Apr 18 09:24:20 2001 +@@ -38,6 +38,7 @@ + <target name="compile" depends="checks,prepare"> + <javac srcdir="${src}" destdir="${dest}"> + <include name="${package}/**" /> ++ <exclude name="${package}/**" unless="jdk1.2+" /> + </javac> + </target> + diff --git a/databases/postgresql84-server/files/patch-doc-makefile b/databases/postgresql84-server/files/patch-doc-makefile new file mode 100644 index 000000000000..fa27bed2af3f --- /dev/null +++ b/databases/postgresql84-server/files/patch-doc-makefile @@ -0,0 +1,19 @@ +--- doc/Makefile~ Sun Jan 7 03:03:22 2001 ++++ doc/Makefile Wed Apr 18 08:12:30 2001 +@@ -43,10 +43,13 @@ + gzip -d -c man.tar.gz | ( cd $(DESTDIR)$(mandir) && $(TAR) xf - ) + endif + +- + installdirs: +- $(mkinstalldirs) $(DESTDIR)$(mandir) $(DESTDIR)$(docdir)/html +- ++ifdef found_html ++ $(mkinstalldirs) $(DESTDIR)$(docdir)/html ++endif ++ifdef found_man ++ $(mkinstalldirs) $(DESTDIR)$(mandir) ++endif + + uninstall: + ifdef found_html diff --git a/databases/postgresql84-server/files/patch-jdbc-build-xml b/databases/postgresql84-server/files/patch-jdbc-build-xml new file mode 100644 index 000000000000..b1c703a9c978 --- /dev/null +++ b/databases/postgresql84-server/files/patch-jdbc-build-xml @@ -0,0 +1,10 @@ +--- src/interfaces/jdbc/build.xml~ Fri Mar 16 22:50:43 2001 ++++ src/interfaces/jdbc/build.xml Wed Apr 18 08:57:57 2001 +@@ -120,6 +120,7 @@ + <javac srcdir="${src}" destdir="${dest}"> + <include name="example/**" /> + <exclude name="example/corba/**"/> ++ <exclude name="example/blobtest.java" unless="jdk1.2+"/> + </javac> + </target> + diff --git a/databases/postgresql84-server/files/patch-jdbc1-statement b/databases/postgresql84-server/files/patch-jdbc1-statement new file mode 100644 index 000000000000..41a9a2971f5a --- /dev/null +++ b/databases/postgresql84-server/files/patch-jdbc1-statement @@ -0,0 +1,13 @@ +--- src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java~ Fri Feb 23 19:12:23 2001 ++++ src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java Wed Apr 18 08:51:03 2001 +@@ -288,8 +288,8 @@ + */ + public java.sql.ResultSet getResultSet() throws SQLException + { +- if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet()) +- return result; ++ if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet()) ++ return result; + return null; + } + diff --git a/databases/postgresql84-server/files/pgsql.sh.tmpl b/databases/postgresql84-server/files/pgsql.sh.tmpl index 753e0b8aaf80..e775aab1d5fd 100644 --- a/databases/postgresql84-server/files/pgsql.sh.tmpl +++ b/databases/postgresql84-server/files/pgsql.sh.tmpl @@ -2,28 +2,29 @@ # $FreeBSD$ # -# For postmaster startup options, edit $PGDATA/postmaster.opts.default -# Preinstalled options are -i -o "-F" +# For postmaster startup options, edit $PGDATA/postgresql.conf + +PGBIN=%%PREFIX%%/%%PG_PREFIX%%bin case $1 in start) - [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib - [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && { + [ -d %%PREFIX%%/%%PG_PREFIX%%lib ] && /sbin/ldconfig -m %%PREFIX%%/%%PG_PREFIX%%lib + [ -x ${PGBIN}/pg_ctl ] && { su -l pgsql -c \ - 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w start > !!PREFIX!!/pgsql/errlog 2>&1' + 'exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl start -w -l ~pgsql/errlog' echo -n ' pgsql' } ;; stop) - [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && { - exec su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w -m fast stop' + [ -x ${PGBIN}/pg_ctl ] && { + exec su -l pgsql -c 'exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl stop -m fast' } ;; status) - [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && { - exec su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl status' + [ -x ${PGBIN}/pg_ctl ] && { + exec su -l pgsql -c 'exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl status' } ;; diff --git a/databases/postgresql84-server/files/post-install-notes b/databases/postgresql84-server/files/post-install-notes index f77271d85113..6b7192b31895 100644 --- a/databases/postgresql84-server/files/post-install-notes +++ b/databases/postgresql84-server/files/post-install-notes @@ -15,5 +15,8 @@ operations. You do NOT need to install the pgaccess port separately. If you built in the TCL support, you can load the Pg package into your TCL scripts as easily as ``package require Pgtcl''. -To start PostgreSQL, run the startup script: -%%PREFIX%%/etc/rc.d/010.pgsql.sh start +If you built with Java support, add +/usr/local/share/java/classes/postgresql.jar to your classpath. + +If you have many tables and many clients running, consider raising +kern.maxfiles using sysctl(8). diff --git a/databases/postgresql84-server/files/pre-install-notes b/databases/postgresql84-server/files/pre-install-notes index 72388933bd6d..697ce3cedb79 100644 --- a/databases/postgresql84-server/files/pre-install-notes +++ b/databases/postgresql84-server/files/pre-install-notes @@ -1,9 +1,21 @@ -# ---------------------------------------------------------------- -# UPGRADE NOTE! Depending on which version you are upgrading from, -# you may have to dump/restore existing databases -# as part of the update. -# This is *NOT* done by this port! -# For detailed instructions, see -# %%WRKDIR%%/%%DISTNAME%%/INSTALL -# after extraction. -# -------------------------------------------------------------- + * IMPORTANT UPGRADE NOTICE * IMPORTANT UPGRADE NOTICE * + +The PostgreSQL port now obeys hier(7) by default, which means that it +installs into: + +%%PREFIX%%/bin +%%PREFIX%%/lib +%%PREFIX%%/include/pgsql + +You *must* move away your old installation to avoid problems with +ldconfig(8) and user's PATH:s. If you rather install using the +old-fashion layout, cancel at next screen and run make as: + +$ make -DWITH_OLD_LAYOUT + +As always, you *must* dump existing databases before stopping and +removing your old postgresql, as part of the update. This is *NOT* +done by this port! + +If you want JAVA support, I will try to determine your JAVA_HOME using +javavmwrapper. If you want a different JVM, please set JAVA_HOME. |