diff options
author | Rene Ladan <rene@FreeBSD.org> | 2017-06-25 17:26:23 +0000 |
---|---|---|
committer | Rene Ladan <rene@FreeBSD.org> | 2017-06-25 17:26:23 +0000 |
commit | c8a228730b2fa827f7bee82daa3a89fe9f98119c (patch) | |
tree | e4f9314b94f0b51a6f3d06a672fe43ec6135b243 /databases/pgpool-II | |
parent | 3e2dfa8fe77e373c7fc7509edcca89c34be35b7c (diff) | |
download | ports-c8a228730b2fa827f7bee82daa3a89fe9f98119c.tar.gz ports-c8a228730b2fa827f7bee82daa3a89fe9f98119c.zip |
Notes
Diffstat (limited to 'databases/pgpool-II')
-rw-r--r-- | databases/pgpool-II/Makefile | 75 | ||||
-rw-r--r-- | databases/pgpool-II/distinfo | 2 | ||||
-rw-r--r-- | databases/pgpool-II/files/patch-recovery.c | 19 | ||||
-rw-r--r-- | databases/pgpool-II/files/pgpool.in | 56 | ||||
-rw-r--r-- | databases/pgpool-II/files/pgpool_copy_backup | 40 | ||||
-rw-r--r-- | databases/pgpool-II/files/pgpool_remote_start | 26 | ||||
-rw-r--r-- | databases/pgpool-II/files/pgpool_switch_xlog | 20 | ||||
-rw-r--r-- | databases/pgpool-II/pkg-descr | 10 | ||||
-rw-r--r-- | databases/pgpool-II/pkg-plist | 45 |
9 files changed, 0 insertions, 293 deletions
diff --git a/databases/pgpool-II/Makefile b/databases/pgpool-II/Makefile deleted file mode 100644 index dee3be148449..000000000000 --- a/databases/pgpool-II/Makefile +++ /dev/null @@ -1,75 +0,0 @@ -# Created by: Choe, Cheng-Dae <whitekid@gmail.com> -# $FreeBSD$ - -PORTNAME= pgpool-II -PORTVERSION= 3.1.6 -PORTREVISION= 2 -CATEGORIES= databases -MASTER_SITES= LOCAL/kuriyama \ - http://www.pgpool.net/mediawiki/images/ - -MAINTAINER= kuriyama@FreeBSD.org -COMMENT= Connection pool server for PostgreSQL - -LICENSE= MIT - -DEPRECATED= Deprecated by upstream; use database/pgpool instead -EXPIRATION_DATE= 2017-06-15 - -GNU_CONFIGURE= yes -INSTALL_TARGET= install-strip -USES= gmake pgsql:9.2 libtool ssl -USE_LDCONFIG= yes -CONFIGURE_ARGS= --with-openssl - -CONFLICTS= pgpool-3.* pgpool-II-22-* pgpool-II-23-* pgpool-II-23-* -USE_RC_SUBR= pgpool - -PORTDOCS= AUTHORS COPYING ChangeLog INSTALL NEWS README README.euc_jp -PORTDOCS+= TODO -PORTDOCShtml= pgpool-en.html pgpool-ja.html pgpool.css -PORTDOCShtml+= tutorial-en.html tutorial-ja.html - -OPTIONS_DEFINE+= DOCS - -.include <bsd.port.options.mk> - -.if exists(${LOCALBASE}/include/postgresql/server/replication/walreceiver.h) -FUNCTIONS= pgpool-recovery pgpool-regclass pgpool-walrecrunning -PLIST_SUB= PGSQL9="" -.else -FUNCTIONS= pgpool-recovery pgpool-regclass -PLIST_SUB= PGSQL9="@comment " -.endif - -post-patch: - @${REINPLACE_CMD} -e 's| pg_config| ${LOCALBASE}/bin/pg_config|g' \ - ${WRKSRC}/sql/pgpool-recovery/Makefile - -post-build: -.for f in ${FUNCTIONS} - @cd ${WRKSRC}/sql/${f} && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} -.endfor - -post-install: -.for f in ${FUNCTIONS} - @cd ${WRKSRC}/sql/${f} && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} DESTDIR=${STAGEDIR} ${INSTALL_TARGET} -.endfor - ${INSTALL_DATA} ${WRKSRC}/sample/dist_def_pgbench.sql ${STAGEDIR}${DATADIR} - ${INSTALL_DATA} ${WRKSRC}/sample/replicate_def_pgbench.sql ${STAGEDIR}${DATADIR} - ${MKDIR} ${STAGEDIR}${DATADIR} ${STAGEDIR}${EXAMPLESDIR} -.for f in pgpool_recovery pgpool_recovery_pitr pgpool_remote_start - ${INSTALL_SCRIPT} ${WRKSRC}/sample/${f} ${STAGEDIR}${EXAMPLESDIR} -.endfor -.if ${PORT_OPTIONS:MDOCS} - @${MKDIR} ${STAGEDIR}${DOCSDIR} -.for f in ${PORTDOCS} - ${INSTALL_MAN} ${WRKSRC}/$f ${STAGEDIR}${DOCSDIR} -.endfor -.for f in ${PORTDOCShtml} - ${INSTALL_MAN} ${WRKSRC}/doc/$f ${STAGEDIR}${DOCSDIR} -.endfor -PORTDOCS+= ${PORTDOCShtml} -.endif - -.include <bsd.port.mk> diff --git a/databases/pgpool-II/distinfo b/databases/pgpool-II/distinfo deleted file mode 100644 index 211c5bb1dfa0..000000000000 --- a/databases/pgpool-II/distinfo +++ /dev/null @@ -1,2 +0,0 @@ -SHA256 (pgpool-II-3.1.6.tar.gz) = c15783105eecc85eb3cadebc22e0d6c9efa916da4bcc4c96c12b0463b34945cc -SIZE (pgpool-II-3.1.6.tar.gz) = 1353846 diff --git a/databases/pgpool-II/files/patch-recovery.c b/databases/pgpool-II/files/patch-recovery.c deleted file mode 100644 index 9833155123fc..000000000000 --- a/databases/pgpool-II/files/patch-recovery.c +++ /dev/null @@ -1,19 +0,0 @@ ---- recovery.c.orig 2010-10-12 08:12:18.155163331 +0900 -+++ recovery.c 2010-10-12 08:13:21.347257609 +0900 -@@ -96,7 +96,7 @@ - - if (REPLICATION) - { -- pool_log("starting 2nd stage"); -+ pool_log("starting 2nd stage. waiting connections from clients to be closed"); - - /* 2nd stage */ - *InRecovery = 1; -@@ -384,6 +384,6 @@ - sleep(3); - } while (i++ < WAIT_RETRY_COUNT); - -- pool_error("wait_connection_closed: existing connections did not close in %d sec.", pool_config->recovery_timeout); -+ pool_error("wait_connection_closed: existing connections (%d) did not close in %d sec.", Req_info->conn_counter, pool_config->recovery_timeout); - return 1; - } diff --git a/databases/pgpool-II/files/pgpool.in b/databases/pgpool-II/files/pgpool.in deleted file mode 100644 index 90ec820b1b99..000000000000 --- a/databases/pgpool-II/files/pgpool.in +++ /dev/null @@ -1,56 +0,0 @@ -#!/bin/sh -# -# $FreeBSD$ -# -# PROVIDE: pgpool -# REQUIRE: LOGIN -# KEYWORD: shutdown -# -# Add the following lines to /etc/rc.conf.local or /etc/rc.conf -# to enable this service: -# -# pgpool_enable (bool): Set to NO by default. -# Set it to YES to enable pgpool. -# pgpool_conf (file): Set location of your config. -# Default is "%%PREFIX%%/etc/pgpool.conf" -# pgpool_flags (string): Default is "-f $pgpool_conf" -# pgpool_looger (bool): Use logger for logging. -# pgpool_looger_pri (string): logger priority (default "local0.info"). -# pgpool_user (uid): User ID to run as (default nobody) -# - -. /etc/rc.subr - -name=pgpool -rcvar=pgpool_enable - -load_rc_config $name - -: ${pgpool_enable="NO"} -: ${pgpool_conf="%%PREFIX%%/etc/pgpool.conf"} -: ${pgpool_flags="-f ${pgpool_conf}"} -: ${pgpool_user="nobody"} -: ${pgpool_logger="YES"} -: ${pgpool_logger_pri="local0.info"} - -command="%%PREFIX%%/bin/pgpool" -command_args="${pgpool_flags}" -start_cmd="pgpool_start" -stop_cmd="${command} ${command_args} stop" - -extra_commands="reload" -reload_cmd="${command} ${command_args} reload" - -required_files="${pgpool_conf}" - -pgpool_start() -{ - if checkyesno pgpool_logger; then - su -m $pgpool_user -c "sh -c \"$command $command_args -n 2>&1 | logger -t $name -p $pgpool_logger_pri &\"" - else - unset start_cmd - run_rc_command start - fi -} - -run_rc_command "$1" diff --git a/databases/pgpool-II/files/pgpool_copy_backup b/databases/pgpool-II/files/pgpool_copy_backup deleted file mode 100644 index aa6a5226d53a..000000000000 --- a/databases/pgpool-II/files/pgpool_copy_backup +++ /dev/null @@ -1,40 +0,0 @@ -#!/bin/sh -# -# $FreeBSD$ -# -# In postgresql.conf: -# archive_command = 'test -f /proj/pgsql/data/archive_log/%f || cp %p /proj/pgsql/data/archive_log/%f' -# - -SRC=pgsql@$(hostname) -SRCDIR=$1 -DEST=pgsql@$2 -DESTDIR=$3 -ARCLOG=$1/archive_log - -logger="logger -t pgpool -p local0.info" -rsync="/usr/local/bin/rsync -av --delete --checksum" -excl="--exclude=pg_log --exclude=postmaster.pid" -psql="/usr/local/bin/psql" - -/bin/sh <<EOF | ${logger} 2>&1 - -$psql -c "select pg_start_backup('pgpool-recovery')" template1 - -ssh $DEST " -/usr/local/bin/pg_ctl -D $DESTDIR -s -m fast stop; -rm -f $DESTDIR/backup_label" - -echo "restore_command = 'scp $SRC:$ARCLOG/%f %p'" > $SRCDIR/recovery.conf - -$rsync $SRCDIR/ $excl $DEST:/$DESTDIR/ - -ssh $DEST " -mkdir -p $DESTDIR/pg_xlog/archive_status; -mkdir -p $DESTDIR/pg_log" - -rm -f $SRCDIR/recovery.conf - -$psql -c 'select pg_stop_backup()' template1 - -EOF diff --git a/databases/pgpool-II/files/pgpool_remote_start b/databases/pgpool-II/files/pgpool_remote_start deleted file mode 100644 index 1c044aef90cb..000000000000 --- a/databases/pgpool-II/files/pgpool_remote_start +++ /dev/null @@ -1,26 +0,0 @@ -#!/usr/bin/perl -# -# $FreeBSD$ - -use strict; -use warnings; - -my ($host, $dir) = @ARGV; - -my $logger = "logger -t pgpool -p local0.info"; -my $pgctl = "/usr/local/bin/pg_ctl -D $dir"; -my ($fh, $log); - -if (not open($fh, "ssh pgsql\@$host $pgctl -t 5 -w -s -m fast start 2>&1 |")) { - die "cannot open ssh: $!"; -} -if (not open($log, "| $logger")) { - die "cannot open logger: $!"; -} -while (<$fh>) { - print $log $_; -} -close($fh) or die "close(ssh) failed: $!"; -close($log) or die "close(logger): $!"; - -system("ssh pgsql\@$host $pgctl status 2>&1") == 0 or die "pg_ctl status failed"; diff --git a/databases/pgpool-II/files/pgpool_switch_xlog b/databases/pgpool-II/files/pgpool_switch_xlog deleted file mode 100644 index 8ce8b8603a46..000000000000 --- a/databases/pgpool-II/files/pgpool_switch_xlog +++ /dev/null @@ -1,20 +0,0 @@ -#!/bin/sh -# -# $FreeBSD$ - -logger="logger -t pgpool -p local0.info" -psql=/usr/local/bin/psql - -/bin/sh <<EOF | ${logger} 2>&1 - -$psql -t -c 'SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn' template1 | -while read i -do - if [ "$i" != "" ];then - $psql -c "SELECT setval(oid, nextval(oid)) FROM pg_class WHERE relkind = 'S'" $i - fi -done - -$psql -c 'select pg_switch_xlog()' template1 - -EOF diff --git a/databases/pgpool-II/pkg-descr b/databases/pgpool-II/pkg-descr deleted file mode 100644 index 74e9c2fd673c..000000000000 --- a/databases/pgpool-II/pkg-descr +++ /dev/null @@ -1,10 +0,0 @@ -pgpool-II allows multiple PostgreSQL servers (DB nodes) to be -connected, which enables queries to be executed simultaneously on all -servers. - -It enables "parallel query" processing. Also, pgpool-II can be started -as pgpool-I by changing configuration parameters. pgpool-II that is -executed in pgpool-I mode enables multiple DB nodes to be connected, -which was not possible in pgpool-I. - -WWW: http://www.pgpool.net/ diff --git a/databases/pgpool-II/pkg-plist b/databases/pgpool-II/pkg-plist deleted file mode 100644 index 0557471756be..000000000000 --- a/databases/pgpool-II/pkg-plist +++ /dev/null @@ -1,45 +0,0 @@ -bin/pcp_attach_node -bin/pcp_detach_node -bin/pcp_node_count -bin/pcp_node_info -bin/pcp_pool_status -bin/pcp_proc_count -bin/pcp_proc_info -bin/pcp_promote_node -bin/pcp_recovery_node -bin/pcp_stop_pgpool -bin/pcp_systemdb_info -bin/pg_md5 -bin/pgpool -etc/pcp.conf.sample -etc/pgpool.conf.sample -etc/pgpool.conf.sample-master-slave -etc/pgpool.conf.sample-replication -etc/pgpool.conf.sample-stream -etc/pool_hba.conf.sample -include/libpcp_ext.h -include/pcp.h -include/pool_process_reporting.h -include/pool_type.h -lib/libpcp.a -lib/libpcp.so -lib/libpcp.so.0 -lib/libpcp.so.0.0.0 -man/man8/pgpool.8.gz -%%DATADIR%%/dist_def_pgbench.sql -%%DATADIR%%/insert_lock.sql -%%DATADIR%%/pgpool.pam -%%DATADIR%%/replicate_def_pgbench.sql -%%DATADIR%%/system_db.sql -%%EXAMPLESDIR%%/pgpool_recovery -%%EXAMPLESDIR%%/pgpool_recovery_pitr -%%EXAMPLESDIR%%/pgpool_remote_start -share/postgresql/contrib/pgpool-recovery.sql -share/postgresql/contrib/pgpool-regclass.sql -%%PGSQL9%%share/postgresql/contrib/pgpool-walrecrunning.sql -share/postgresql/contrib/uninstall_pgpool-recovery.sql -share/postgresql/contrib/uninstall_pgpool-regclass.sql -%%PGSQL9%%share/postgresql/contrib/uninstall_pgpool-walrecrunning.sql -lib/postgresql/pgpool-recovery.so -lib/postgresql/pgpool-regclass.so -%%PGSQL9%%lib/postgresql/pgpool-walrecrunning.so |