diff options
author | Rene Ladan <rene@FreeBSD.org> | 2021-06-13 12:49:56 +0200 |
---|---|---|
committer | Rene Ladan <rene@FreeBSD.org> | 2021-06-13 12:50:22 +0200 |
commit | a3da90c5e4f183d6a61b55ac6da01974ab575ed1 (patch) | |
tree | b702fc818fde9e4eae5905753539de9c401f8cb5 /databases/postgresql95-server/files | |
parent | databases/postgresql-plv8js: bump postgres version. (diff) |
*/*: Remove expired ports:
2021-06-13 databases/postgresql95-client: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-contrib: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-docs: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-pgtcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plperl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-plpython: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-pltcl: PostgreSQL-9.5 has reached end-of-life
2021-06-13 databases/postgresql95-server: PostgreSQL-9.5 has reached end-of-life
databases/pg_reorg: abandonware only for PostgreSQL 9.5
databases/pgespresso: functionality part of PostgreSQL 9.6 and later
Diffstat (limited to 'databases/postgresql95-server/files')
17 files changed, 0 insertions, 785 deletions
diff --git a/databases/postgresql95-server/files/502.pgsql.in b/databases/postgresql95-server/files/502.pgsql.in deleted file mode 100644 index b1416697fa45..000000000000 --- a/databases/postgresql95-server/files/502.pgsql.in +++ /dev/null @@ -1,114 +0,0 @@ -#!/bin/sh - -# Maintenance shell script to vacuum and backup database -# Put this in /usr/local/etc/periodic/daily, and it will be run -# every night -# -# Written by Palle Girgensohn <girgen@pingpong.net> -# -# In public domain, do what you like with it, -# and use it at your own risk... :) -# - -# Define these variables in either /etc/periodic.conf or -# /etc/periodic.conf.local to override the default values. -# -# daily_pgsql_backup_enable="YES" # do backup of all databases -# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases -# daily_pgsql_vacuum_enable="YES" # do vacuum - -# If there is a global system configuration file, suck it in. -# -if [ -r /etc/defaults/periodic.conf ] -then - . /etc/defaults/periodic.conf - source_periodic_confs -fi - -: ${daily_pgsql_user:="%%PG_USER%%"} -: ${daily_pgsql_port:=5432} -: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} -: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} -: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} -: ${daily_pgsql_savedays:="7"} - -# allow '~´ in dir name -eval backupdir=${daily_pgsql_backupdir} - -rc=0 - -pgsql_backup() { - # daily_pgsql_backupdir must be writeable by user %%PG_USER%% - # ~%%PG_USER%% is just that under normal circumstances, - # but this might not be where you want the backups... - if [ ! -d ${backupdir} ] ; then - echo Creating ${backupdir} - mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir} - fi - - echo - echo "PostgreSQL backups" - - # Protect the data - umask 077 - rc=$? - now=`date "+%Y-%m-%dT%H:%M:%S"` - file=${daily_pgsql_backupdir}/pgglobals_${now} - su -l ${daily_pgsql_user} -c \ - "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" - - db=$1 - while shift; do - echo -n " $db" - file=${backupdir}/pgdump_${db}_${now} - su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" - [ $? -gt 0 ] && rc=3 - db=$1 - done - - if [ $rc -gt 0 ]; then - echo - echo "Errors were reported during backup." - fi - - # cleaning up old data - find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \ - -a -mtime +${daily_pgsql_savedays} -delete - echo -} - -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` - pgsql_backup $dbnames - ;; - - [Nn][Oo]) - ;; - - "") - ;; - - *) - pgsql_backup $daily_pgsql_backup_enable - ;; -esac - -case "$daily_pgsql_vacuum_enable" in - [Yy][Ee][Ss]) - - echo - echo "PostgreSQL vacuum" - su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" - if [ $? -gt 0 ] - then - echo - echo "Errors were reported during vacuum." - rc=3 - fi - ;; -esac - -exit $rc diff --git a/databases/postgresql95-server/files/dot.cshrc.in b/databases/postgresql95-server/files/dot.cshrc.in deleted file mode 100644 index 4069398b376e..000000000000 --- a/databases/postgresql95-server/files/dot.cshrc.in +++ /dev/null @@ -1,11 +0,0 @@ -setenv PGLIB %%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/postgresql95-server/files/dot.profile.in b/databases/postgresql95-server/files/dot.profile.in deleted file mode 100644 index 954e22eae8f8..000000000000 --- a/databases/postgresql95-server/files/dot.profile.in +++ /dev/null @@ -1,22 +0,0 @@ -PGLIB=%%PREFIX%%/lib - -# note: PGDATA can be overridden by the -D startup option -PGDATA=${HOME}/data - -export PATH PGLIB PGDATA - -# if you use the periodic script from share/postgresql/502.pgsql, you -# can set these -#PGDUMP_ARGS="-b -F c" -#PGBACKUPDIR=${HOME}/backups -#PGBACKUP_SAVE_DAYS=7 -#export PGBACKUPDIR PGDUMP_ARGS PGBACKUP_SAVE_DAYS - -#You might want to set some locale stuff here -#PGDATESTYLE=ISO -#LC_ALL=sv_SE.ISO_8859-1 -#export PGDATESTYLE LC_ALL - -# if you want to make regression tests use this TZ -#TZ=PST8PDT -#export TZ diff --git a/databases/postgresql95-server/files/patch-doc-Makefile b/databases/postgresql95-server/files/patch-doc-Makefile deleted file mode 100644 index d5176bfb64b5..000000000000 --- a/databases/postgresql95-server/files/patch-doc-Makefile +++ /dev/null @@ -1,9 +0,0 @@ ---- doc/Makefile.orig 2015-10-08 21:45:57.360084007 +0200 -+++ doc/Makefile 2015-10-08 21:46:04.353084097 +0200 -@@ -12,5 +12,5 @@ - top_builddir = .. - include $(top_builddir)/src/Makefile.global - --all distprep html man install installdirs uninstall clean distclean maintainer-clean: -+all distprep man install installdirs uninstall clean distclean maintainer-clean: - $(MAKE) -C src $@ diff --git a/databases/postgresql95-server/files/patch-doc-src-sgml-Makefile b/databases/postgresql95-server/files/patch-doc-src-sgml-Makefile deleted file mode 100644 index 6e9522b1e45a..000000000000 --- a/databases/postgresql95-server/files/patch-doc-src-sgml-Makefile +++ /dev/null @@ -1,46 +0,0 @@ ---- doc/src/sgml/Makefile.orig 2015-10-05 21:09:44.000000000 +0200 -+++ doc/src/sgml/Makefile 2015-10-09 01:02:37.164797000 +0200 -@@ -15,7 +15,7 @@ - - # Make "html" the default target, since that is what most people tend - # to want to use. --html: -+man: - - NO_TEMP_INSTALL=yes - -@@ -24,7 +24,7 @@ - include $(top_builddir)/src/Makefile.global - - --all: html man -+all: man - - distprep: html distprep-man - -@@ -81,8 +81,6 @@ - ## Man pages - ## - --man distprep-man: man-stamp -- - man-stamp: stylesheet-man.xsl postgres.xml - $(XMLLINT) --noout --valid postgres.xml - $(XSLTPROC) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $^ -@@ -326,14 +324,14 @@ - ## Install - ## - --install: install-html -+install: install-man - - ifneq ($(PORTNAME), sco) - install: install-man - endif - - installdirs: -- $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) -+ $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) - - # If the install used a man directory shared with other applications, this will remove all files. - uninstall: diff --git a/databases/postgresql95-server/files/patch-icu68 b/databases/postgresql95-server/files/patch-icu68 deleted file mode 100644 index 90cd386d9480..000000000000 --- a/databases/postgresql95-server/files/patch-icu68 +++ /dev/null @@ -1,278 +0,0 @@ -Regressed by https://github.com/unicode-org/icu/commit/c3fe7e09d844 - -dbcommands.c:770:1: error: conflicting types for 'dropdb' -dropdb(const char *dbname, bool missing_ok) -^ -../../../src/include/commands/dbcommands.h:23:13: note: previous declaration is here -extern void dropdb(const char *dbname, bool missing_ok); - ^ -dbcommands.c:1367:1: error: conflicting types for 'AlterDatabase' -AlterDatabase(AlterDatabaseStmt *stmt, bool isTopLevel) -^ -../../../src/include/commands/dbcommands.h:25:12: note: previous declaration is here -extern Oid AlterDatabase(AlterDatabaseStmt *stmt, bool isTopLevel); - ^ -dbcommands.c:1977:1: error: conflicting types for 'get_database_oid' -get_database_oid(const char *dbname, bool missing_ok) -^ -../../../src/include/commands/dbcommands.h:29:12: note: previous declaration is here -extern Oid get_database_oid(const char *dbname, bool missingok); - ^ -indxpath.c:2917:1: error: conflicting types for 'relation_has_unique_index_for' -relation_has_unique_index_for(PlannerInfo *root, RelOptInfo *rel, -^ -../../../../src/include/optimizer/paths.h:66:13: note: previous declaration is here -extern bool relation_has_unique_index_for(PlannerInfo *root, RelOptInfo *rel, - ^ -indxpath.c:3091:1: error: conflicting types for 'match_index_to_operand' -match_index_to_operand(Node *operand, -^ -../../../../src/include/optimizer/paths.h:69:13: note: previous declaration is here -extern bool match_index_to_operand(Node *operand, int indexcol, - ^ -indxpath.c:3735:1: error: conflicting types for 'adjust_rowcompare_for_index' -adjust_rowcompare_for_index(RowCompareExpr *clause, -^ -../../../../src/include/optimizer/paths.h:75:14: note: previous declaration is here -extern Expr *adjust_rowcompare_for_index(RowCompareExpr *clause, - ^ -regis.c:31:1: error: conflicting types for 'RS_isRegis' -RS_isRegis(const char *str) -^ -../../../src/include/tsearch/dicts/regis.h:41:7: note: previous declaration is here -bool RS_isRegis(const char *str); - ^ -regis.c:85:1: error: conflicting types for 'RS_compile' -RS_compile(Regis *r, bool issuffix, const char *str) -^ -../../../src/include/tsearch/dicts/regis.h:43:7: note: previous declaration is here -void RS_compile(Regis *r, bool issuffix, const char *str); - ^ -regis.c:218:1: error: conflicting types for 'RS_execute' -RS_execute(Regis *r, char *str) -^ -../../../src/include/tsearch/dicts/regis.h:47:7: note: previous declaration is here -bool RS_execute(Regis *r, char *str); - ^ -varlena.c:1845:1: error: conflicting types for 'varstr_sortsupport' -varstr_sortsupport(SortSupport ssup, Oid collid, bool bpchar) -^ -../../../../src/include/utils/builtins.h:849:13: note: previous declaration is here -extern void varstr_sortsupport(SortSupport ssup, Oid collid, bool bpchar); - ^ -varlena.c:3264:1: error: conflicting types for 'SplitIdentifierString' -SplitIdentifierString(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:859:13: note: previous declaration is here -extern bool SplitIdentifierString(char *rawstring, char separator, - ^ -varlena.c:3389:1: error: conflicting types for 'SplitDirectoriesString' -SplitDirectoriesString(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:861:13: note: previous declaration is here -extern bool SplitDirectoriesString(char *rawstring, char separator, - ^ -varlena.c:3510:1: error: conflicting types for 'SplitGUCList' -SplitGUCList(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:863:13: note: previous declaration is here -extern bool SplitGUCList(char *rawstring, char separator, - ^ -varlena.c:4022:1: error: conflicting types for 'replace_text_regexp' -replace_text_regexp(text *src_text, void *regexp, -^ -../../../../src/include/utils/builtins.h:866:14: note: previous declaration is here -extern text *replace_text_regexp(text *src_text, void *regexp, - ^ -In file included from varlena.c:5586: -./levenshtein.c:73:1: error: conflicting types for 'varstr_levenshtein' -varstr_levenshtein(const char *source, int slen, -^ -../../../../src/include/utils/builtins.h:850:12: note: previous declaration is here -extern int varstr_levenshtein(const char *source, int slen, - ^ -In file included from varlena.c:5588: -./levenshtein.c:68:1: error: conflicting types for 'varstr_levenshtein_less_equal' -varstr_levenshtein_less_equal(const char *source, int slen, -^ -../../../../src/include/utils/builtins.h:854:12: note: previous declaration is here -extern int varstr_levenshtein_less_equal(const char *source, int slen, - ^ -guc.c:408:7: error: redefinition of 'log_duration' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_duration = false; - ^ -../../../../src/include/utils/guc.h:233:13: note: previous declaration is here -extern bool log_duration; - ^ -guc.c:409:7: error: redefinition of 'Debug_print_plan' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_plan = false; - ^ -../../../../src/include/utils/guc.h:234:13: note: previous declaration is here -extern bool Debug_print_plan; - ^ -guc.c:410:7: error: redefinition of 'Debug_print_parse' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_parse = false; - ^ -../../../../src/include/utils/guc.h:235:13: note: previous declaration is here -extern bool Debug_print_parse; - ^ -guc.c:411:7: error: redefinition of 'Debug_print_rewritten' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_rewritten = false; - ^ -../../../../src/include/utils/guc.h:236:13: note: previous declaration is here -extern bool Debug_print_rewritten; - ^ -guc.c:412:7: error: redefinition of 'Debug_pretty_print' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_pretty_print = true; - ^ -../../../../src/include/utils/guc.h:237:13: note: previous declaration is here -extern bool Debug_pretty_print; - ^ -guc.c:414:7: error: redefinition of 'log_parser_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_parser_stats = false; - ^ -../../../../src/include/utils/guc.h:239:13: note: previous declaration is here -extern bool log_parser_stats; - ^ -guc.c:415:7: error: redefinition of 'log_planner_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_planner_stats = false; - ^ -../../../../src/include/utils/guc.h:240:13: note: previous declaration is here -extern bool log_planner_stats; - ^ -guc.c:416:7: error: redefinition of 'log_executor_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_executor_stats = false; - ^ -../../../../src/include/utils/guc.h:241:13: note: previous declaration is here -extern bool log_executor_stats; - ^ -guc.c:417:7: error: redefinition of 'log_statement_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_statement_stats = false; /* this is sort of all three - ^ -../../../../src/include/utils/guc.h:242:13: note: previous declaration is here -extern bool log_statement_stats; - ^ -guc.c:419:7: error: redefinition of 'log_btree_build_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_btree_build_stats = false; - ^ -../../../../src/include/utils/guc.h:243:13: note: previous declaration is here -extern bool log_btree_build_stats; - ^ -guc.c:423:7: error: redefinition of 'check_function_bodies' with a different type: 'bool' vs 'bool' (aka 'char') -bool check_function_bodies = true; - ^ -../../../../src/include/utils/guc.h:245:25: note: previous declaration is here -extern PGDLLIMPORT bool check_function_bodies; - ^ -guc.c:424:7: error: redefinition of 'default_with_oids' with a different type: 'bool' vs 'bool' (aka 'char') -bool default_with_oids = false; - ^ -../../../../src/include/utils/guc.h:246:13: note: previous declaration is here -extern bool default_with_oids; - ^ -guc.c:425:7: error: redefinition of 'SQL_inheritance' with a different type: 'bool' vs 'bool' (aka 'char') -bool SQL_inheritance = true; - ^ -../../../../src/include/utils/guc.h:247:13: note: previous declaration is here -extern bool SQL_inheritance; - ^ -guc.c:428:7: error: redefinition of 'session_auth_is_superuser' with a different type: 'bool' vs 'bool' (aka 'char') -bool session_auth_is_superuser; - ^ -../../../../src/include/utils/guc.h:248:13: note: previous declaration is here -extern bool session_auth_is_superuser; - ^ -guc.c:4599:1: error: conflicting types for 'SelectConfigFiles' -SelectConfigFiles(const char *userDoption, const char *progname) -^ -../../../../src/include/utils/guc.h:355:13: note: previous declaration is here -extern bool SelectConfigFiles(const char *userDoption, const char *progname); - ^ -guc.c:4989:1: error: conflicting types for 'AtEOXact_GUC' -AtEOXact_GUC(bool isCommit, int nestLevel) -^ -../../../../src/include/utils/guc.h:359:13: note: previous declaration is here -extern void AtEOXact_GUC(bool isCommit, int nestLevel); - ^ -guc.c:5407:1: error: conflicting types for 'parse_int' -parse_int(const char *value, int *result, int flags, const char **hintmsg) -^ -../../../../src/include/utils/guc.h:362:13: note: previous declaration is here -extern bool parse_int(const char *value, int *result, int flags, - ^ -guc.c:5493:1: error: conflicting types for 'parse_real' -parse_real(const char *value, double *result) -^ -../../../../src/include/utils/guc.h:364:13: note: previous declaration is here -extern bool parse_real(const char *value, double *result); - ^ -guc.c:5554:1: error: conflicting types for 'config_enum_lookup_by_name' -config_enum_lookup_by_name(struct config_enum * record, const char *value, -^ -../../../../src/include/utils/guc_tables.h:264:13: note: previous declaration is here -extern bool config_enum_lookup_by_name(struct config_enum * record, - ^ -fatal error: too many errors emitted, stopping now [-ferror-limit=] - ---- src/backend/commands/dbcommands.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/commands/dbcommands.c -@@ -19,6 +19,7 @@ - */ - #include "postgres.h" - -+#include <stdbool.h> - #include <fcntl.h> - #include <locale.h> - #include <unistd.h> ---- src/backend/optimizer/path/indxpath.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/optimizer/path/indxpath.c -@@ -15,6 +15,7 @@ - */ - #include "postgres.h" - -+#include <stdbool.h> - #include <math.h> - - #include "access/stratnum.h" ---- src/backend/tsearch/regis.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/tsearch/regis.c -@@ -14,6 +14,8 @@ - - #include "postgres.h" - -+#include <stdbool.h> -+ - #include "tsearch/dicts/regis.h" - #include "tsearch/ts_locale.h" - ---- src/backend/utils/adt/levenshtein.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/adt/levenshtein.c -@@ -23,6 +23,8 @@ - * - *------------------------------------------------------------------------- - */ -+#include <stdbool.h> -+ - #define MAX_LEVENSHTEIN_STRLEN 255 - - /* ---- src/backend/utils/adt/varlena.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/adt/varlena.c -@@ -14,6 +14,7 @@ - */ - #include "postgres.h" - -+#include <stdbool.h> - #include <ctype.h> - #include <limits.h> - ---- src/backend/utils/misc/guc.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/misc/guc.c -@@ -16,6 +16,7 @@ - */ - #include "postgres.h" - -+#include <stdbool.h> - #include <ctype.h> - #include <float.h> - #include <math.h> diff --git a/databases/postgresql95-server/files/patch-src-Makefile.shlib b/databases/postgresql95-server/files/patch-src-Makefile.shlib deleted file mode 100644 index 2435ffe1d280..000000000000 --- a/databases/postgresql95-server/files/patch-src-Makefile.shlib +++ /dev/null @@ -1,11 +0,0 @@ ---- src/Makefile.shlib.bak 2013-05-06 22:57:06.000000000 +0200 -+++ src/Makefile.shlib 2013-05-12 23:33:16.000000000 +0200 -@@ -87,7 +87,7 @@ - # Testing the soname variable is a reliable way to determine whether a - # linkable library is being built. - soname = $(shlib_major) --pkgconfigdir = $(libdir)/pkgconfig -+pkgconfigdir = $(prefix)/libdata/pkgconfig - else - # Naming convention for dynamically loadable modules - shlib = $(NAME)$(DLSUFFIX) diff --git a/databases/postgresql95-server/files/patch-src-backend-Makefile b/databases/postgresql95-server/files/patch-src-backend-Makefile deleted file mode 100644 index 6d6fb0ce660b..000000000000 --- a/databases/postgresql95-server/files/patch-src-backend-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/backend/Makefile.orig 2009-07-07 15:58:33.000000000 +0200 -+++ src/backend/Makefile 2009-07-07 15:58:57.000000000 +0200 -@@ -107,6 +107,8 @@ - # Update the commonly used headers before building the subdirectories - $(SUBDIRS:%=%-recursive): $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h - -+symlinks: $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h -+ - - # The postgres.o target is needed by the rule in Makefile.global that - # creates the exports file when MAKE_EXPORTS = true. diff --git a/databases/postgresql95-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql95-server/files/patch-src_backend_utils_misc_postgresql.conf.sample deleted file mode 100644 index 9c21590f11fe..000000000000 --- a/databases/postgresql95-server/files/patch-src_backend_utils_misc_postgresql.conf.sample +++ /dev/null @@ -1,21 +0,0 @@ ---- src/backend/utils/misc/postgresql.conf.sample.orig 2015-10-05 21:09:44.000000000 +0200 -+++ src/backend/utils/misc/postgresql.conf.sample 2015-10-08 21:51:37.862060431 +0200 -@@ -318,6 +318,7 @@ - - # - Where to Log - - -+log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of - # stderr, csvlog, syslog, and eventlog, - # depending on platform. csvlog -@@ -449,7 +450,9 @@ - - #cluster_name = '' # added to process titles if nonempty - # (change requires restart) --#update_process_title = on -+ -+# On FreeBSD, this is a performance hog, so keep it off if you need speed -+update_process_title = off - - - #------------------------------------------------------------------------------ diff --git a/databases/postgresql95-server/files/pkg-message-client.in b/databases/postgresql95-server/files/pkg-message-client.in deleted file mode 100644 index 8cc91d484fcb..000000000000 --- a/databases/postgresql95-server/files/pkg-message-client.in +++ /dev/null @@ -1,38 +0,0 @@ -[ -{ type: install - message: <<EOM -The PostgreSQL port has a collection of "side orders": - -postgresql-docs - For all of the html documentation - -p5-Pg - A perl5 API for client access to PostgreSQL databases. - -postgresql-tcltk - If you want tcl/tk client support. - -postgresql-jdbc - For Java JDBC support. - -postgresql-odbc - For client access from unix applications using ODBC as access - method. Not needed to access unix PostgreSQL servers from Win32 - using ODBC. See below. - -ruby-postgres, py-psycopg2 - For client access to PostgreSQL databases using the ruby & python - languages. - -postgresql-plperl, postgresql-pltcl & postgresql-plruby - For using perl5, tcl & ruby as procedural languages. - -postgresql-contrib - Lots of contributed utilities, postgresql functions and - datatypes. There you find pg_standby, pgcrypto and many other cool - things. - -etc... -EOM -} -] diff --git a/databases/postgresql95-server/files/pkg-message-contrib.in b/databases/postgresql95-server/files/pkg-message-contrib.in deleted file mode 100644 index 2d9f3d86e71c..000000000000 --- a/databases/postgresql95-server/files/pkg-message-contrib.in +++ /dev/null @@ -1,9 +0,0 @@ -[ -{ type: install - message: <<EOM -The PostgreSQL contrib utilities have been installed. Please see -%%PREFIX%%/share/doc/postgresql/contrib/README -for more information. -EOM -} -] diff --git a/databases/postgresql95-server/files/pkg-message-plperl.in b/databases/postgresql95-server/files/pkg-message-plperl.in deleted file mode 100644 index dbda7daff5c2..000000000000 --- a/databases/postgresql95-server/files/pkg-message-plperl.in +++ /dev/null @@ -1,9 +0,0 @@ -[ -{ type: install - message: <<EOM -PL/Perl has been installed. Check the createlang(l) manpage for more -info. You can install PL/Perl as trusted or untrusted, by using either -"createlang plperl" or "createlang plperlu". -EOM -} -] diff --git a/databases/postgresql95-server/files/pkg-message-plpython.in b/databases/postgresql95-server/files/pkg-message-plpython.in deleted file mode 100644 index 3bd80d73d177..000000000000 --- a/databases/postgresql95-server/files/pkg-message-plpython.in +++ /dev/null @@ -1,9 +0,0 @@ -[ -{ type: install - message: <<EOM -PL/Python has been installed. Check the createlang(l) manpage for more -info. You can install PL/Python by using "createlang plpythonu" (it -exists as an untrusted language only). -EOM -} -] diff --git a/databases/postgresql95-server/files/pkg-message-pltcl.in b/databases/postgresql95-server/files/pkg-message-pltcl.in deleted file mode 100644 index c1776f7d6fb3..000000000000 --- a/databases/postgresql95-server/files/pkg-message-pltcl.in +++ /dev/null @@ -1,9 +0,0 @@ -[ -{ type: install - message: <<EOM -PL/Tcl has been installed. Check the createlang(l) manpage for more -info. You can install pltcl as trusted or untrusted, by using either -"createlang pltcl" or "createlang pltclu". -EOM -} -] diff --git a/databases/postgresql95-server/files/pkg-message-server.in b/databases/postgresql95-server/files/pkg-message-server.in deleted file mode 100644 index e2407c1d964f..000000000000 --- a/databases/postgresql95-server/files/pkg-message-server.in +++ /dev/null @@ -1,69 +0,0 @@ -[ -{ type: install - message: <<EOM -For procedural languages and postgresql functions, please note that -you might have to update them when updating the server. - -If you have many tables and many clients running, consider raising -kern.maxfiles using sysctl(8), or reconfigure your kernel -appropriately. - -The port is set up to use autovacuum for new databases, but you might -also want to vacuum and perhaps backup your database regularly. There -is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perform vacuum on all -databases nightly. Per default, it performs `vacuum analyze'. See the -script for instructions. For autovacuum settings, please review -~postgres/data/postgresql.conf. - -If you plan to access your PostgreSQL server using ODBC, please -consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql -to get the functions required for ODBC compliance. - -Please note that if you use the rc script, -%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode -(UTF-8) will be used to store character data by default. Set -postgresql_initdb_flags or use login.conf settings described below to -alter this behaviour. See the start rc script for more info. - -To set limits, environment stuff like locale and collation and other -things, you can set up a class in /etc/login.conf before initializing -the database. Add something similar to this to /etc/login.conf: ---- -postgres:\ - :lang=en_US.UTF-8:\ - :setenv=LC_COLLATE=C:\ - :tc=default: ---- -and run `cap_mkdb /etc/login.conf'. -Then add 'postgresql_class="postgres"' to /etc/rc.conf. - -====================================================================== - -To initialize the database, run - - %%PREFIX%%/etc/rc.d/postgresql initdb - -You can then start PostgreSQL by running: - - %%PREFIX%%/etc/rc.d/postgresql start - -For postmaster settings, see ~postgres/data/postgresql.conf - -NB. FreeBSD's PostgreSQL port logs to syslog by default - See ~postgres/data/postgresql.conf for more info - -NB. If you're not using a checksumming filesystem like ZFS, you might - wish to enable data checksumming. It can only be enabled during - the initdb phase, by adding the "--data-checksums" flag to - the postgresql_initdb_flags rcvar. Check the initdb(1) manpage - for more info and make sure you understand the performance - implications. - -====================================================================== - -To run PostgreSQL at startup, add -'postgresql_enable="YES"' to /etc/rc.conf -EOM -} -] diff --git a/databases/postgresql95-server/files/pkgIndex.tcl.in b/databases/postgresql95-server/files/pkgIndex.tcl.in deleted file mode 100644 index bd8329b15c69..000000000000 --- a/databases/postgresql95-server/files/pkgIndex.tcl.in +++ /dev/null @@ -1,4 +0,0 @@ -# Package-index file for Pgtcl-package. Enables you to load PostgreSQL -# interface functions right into you TCL-interpreter as simply as -# package require Pgtcl -package ifneeded Pgtcl 1.3 "load %%PREFIX%%/lib/libpgtcl.so" diff --git a/databases/postgresql95-server/files/postgresql.in b/databases/postgresql95-server/files/postgresql.in deleted file mode 100644 index ee2d3e558405..000000000000 --- a/databases/postgresql95-server/files/postgresql.in +++ /dev/null @@ -1,115 +0,0 @@ -#!/bin/sh - -# PROVIDE: postgresql -# REQUIRE: sshd -# KEYWORD: shutdown -# -# Add the following line to /etc/rc.conf to enable PostgreSQL: -# -# postgresql_enable="YES" -# # optional -# postgresql_data="%%PREFIX%%/%%PG_USER%%/data" -# postgresql_flags="-w -s -m fast" -# postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" -# postgresql_class="default" -# postgresql_profiles="" -# -# See %%PREFIX%%/share/doc/postgresql/README-server for more info -# -# This scripts takes one of the following commands: -# -# start stop restart reload status initdb -# -# For postmaster startup options, edit ${postgresql_data}/postgresql.conf - -command=%%PREFIX%%/bin/pg_ctl - -. /etc/rc.subr - -load_rc_config postgresql - -# set defaults -postgresql_enable=${postgresql_enable:-"NO"} -postgresql_flags=${postgresql_flags:-"-w -s -m fast"} -postgresql_user=${postgresql_user:-"%%PG_USER%%"} -eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"} -postgresql_class=${postgresql_class:-"default"} -postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"} - -name=postgresql -rcvar=postgresql_enable -extra_commands="reload initdb" - -start_cmd="postgresql_command start" -stop_cmd="postgresql_command stop" -restart_cmd="postgresql_command restart" -reload_cmd="postgresql_command reload" -status_cmd="postgresql_command status" -promote_cmd="postgresql_command promote" - -initdb_cmd="postgresql_initdb" - -su_cmd="/usr/bin/su" - -if [ -n "$2" ]; then - profile="$2" - if [ "x${postgresql_profiles}" != "x" ]; then - eval postgresql_data="\${postgresql_${profile}_data:-}" - if [ "x${postgresql_data}" = "x" ]; then - echo "You must define a data directory (postgresql_${profile}_data)" - exit 1 - fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" - eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" - eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" - fi -else - if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then - for profile in ${postgresql_profiles}; do - eval _enable="\${postgresql_${profile}_enable}" - case "x${_enable:-${postgresql_enable}}" in - x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee]) - continue - ;; - x[Yy][Ee][Ss]) - ;; - *) - if test -z "$_enable"; then - _var=postgresql_enable - else - _var=postgresql_"${profile}"_enable - fi - echo "Bad value" \ - "'${_enable:-${postgresql_enable}}'" \ - "for ${_var}. " \ - "Profile ${profile} skipped." - continue - ;; - esac - echo "===> postgresql profile: ${profile}" - %%PREFIX%%/etc/rc.d/postgresql $1 ${profile} - retcode="$?" - if [ "0${retcode}" -ne 0 ]; then - failed="${profile} (${retcode}) ${failed:-}" - else - success="${profile} ${success:-}" - fi - done - exit 0 - fi -fi - -command_args="-D ${postgresql_data} ${postgresql_flags}" - -postgresql_command() -{ - ${su_cmd} -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" -} - -postgresql_initdb() -{ - ${su_cmd} -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" -} - -run_rc_command "$1" |