Date: Wed, 1 Jan 2025 12:08:19 GMT From: Rene Ladan <rene@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: git: 336f72ee03cc - main - databases/postgresql12-server: Remove expired port Message-ID: <202501011208.501C8Jnq051308@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch main has been updated by rene: URL: https://cgit.FreeBSD.org/ports/commit/?id=336f72ee03cc999303a0ac1e2fa94602fac0917b commit 336f72ee03cc999303a0ac1e2fa94602fac0917b Author: Rene Ladan <rene@FreeBSD.org> AuthorDate: 2025-01-01 12:08:02 +0000 Commit: Rene Ladan <rene@FreeBSD.org> CommitDate: 2025-01-01 12:08:02 +0000 databases/postgresql12-server: Remove expired port 2024-12-31 databases/postgresql12-server: PostgreSQL-12 is end-of-life --- MOVED | 1 + databases/Makefile | 1 - databases/postgresql12-server/Makefile | 27 - databases/postgresql12-server/distinfo | 3 - databases/postgresql12-server/files/502.pgsql.in | 114 -- databases/postgresql12-server/files/dot.cshrc.in | 11 - databases/postgresql12-server/files/dot.profile.in | 22 - .../postgresql12-server/files/patch-doc-Makefile | 9 - .../files/patch-doc-src-sgml-Makefile | 41 - .../files/patch-src-Makefile.shlib | 11 - .../files/patch-src-backend-Makefile | 11 - ...h-src_backend_utils_misc_postgresql.conf.sample | 10 - .../files/pkg-message-client.in | 38 - .../files/pkg-message-contrib.in | 9 - .../files/pkg-message-plperl.in | 9 - .../files/pkg-message-plpython.in | 9 - .../postgresql12-server/files/pkg-message-pltcl.in | 9 - .../files/pkg-message-server.in | 71 - .../postgresql12-server/files/pkgIndex.tcl.in | 4 - databases/postgresql12-server/files/postgresql.in | 123 -- databases/postgresql12-server/pkg-descr | 21 - databases/postgresql12-server/pkg-install-server | 23 - databases/postgresql12-server/pkg-plist-client | 1221 ---------------- databases/postgresql12-server/pkg-plist-contrib | 265 ---- databases/postgresql12-server/pkg-plist-plperl | 22 - databases/postgresql12-server/pkg-plist-plpython | 48 - databases/postgresql12-server/pkg-plist-pltcl | 8 - databases/postgresql12-server/pkg-plist-server | 1541 -------------------- 28 files changed, 1 insertion(+), 3681 deletions(-) diff --git a/MOVED b/MOVED index 31fb124f0cd8..260c7e872544 100644 --- a/MOVED +++ b/MOVED @@ -3830,3 +3830,4 @@ databases/postgresql12-pltcl||2025-01-01|Has expired: PostgreSQL-12 is end-of-li databases/postgresql12-plpython||2025-01-01|Has expired: PostgreSQL-12 is end-of-life databases/postgresql12-docs||2025-01-01|Has expired: PostgreSQL-12 is end-of-life databases/postgresql12-pgtcl||2025-01-01|Removed, PostgreSQL-12 is end-of-life +databases/postgresql12-server||2025-01-01|Has expired: PostgreSQL-12 is end-of-life diff --git a/databases/Makefile b/databases/Makefile index f5e796a27a4d..95adb4e564dc 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -669,7 +669,6 @@ SUBDIR += postgresql-tds_fdw SUBDIR += postgresql-wal2json SUBDIR += postgresql-zhparser - SUBDIR += postgresql12-server SUBDIR += postgresql13-client SUBDIR += postgresql13-contrib SUBDIR += postgresql13-docs diff --git a/databases/postgresql12-server/Makefile b/databases/postgresql12-server/Makefile deleted file mode 100644 index 432fd8a09ccc..000000000000 --- a/databases/postgresql12-server/Makefile +++ /dev/null @@ -1,27 +0,0 @@ -DISTVERSION?= 12.22 -# PORTREVISION must be ?= otherwise, all slave ports get this PORTREVISION and -# not their own. Probably best to keep it at ?=0 when reset here too. -PORTREVISION?= 0 - -MAINTAINER?= pgsql@FreeBSD.org - -DEPRECATED= PostgreSQL-12 is end-of-life -EXPIRATION_DATE=2024-12-31 - -INSTALL_DIRS?= src/common src/timezone src/backend \ - src/backend/utils/mb/conversion_procs \ - src/backend/snowball src/backend/replication/libpqwalreceiver \ - src/backend/replication/pgoutput \ - src/bin/initdb src/bin/pg_ctl \ - src/bin/pg_archivecleanup src/bin/pg_basebackup \ - src/bin/pg_checksums \ - src/bin/pg_controldata src/bin/pg_resetwal src/pl \ - src/bin/pg_rewind \ - src/bin/pg_test_fsync src/bin/pg_test_timing \ - src/bin/pg_waldump src/bin/pg_upgrade - -PG_USER?= postgres -PG_GROUP?= postgres -PG_UID?= 770 - -.include "${.CURDIR}/../postgresql16-server/Makefile" diff --git a/databases/postgresql12-server/distinfo b/databases/postgresql12-server/distinfo deleted file mode 100644 index da4b9fdc31cb..000000000000 --- a/databases/postgresql12-server/distinfo +++ /dev/null @@ -1,3 +0,0 @@ -TIMESTAMP = 1732004002 -SHA256 (postgresql/postgresql-12.22.tar.bz2) = 8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b -SIZE (postgresql/postgresql-12.22.tar.bz2) = 21305304 diff --git a/databases/postgresql12-server/files/502.pgsql.in b/databases/postgresql12-server/files/502.pgsql.in deleted file mode 100644 index 604ad3dadab8..000000000000 --- a/databases/postgresql12-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 directory 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/postgresql12-server/files/dot.cshrc.in b/databases/postgresql12-server/files/dot.cshrc.in deleted file mode 100644 index 17c9ee69a7d0..000000000000 --- a/databases/postgresql12-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/data96 - -#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/postgresql12-server/files/dot.profile.in b/databases/postgresql12-server/files/dot.profile.in deleted file mode 100644 index 5be3e6a36ca9..000000000000 --- a/databases/postgresql12-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}/data96 - -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/postgresql12-server/files/patch-doc-Makefile b/databases/postgresql12-server/files/patch-doc-Makefile deleted file mode 100644 index d5176bfb64b5..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/patch-doc-src-sgml-Makefile b/databases/postgresql12-server/files/patch-doc-src-sgml-Makefile deleted file mode 100644 index 36f5d2a8224c..000000000000 --- a/databases/postgresql12-server/files/patch-doc-src-sgml-Makefile +++ /dev/null @@ -1,41 +0,0 @@ ---- doc/src/sgml/Makefile.orig 2018-10-15 23:12:02.000000000 +0200 -+++ doc/src/sgml/Makefile 2018-10-18 22:34:13.656029000 +0200 -@@ -15,7 +15,7 @@ - - # Make "html" the default target, since that is what most people tend - # to want to use. --html: -+man: - - # We don't need the tree-wide headers or install support here. - NO_GENERATED_HEADERS=yes -@@ -26,7 +26,7 @@ - include $(top_builddir)/src/Makefile.global - - --all: html man -+all: man - - distprep: html distprep-man - -@@ -62,7 +62,6 @@ - ## Man pages - ## - --man distprep-man: man-stamp - - man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML) - $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) -@@ -212,10 +211,10 @@ - ## Install - ## - --install: install-html install-man -+install: install-man - - 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/postgresql12-server/files/patch-src-Makefile.shlib b/databases/postgresql12-server/files/patch-src-Makefile.shlib deleted file mode 100644 index 2435ffe1d280..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/patch-src-backend-Makefile b/databases/postgresql12-server/files/patch-src-backend-Makefile deleted file mode 100644 index ce8a8d558de1..000000000000 --- a/databases/postgresql12-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/storage/lwlocknames.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/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample deleted file mode 100644 index 9469421174a0..000000000000 --- a/databases/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample +++ /dev/null @@ -1,10 +0,0 @@ ---- src/backend/utils/misc/postgresql.conf.sample.orig 2016-10-24 20:08:51 UTC -+++ src/backend/utils/misc/postgresql.conf.sample -@@ -330,6 +330,7 @@ - - # - Where to Log - - -+log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of - # stderr, csvlog, syslog, and eventlog, - # depending on platform. csvlog diff --git a/databases/postgresql12-server/files/pkg-message-client.in b/databases/postgresql12-server/files/pkg-message-client.in deleted file mode 100644 index 404124204b7d..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/pkg-message-contrib.in b/databases/postgresql12-server/files/pkg-message-contrib.in deleted file mode 100644 index 006f700a3ae1..000000000000 --- a/databases/postgresql12-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 -%%DOCSDIR%%/README-contrib -for more information. -EOM -} -] diff --git a/databases/postgresql12-server/files/pkg-message-plperl.in b/databases/postgresql12-server/files/pkg-message-plperl.in deleted file mode 100644 index dbda7daff5c2..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/pkg-message-plpython.in b/databases/postgresql12-server/files/pkg-message-plpython.in deleted file mode 100644 index 3bd80d73d177..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/pkg-message-pltcl.in b/databases/postgresql12-server/files/pkg-message-pltcl.in deleted file mode 100644 index c1776f7d6fb3..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/pkg-message-server.in b/databases/postgresql12-server/files/pkg-message-server.in deleted file mode 100644 index 6370d4a017cc..000000000000 --- a/databases/postgresql12-server/files/pkg-message-server.in +++ /dev/null @@ -1,71 +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 -~%%PG_USER%%/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: ---- -%%PG_USER%%:\ - :lang=en_US.UTF-8:\ - :setenv=LC_COLLATE=C:\ - :tc=default: ---- -and run `cap_mkdb /etc/login.conf'. -Then add 'postgresql_login_class="%%PG_USER%%"' to /etc/rc.conf, or -set it as the %%PG_USER%% user's login class in /etc/passwd. - -====================================================================== - -To use PostgreSQL, enable it in rc.conf using - - sysrc postgresql_enable=yes - -To initialize the database, run - - service postgresql initdb - -You can then start PostgreSQL by running: - - service postgresql start - -For postmaster settings, see ~%%PG_USER%%/data/postgresql.conf - -NB. FreeBSD's PostgreSQL port logs to syslog by default - See ~%%PG_USER%%/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 be enabled during - the initdb phase, by adding the "--data-checksums" flag to - the postgresql_initdb_flags rcvar. Otherwise you can enable it later by - pg_checksums. Check the initdb(1) manpage for more info - and make sure you understand the performance implications. - -====================================================================== -EOM -} -] diff --git a/databases/postgresql12-server/files/pkgIndex.tcl.in b/databases/postgresql12-server/files/pkgIndex.tcl.in deleted file mode 100644 index bd8329b15c69..000000000000 --- a/databases/postgresql12-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/postgresql12-server/files/postgresql.in b/databases/postgresql12-server/files/postgresql.in deleted file mode 100644 index 3cf6475a9a9b..000000000000 --- a/databases/postgresql12-server/files/postgresql.in +++ /dev/null @@ -1,123 +0,0 @@ -#!/bin/sh - -# PROVIDE: postgresql -# REQUIRE: DAEMON mountlate -# KEYWORD: shutdown -# -# Add the following line to /etc/rc.conf to enable PostgreSQL: -# -# postgresql_enable="YES" -# # optional -# postgresql_data="/var/db/%%PG_USER%%/data%%PG_VERSION%%" -# postgresql_flags="-w -s -m fast" -# postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" -# # leave empty to use the login class set in in /etc/passwd: -# postgresql_login_class="my_custom_login_class" -# 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:="NO"} -: ${postgresql_flags:="-w -s -m fast"} -: ${postgresql_user:="%%PG_USER%%"} -eval _pgdir="~${postgresql_user}/data%%PG_VERSION%%" -: ${postgresql_data:="${_pgdir}"} -: ${postgresql_login_class:=""} -: ${postgresql_initdb_flags:="--encoding=utf-8 --lc-collate=C"} -: ${postgresql_svcj_options:="net_basic"} - -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_login_class="\${postgresql_${profile}_login_class:-${postgresql_login_class}}" - 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} ${postgresql_login_class:+-c ${postgresql_login_class}} \ - -l ${postgresql_user} \ - -c "exec ${command} ${command_args} ${rc_arg}" -} - -postgresql_initdb() -{ - ${su_cmd} ${postgresql_login_class:+-c ${postgresql_login_class}} \ - -l ${postgresql_user} \ - -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" -} - -run_rc_command "$1" diff --git a/databases/postgresql12-server/pkg-descr b/databases/postgresql12-server/pkg-descr deleted file mode 100644 index cbef6ffab2d8..000000000000 --- a/databases/postgresql12-server/pkg-descr +++ /dev/null @@ -1,21 +0,0 @@ -PostgreSQL is a sophisticated Object-Relational DBMS, supporting -almost all SQL constructs, including subselects, transactions, and -user-defined types and functions. It is the most advanced open-source -database available anywhere. Commercial Support is also available. - -The original Postgres code was the effort of many graduate students, -undergraduate students, and staff programmers working under the direction of -Professor Michael Stonebraker at the University of California, Berkeley. In -1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query -language to SQL and created a new database system which came to known as -Postgres95. Many others contributed to the porting, testing, debugging and -enhancement of the Postgres95 code. As the code improved, and 1995 faded into -memory, PostgreSQL was born. - -PostgreSQL development is presently being performed by a team of Internet -developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). -Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.ORG). - -PostgreSQL is free and the complete source is available. diff --git a/databases/postgresql12-server/pkg-install-server b/databases/postgresql12-server/pkg-install-server deleted file mode 100644 index 94486e0dff98..000000000000 --- a/databases/postgresql12-server/pkg-install-server +++ /dev/null @@ -1,23 +0,0 @@ -#! /bin/sh - -PATH=/bin:/usr/bin:/usr/sbin - -backupwarning() { -cat <<EOF - - =========== BACKUP YOUR DATA! ============= - As always, backup your data before - upgrading. If the upgrade leads to a higher - major revision (e.g. 9.6 -> 10), a dump - and restore of all databases is - required. This is *NOT* done by the port! - See https://www.postgresql.org/docs/current/upgrading.html - =========================================== -EOF -} - -case $2 in -PRE-INSTALL) - backupwarning - ;; -esac diff --git a/databases/postgresql12-server/pkg-plist-client b/databases/postgresql12-server/pkg-plist-client deleted file mode 100644 index 580d560f7dc7..000000000000 --- a/databases/postgresql12-server/pkg-plist-client +++ /dev/null @@ -1,1221 +0,0 @@ -bin/clusterdb -bin/createdb -bin/createuser -bin/dropdb -bin/dropuser -bin/ecpg -bin/pg_config -bin/pg_dump -bin/pg_dumpall -bin/pg_isready -bin/pg_restore -bin/pgbench -bin/psql -bin/reindexdb -bin/vacuumdb -include/ecpg_config.h -include/ecpg_informix.h -include/ecpgerrno.h -include/ecpglib.h -include/ecpgtype.h -include/libpq-events.h -include/libpq-fe.h -include/libpq/libpq-fs.h -include/pg_config.h -include/pg_config_ext.h -include/pg_config_manual.h -include/pg_config_os.h -include/pgtypes.h -include/pgtypes_date.h -include/pgtypes_error.h -include/pgtypes_interval.h -include/pgtypes_numeric.h -include/pgtypes_timestamp.h -include/postgres_ext.h -include/postgresql/informix/esql/datetime.h -include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqltypes.h -include/postgresql/internal/c.h -include/postgresql/internal/libpq-int.h -include/postgresql/internal/libpq/pqcomm.h -include/postgresql/internal/port.h -include/postgresql/internal/postgres_fe.h -include/postgresql/internal/pqexpbuffer.h -include/postgresql/server/access/amapi.h -include/postgresql/server/access/amvalidate.h -include/postgresql/server/access/attnum.h -include/postgresql/server/access/brin.h -include/postgresql/server/access/brin_internal.h -include/postgresql/server/access/brin_page.h -include/postgresql/server/access/brin_pageops.h -include/postgresql/server/access/brin_revmap.h -include/postgresql/server/access/brin_tuple.h -include/postgresql/server/access/brin_xlog.h -include/postgresql/server/access/bufmask.h -include/postgresql/server/access/clog.h -include/postgresql/server/access/commit_ts.h -include/postgresql/server/access/genam.h -include/postgresql/server/access/generic_xlog.h -include/postgresql/server/access/gin.h -include/postgresql/server/access/gin_private.h -include/postgresql/server/access/ginblock.h -include/postgresql/server/access/ginxlog.h -include/postgresql/server/access/gist.h -include/postgresql/server/access/gist_private.h -include/postgresql/server/access/gistscan.h -include/postgresql/server/access/gistxlog.h -include/postgresql/server/access/hash.h -include/postgresql/server/access/hash_xlog.h -include/postgresql/server/access/heapam.h -include/postgresql/server/access/heapam_xlog.h -include/postgresql/server/access/hio.h -include/postgresql/server/access/htup.h -include/postgresql/server/access/htup_details.h -include/postgresql/server/access/itup.h -include/postgresql/server/access/multixact.h -include/postgresql/server/access/nbtree.h -include/postgresql/server/access/nbtxlog.h -include/postgresql/server/access/parallel.h -include/postgresql/server/access/printsimple.h -include/postgresql/server/access/printtup.h -include/postgresql/server/access/relation.h -include/postgresql/server/access/reloptions.h -include/postgresql/server/access/relscan.h -include/postgresql/server/access/rewriteheap.h -include/postgresql/server/access/rmgr.h -include/postgresql/server/access/rmgrlist.h -include/postgresql/server/access/sdir.h -include/postgresql/server/access/session.h -include/postgresql/server/access/skey.h -include/postgresql/server/access/slru.h -include/postgresql/server/access/spgist.h -include/postgresql/server/access/spgist_private.h -include/postgresql/server/access/spgxlog.h -include/postgresql/server/access/stratnum.h -include/postgresql/server/access/subtrans.h -include/postgresql/server/access/sysattr.h -include/postgresql/server/access/table.h -include/postgresql/server/access/tableam.h -include/postgresql/server/access/timeline.h -include/postgresql/server/access/transam.h -include/postgresql/server/access/tsmapi.h -include/postgresql/server/access/tupconvert.h -include/postgresql/server/access/tupdesc.h -include/postgresql/server/access/tupdesc_details.h -include/postgresql/server/access/tupmacs.h -include/postgresql/server/access/tuptoaster.h -include/postgresql/server/access/twophase.h -include/postgresql/server/access/twophase_rmgr.h -include/postgresql/server/access/valid.h -include/postgresql/server/access/visibilitymap.h -include/postgresql/server/access/xact.h -include/postgresql/server/access/xlog.h -include/postgresql/server/access/xlog_internal.h -include/postgresql/server/access/xlogdefs.h -include/postgresql/server/access/xloginsert.h -include/postgresql/server/access/xlogreader.h -include/postgresql/server/access/xlogrecord.h -include/postgresql/server/access/xlogutils.h -include/postgresql/server/bootstrap/bootstrap.h -include/postgresql/server/c.h -include/postgresql/server/catalog/binary_upgrade.h -include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catversion.h -include/postgresql/server/catalog/dependency.h -include/postgresql/server/catalog/genbki.h -include/postgresql/server/catalog/heap.h -include/postgresql/server/catalog/index.h -include/postgresql/server/catalog/indexing.h -include/postgresql/server/catalog/namespace.h -include/postgresql/server/catalog/objectaccess.h -include/postgresql/server/catalog/objectaddress.h -include/postgresql/server/catalog/opfam_internal.h -include/postgresql/server/catalog/partition.h -include/postgresql/server/catalog/pg_aggregate.h -include/postgresql/server/catalog/pg_aggregate_d.h -include/postgresql/server/catalog/pg_am.h -include/postgresql/server/catalog/pg_am_d.h -include/postgresql/server/catalog/pg_amop.h -include/postgresql/server/catalog/pg_amop_d.h -include/postgresql/server/catalog/pg_amproc.h -include/postgresql/server/catalog/pg_amproc_d.h -include/postgresql/server/catalog/pg_attrdef.h -include/postgresql/server/catalog/pg_attrdef_d.h -include/postgresql/server/catalog/pg_attribute.h -include/postgresql/server/catalog/pg_attribute_d.h -include/postgresql/server/catalog/pg_auth_members.h -include/postgresql/server/catalog/pg_auth_members_d.h -include/postgresql/server/catalog/pg_authid.h -include/postgresql/server/catalog/pg_authid_d.h -include/postgresql/server/catalog/pg_cast.h -include/postgresql/server/catalog/pg_cast_d.h -include/postgresql/server/catalog/pg_class.h -include/postgresql/server/catalog/pg_class_d.h -include/postgresql/server/catalog/pg_collation.h -include/postgresql/server/catalog/pg_collation_d.h -include/postgresql/server/catalog/pg_constraint.h -include/postgresql/server/catalog/pg_constraint_d.h -include/postgresql/server/catalog/pg_control.h -include/postgresql/server/catalog/pg_conversion.h -include/postgresql/server/catalog/pg_conversion_d.h -include/postgresql/server/catalog/pg_database.h -include/postgresql/server/catalog/pg_database_d.h -include/postgresql/server/catalog/pg_db_role_setting.h -include/postgresql/server/catalog/pg_db_role_setting_d.h -include/postgresql/server/catalog/pg_default_acl.h -include/postgresql/server/catalog/pg_default_acl_d.h -include/postgresql/server/catalog/pg_depend.h -include/postgresql/server/catalog/pg_depend_d.h -include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_description_d.h -include/postgresql/server/catalog/pg_enum.h -include/postgresql/server/catalog/pg_enum_d.h -include/postgresql/server/catalog/pg_event_trigger.h -include/postgresql/server/catalog/pg_event_trigger_d.h -include/postgresql/server/catalog/pg_extension.h -include/postgresql/server/catalog/pg_extension_d.h -include/postgresql/server/catalog/pg_foreign_data_wrapper.h -include/postgresql/server/catalog/pg_foreign_data_wrapper_d.h -include/postgresql/server/catalog/pg_foreign_server.h -include/postgresql/server/catalog/pg_foreign_server_d.h -include/postgresql/server/catalog/pg_foreign_table.h -include/postgresql/server/catalog/pg_foreign_table_d.h -include/postgresql/server/catalog/pg_index.h -include/postgresql/server/catalog/pg_index_d.h -include/postgresql/server/catalog/pg_inherits.h -include/postgresql/server/catalog/pg_inherits_d.h -include/postgresql/server/catalog/pg_init_privs.h -include/postgresql/server/catalog/pg_init_privs_d.h -include/postgresql/server/catalog/pg_language.h -include/postgresql/server/catalog/pg_language_d.h -include/postgresql/server/catalog/pg_largeobject.h -include/postgresql/server/catalog/pg_largeobject_d.h -include/postgresql/server/catalog/pg_largeobject_metadata.h -include/postgresql/server/catalog/pg_largeobject_metadata_d.h -include/postgresql/server/catalog/pg_namespace.h -include/postgresql/server/catalog/pg_namespace_d.h -include/postgresql/server/catalog/pg_opclass.h -include/postgresql/server/catalog/pg_opclass_d.h -include/postgresql/server/catalog/pg_operator.h -include/postgresql/server/catalog/pg_operator_d.h -include/postgresql/server/catalog/pg_opfamily.h -include/postgresql/server/catalog/pg_opfamily_d.h -include/postgresql/server/catalog/pg_partitioned_table.h -include/postgresql/server/catalog/pg_partitioned_table_d.h -include/postgresql/server/catalog/pg_pltemplate.h -include/postgresql/server/catalog/pg_pltemplate_d.h -include/postgresql/server/catalog/pg_policy.h -include/postgresql/server/catalog/pg_policy_d.h -include/postgresql/server/catalog/pg_proc.h -include/postgresql/server/catalog/pg_proc_d.h -include/postgresql/server/catalog/pg_publication.h -include/postgresql/server/catalog/pg_publication_d.h -include/postgresql/server/catalog/pg_publication_rel.h -include/postgresql/server/catalog/pg_publication_rel_d.h -include/postgresql/server/catalog/pg_range.h -include/postgresql/server/catalog/pg_range_d.h -include/postgresql/server/catalog/pg_replication_origin.h -include/postgresql/server/catalog/pg_replication_origin_d.h -include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_rewrite_d.h *** 2915 LINES SKIPPED ***
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202501011208.501C8Jnq051308>