aboutsummaryrefslogtreecommitdiff
path: root/databases/pgpool-II-23
diff options
context:
space:
mode:
Diffstat (limited to 'databases/pgpool-II-23')
-rw-r--r--databases/pgpool-II-23/Makefile61
-rw-r--r--databases/pgpool-II-23/distinfo3
-rw-r--r--databases/pgpool-II-23/files/patch-recovery.c19
-rw-r--r--databases/pgpool-II-23/files/pgpool.in53
-rw-r--r--databases/pgpool-II-23/files/pgpool_copy_backup37
-rw-r--r--databases/pgpool-II-23/files/pgpool_remote_start13
-rw-r--r--databases/pgpool-II-23/files/pgpool_switch_xlog20
-rw-r--r--databases/pgpool-II-23/pkg-descr10
-rw-r--r--databases/pgpool-II-23/pkg-plist33
9 files changed, 0 insertions, 249 deletions
diff --git a/databases/pgpool-II-23/Makefile b/databases/pgpool-II-23/Makefile
deleted file mode 100644
index 7b1e7dc687af..000000000000
--- a/databases/pgpool-II-23/Makefile
+++ /dev/null
@@ -1,61 +0,0 @@
-# New ports collection makefile for: pgpool
-# Date created: 2005-10-19
-# Whom: Choe, Cheng-Dae <whitekid@gmail.com>
-#
-# $FreeBSD$
-#
-
-PORTNAME= pgpool-II
-PORTVERSION= 2.2.4
-CATEGORIES= databases
-MASTER_SITES= http://pgfoundry.org/frs/download.php/2362/
-
-MAINTAINER= kuriyama@FreeBSD.org
-COMMENT= A connection pool server for PostgreSQL
-
-USE_GMAKE= yes
-GNU_CONFIGURE= yes
-USE_PGSQL= yes
-USE_LDCONFIG= yes
-
-CONFLICTS= pgpool-3.*
-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
-
-MAN8= pgpool.8
-
-post-patch:
- @${REINPLACE_CMD} -e 's|echo aout|echo elf|g' \
- ${WRKSRC}/configure
- @${REINPLACE_CMD} -e 's| pg_config| ${LOCALBASE}/bin/pg_config|g' \
- ${WRKSRC}/sql/pgpool-recovery/Makefile
-
-post-build:
- @cd ${WRKSRC}/sql/pgpool-recovery && ${GMAKE}
-
-pre-install:
- ${MKDIR} ${DATADIR} ${EXAMPLESDIR}
-
-post-install:
- @cd ${WRKSRC}/sql/pgpool-recovery && ${GMAKE} ${INSTALL_TARGET}
- ${INSTALL_DATA} ${WRKSRC}/sample/dist_def_pgbench.sql ${DATADIR}
- ${INSTALL_DATA} ${WRKSRC}/sample/replicate_def_pgbench.sql ${DATADIR}
-.for f in pgpool_recovery pgpool_recovery_pitr pgpool_remote_start
- ${INSTALL_SCRIPT} ${WRKSRC}/sample/${f} ${EXAMPLESDIR}
-.endfor
-.if !defined(NOPORTDOCS)
- @${MKDIR} ${DOCSDIR}
-.for f in ${PORTDOCS}
- ${INSTALL_MAN} ${WRKSRC}/$f ${DOCSDIR}
-.endfor
-.for f in ${PORTDOCShtml}
- ${INSTALL_MAN} ${WRKSRC}/doc/$f ${DOCSDIR}
-.endfor
-PORTDOCS+= ${PORTDOCShtml}
-.endif
-
-.include <bsd.port.mk>
diff --git a/databases/pgpool-II-23/distinfo b/databases/pgpool-II-23/distinfo
deleted file mode 100644
index 74041e662b8d..000000000000
--- a/databases/pgpool-II-23/distinfo
+++ /dev/null
@@ -1,3 +0,0 @@
-MD5 (pgpool-II-2.2.4.tar.gz) = 2c9edd0512c5dc1dabab474b563a7a6c
-SHA256 (pgpool-II-2.2.4.tar.gz) = 49ac6ce7662c70685d88df4ade0a3166c00ce5ec7b131e8f4155ad5beebf3f53
-SIZE (pgpool-II-2.2.4.tar.gz) = 1039603
diff --git a/databases/pgpool-II-23/files/patch-recovery.c b/databases/pgpool-II-23/files/patch-recovery.c
deleted file mode 100644
index a6ac0c6bceca..000000000000
--- a/databases/pgpool-II-23/files/patch-recovery.c
+++ /dev/null
@@ -1,19 +0,0 @@
---- recovery.c.orig 2009-08-14 15:15:08.000000000 +0900
-+++ recovery.c 2009-08-14 18:00:38.000000000 +0900
-@@ -91,7 +91,7 @@
-
- pool_log("1st stage is done");
-
-- pool_log("starting 2nd stage");
-+ pool_log("starting 2nd stage. waiting connections from clients to be closed");
-
- /* 2nd stage */
- *InRecovery = 1;
-@@ -332,6 +332,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-23/files/pgpool.in b/databases/pgpool-II-23/files/pgpool.in
deleted file mode 100644
index 058b531550c4..000000000000
--- a/databases/pgpool-II-23/files/pgpool.in
+++ /dev/null
@@ -1,53 +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)
-#
-
-. %%RC_SUBR%%
-
-name=pgpool
-rcvar=${name}_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"
-
-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-23/files/pgpool_copy_backup b/databases/pgpool-II-23/files/pgpool_copy_backup
deleted file mode 100644
index 31d0d4651921..000000000000
--- a/databases/pgpool-II-23/files/pgpool_copy_backup
+++ /dev/null
@@ -1,37 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-
-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=archive_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/etc/rc.d/postgresql stop;
-rm -rf $DESTDIR/pg_xlog;
-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-23/files/pgpool_remote_start b/databases/pgpool-II-23/files/pgpool_remote_start
deleted file mode 100644
index 66a628b725fd..000000000000
--- a/databases/pgpool-II-23/files/pgpool_remote_start
+++ /dev/null
@@ -1,13 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-
-DEST=pgsql@$1
-
-logger="logger -t pgpool -p local0.info"
-
-/bin/sh <<EOF | ${logger} 2>&1
-
-ssh $DEST '/usr/local/etc/rc.d/postgresql start'
-
-EOF
diff --git a/databases/pgpool-II-23/files/pgpool_switch_xlog b/databases/pgpool-II-23/files/pgpool_switch_xlog
deleted file mode 100644
index 8ce8b8603a46..000000000000
--- a/databases/pgpool-II-23/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-23/pkg-descr b/databases/pgpool-II-23/pkg-descr
deleted file mode 100644
index cc310d06b9d7..000000000000
--- a/databases/pgpool-II-23/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://pgpool.projects.postgresql.org/
diff --git a/databases/pgpool-II-23/pkg-plist b/databases/pgpool-II-23/pkg-plist
deleted file mode 100644
index c06c66621cc0..000000000000
--- a/databases/pgpool-II-23/pkg-plist
+++ /dev/null
@@ -1,33 +0,0 @@
-@comment $FreeBSD$
-bin/pcp_attach_node
-bin/pcp_detach_node
-bin/pcp_node_count
-bin/pcp_node_info
-bin/pcp_proc_count
-bin/pcp_proc_info
-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/pool_hba.conf.sample
-include/pcp.h
-include/pool_type.h
-lib/libpcp.a
-lib/libpcp.la
-lib/libpcp.so
-lib/libpcp.so.0
-%%DATADIR%%/dist_def_pgbench.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
-lib/postgresql/pgpool-recovery.so
-@dirrmtry share/postgresql/contrib
-@dirrm %%EXAMPLESDIR%%
-@dirrm %%DATADIR%%
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-30 16:21:49 +0000