aboutsummaryrefslogtreecommitdiff
path: root/databases/pgcluster
diff options
context:
space:
mode:
authorJun Kuriyama <kuriyama@FreeBSD.org>2004-01-26 09:02:45 +0000
committerJun Kuriyama <kuriyama@FreeBSD.org>2004-01-26 09:02:45 +0000
commit79e023903e03be697215a6fe82106fc8aef8ad62 (patch)
tree4ec23ffc0b59e7e497ca038567f24345b7ed9db7 /databases/pgcluster
parentcbfce707e057c1497745b6f4bdb8f12b4dacc54f (diff)
downloadports-79e023903e03be697215a6fe82106fc8aef8ad62.tar.gz
ports-79e023903e03be697215a6fe82106fc8aef8ad62.zip
Notes
Diffstat (limited to 'databases/pgcluster')
-rw-r--r--databases/pgcluster/Makefile103
-rw-r--r--databases/pgcluster/distinfo2
-rw-r--r--databases/pgcluster/files/patch-pool_process_query.c15
-rw-r--r--databases/pgcluster/files/pgcluster.sh.tmpl56
-rw-r--r--databases/pgcluster/files/pglb.sh.tmpl35
-rw-r--r--databases/pgcluster/files/pgreplicate.sh.tmpl37
-rw-r--r--databases/pgcluster/files/setup-sshkey.pl24
-rw-r--r--databases/pgcluster/pkg-descr4
-rw-r--r--databases/pgcluster/pkg-install65
-rw-r--r--databases/pgcluster/pkg-plist95
10 files changed, 436 insertions, 0 deletions
diff --git a/databases/pgcluster/Makefile b/databases/pgcluster/Makefile
new file mode 100644
index 000000000000..ae2cee41d94c
--- /dev/null
+++ b/databases/pgcluster/Makefile
@@ -0,0 +1,103 @@
+# New ports collection makefile for: pgcluster
+# Date created: 22 Jan 2004
+# Whom: Jun Kuriyama <kuriyama@FreeBSD.org>
+#
+# $FreeBSD$
+
+PORTNAME= pgcluster
+PORTVERSION= 1.0.6b
+CATEGORIES= databases
+MASTER_SITES= ${MASTER_SITE_PGSQL}
+MASTER_SITE_SUBDIR= v${BASEPGSQL}
+DISTNAME= postgresql-base-${BASEPGSQL}
+DIST_SUBDIR= postgresql
+
+PATCH_SITES= http://hiroshima.sraw.co.jp/people/mitani/jpug/pgcluster/current/
+PATCHFILES= pgcluster-${PORTVERSION}-patch.tar.gz
+PATCH_DIST_STRIP= -p1
+
+MAINTAINER= kuriyama@FreeBSD.org
+COMMENT=The multi-master and synchronous replication system for PostgreSQL
+
+RUN_DEPENDS= rsync:${PORTSDIR}/net/rsync
+
+WRKSRC?= ${WRKDIR}/postgresql-${BASEPGSQL}
+USE_GMAKE= yes
+GNU_CONFIGURE= yes
+MAKE_FLAGS= # empty
+MAKEFILE= # empty
+CONFLICTS= postgresql-*
+USE_RC_SUBR= yes
+INSTALLS_SHLIB= yes
+
+BASEPGSQL= 7.3.4
+.if defined(WITHOUT_PGCLUSTER_REPLICATION)
+PGRP= "@comment "
+.endif
+.if defined(WITHOUT_PGCLUSTER_LOADBALANCER)
+PGLB= "@comment "
+.endif
+PLIST_SUB= PGRP=${PGRP} PGLB=${PGLB}
+RCSUBR_SUB= PREFIX=${PREFIX} RC_SUBR=${RC_SUBR}
+RCSUBR_SED= ${SED} ${RCSUBR_SUB:S|$|!g|:S|^| -e s!%%|:S|=|%%!|}
+
+MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 droplang.1 \
+ dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
+ pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
+ pg_resetxlog.1 pg_restore.1 pgtclsh.1 pgtksh.1 \
+ postgres.1 postmaster.1 psql.1 vacuumdb.1
+MAN7= abort.7 alter_database.7 alter_group.7 alter_table.7 alter_trigger.7 \
+ alter_user.7 analyze.7 begin.7 \
+ checkpoint.7 close.7 cluster.7 comment.7 commit.7 copy.7 \
+ create_aggregate.7 create_cast.7 create_constraint_trigger.7 \
+ create_conversion.7 create_database.7 create_domain.7 \
+ create_function.7 create_group.7 create_index.7 create_language.7 \
+ create_operator.7 create_operator_class.7 create_rule.7 \
+ create_schema.7 create_sequence.7 create_table.7 create_table_as.7 \
+ create_trigger.7 create_type.7 create_user.7 create_view.7 \
+ deallocate.7 declare.7 delete.7 drop_aggregate.7 drop_cast.7 \
+ drop_conversion.7 drop_database.7 drop_domain.7 drop_function.7 \
+ drop_group.7 drop_index.7 drop_language.7 drop_operator.7 \
+ drop_operator_class.7 drop_rule.7 drop_schema.7 drop_sequence.7 \
+ drop_table.7 drop_trigger.7 drop_type.7 drop_user.7 drop_view.7 \
+ end.7 execute.7 explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \
+ lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 revoke.7 \
+ rollback.7 select.7 select_into.7 set.7 set_constraints.7 \
+ set_session_authorization.7 set_transaction.7 show.7 \
+ start_transaction.7 truncate.7 unlisten.7 update.7 vacuum.7
+
+post-patch:
+ cd ${WRKSRC}/src/pgcluster/pgrp; ${CHMOD} +x configure missing
+ cd ${WRKSRC}/src/pgcluster/pglb; ${CHMOD} +x configure
+
+post-build:
+.if !defined(WITHOUT_PGCLUSTER_REPLICATION)
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pgrp do-configure
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pgrp do-build
+.endif
+.if !defined(WITHOUT_PGCLUSTER_LOADBALANCER)
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pglb do-configure
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pglb do-build
+.endif
+
+pre-install:
+ @${SETENV} PKG_PREFIX=${PREFIX} \
+ ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
+
+post-install:
+.if !defined(WITHOUT_PGCLUSTER_REPLICATION)
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pgrp do-install
+ ${RCSUBR_SED} ${FILESDIR}/pgreplicate.sh.tmpl > \
+ ${PREFIX}/etc/rc.d/pgreplicate.sh
+ ${CHMOD} +x ${PREFIX}/etc/rc.d/pgreplicate.sh
+.endif
+.if !defined(WITHOUT_PGCLUSTER_LOADBALANCER)
+ ${MAKE} WRKSRC=${WRKSRC}/src/pgcluster/pglb do-install
+ ${RCSUBR_SED} ${FILESDIR}/pglb.sh.tmpl > ${PREFIX}/etc/rc.d/pglb.sh
+ ${CHMOD} +x ${PREFIX}/etc/rc.d/pglb.sh
+.endif
+ ${RCSUBR_SED} ${FILESDIR}/pgcluster.sh.tmpl > \
+ ${PREFIX}/etc/rc.d/pgcluster.sh
+ ${CHMOD} +x ${PREFIX}/etc/rc.d/pgcluster.sh
+
+.include <bsd.port.mk>
diff --git a/databases/pgcluster/distinfo b/databases/pgcluster/distinfo
new file mode 100644
index 000000000000..adfc52ed5e75
--- /dev/null
+++ b/databases/pgcluster/distinfo
@@ -0,0 +1,2 @@
+MD5 (postgresql/postgresql-base-7.3.4.tar.gz) = 2b8600cc0f0c2d80271b533c394c886b
+MD5 (postgresql/pgcluster-1.0.6b-patch.tar.gz) = 405ea2a5f61a05c31ef16e3791be3ec4
diff --git a/databases/pgcluster/files/patch-pool_process_query.c b/databases/pgcluster/files/patch-pool_process_query.c
new file mode 100644
index 000000000000..dbac865f22e0
--- /dev/null
+++ b/databases/pgcluster/files/patch-pool_process_query.c
@@ -0,0 +1,15 @@
+--- src/pgcluster/pglb/pool_process_query.c.orig Sat Jan 24 14:14:51 2004
++++ src/pgcluster/pglb/pool_process_query.c Sat Jan 24 14:15:00 2004
+@@ -728,10 +728,11 @@
+ static POOL_STATUS EmptyQueryResponse(POOL_CONNECTION *frontend,
+ POOL_CONNECTION *backend)
+ {
++ char c;
++
+ /* set function name */
+ set_function("EmptyQueryResponse");
+
+- char c;
+ if (pool_read(backend, &c, sizeof(c)) < 0)
+ return POOL_END;
+
diff --git a/databases/pgcluster/files/pgcluster.sh.tmpl b/databases/pgcluster/files/pgcluster.sh.tmpl
new file mode 100644
index 000000000000..d0b2db0ab002
--- /dev/null
+++ b/databases/pgcluster/files/pgcluster.sh.tmpl
@@ -0,0 +1,56 @@
+#!/bin/sh
+#
+# $FreeBSD$
+#
+# PROVIDE: pgcluster
+# REQUIRE: DAEMON
+# BEFORE: pgreplicate
+# KEYWORD: FreeBSD
+#
+# Add the following line to /etc/rc.conf to enable pgcluster:
+#
+# pgcluster_enable="YES"
+# # optional
+# pgcluster_data="/home/pgsql/data"
+# pgcluster_flags="-w -s"
+#
+
+pgcluster_enable="NO"
+pgcluster_data="%%PREFIX%%/pgsql/data"
+pgcluster_flags="-w -s"
+
+. %%RC_SUBR%%
+
+load_rc_config pgcluster
+
+name=pgcluster
+command=%%PREFIX%%/bin/pg_ctl
+pgcluster_user=pgsql
+extra_commands="initdb recover"
+initdb_cmd="pgcluster_initdb"
+recover_cmd="pgcluster_recover"
+start_cmd="pgcluster_start"
+stop_cmd="pgcluster_stop"
+
+pgcluster_flags="${pgcluster_flags} -D ${pgcluster_data}"
+pidfile="${pgcluster_data}/postmaster.pid"
+
+pgcluster_start()
+{
+ su -m ${pgcluster_user} -c "exec ${command} start ${pgcluster_flags} -o '-i'"
+}
+pgcluster_stop()
+{
+ su -m ${pgcluster_user} -c "exec ${command} stop ${pgcluster_flags} -m i"
+}
+pgcluster_recover()
+{
+ su -m ${pgcluster_user} -c "exec ${command} start ${pgcluster_flags} -o '-i -R'"
+}
+pgcluster_initdb()
+{
+ su -m ${pgcluster_user} -c "exec %%PREFIX%%/bin/initdb -D ${pgcluster_data}"
+}
+
+load_rc_config $name
+run_rc_command "$1"
diff --git a/databases/pgcluster/files/pglb.sh.tmpl b/databases/pgcluster/files/pglb.sh.tmpl
new file mode 100644
index 000000000000..f0d53ec3dec1
--- /dev/null
+++ b/databases/pgcluster/files/pglb.sh.tmpl
@@ -0,0 +1,35 @@
+#!/bin/sh
+#
+# $FreeBSD$
+#
+# PROVIDE: pglb
+# REQUIRE: DAEMON
+# KEYWORD: FreeBSD
+#
+# Add the following line to /etc/rc.conf to enable pglb:
+#
+# pglb_enable="YES"
+#
+
+pglb_enable="NO"
+pglb_data="%%PREFIX%%/pgsql/data"
+pglb_flags=""
+
+. %%RC_SUBR%%
+
+load_rc_config pglb
+
+name=pglb
+command=%%PREFIX%%/bin/pglb
+pglb_user=pgsql
+stop_cmd="pglb_stop"
+
+pglb_flags="${pglb_flags} -D ${pglb_data}"
+
+pglb_stop()
+{
+ su -m ${pglb_user} -c "exec ${command} -D ${pglb_data} stop"
+}
+
+load_rc_config $name
+run_rc_command "$1"
diff --git a/databases/pgcluster/files/pgreplicate.sh.tmpl b/databases/pgcluster/files/pgreplicate.sh.tmpl
new file mode 100644
index 000000000000..fa392d8de73c
--- /dev/null
+++ b/databases/pgcluster/files/pgreplicate.sh.tmpl
@@ -0,0 +1,37 @@
+#!/bin/sh
+#
+# $FreeBSD$
+#
+# PROVIDE: pgreplicate
+# REQUIRE: DAEMON
+# BEFORE: pglb
+# KEYWORD: FreeBSD
+#
+# Add the following line to /etc/rc.conf to enable pgreplicate:
+#
+# pgreplicate_enable="YES"
+#
+
+pgreplicate_enable="NO"
+pgreplicate_data="%%PREFIX%%/pgsql/data"
+pgreplicate_flags=""
+
+. %%RC_SUBR%%
+
+load_rc_config pgreplicate
+
+name=pgreplicate
+command=%%PREFIX%%/bin/pgreplicate
+pgreplicate_user=pgsql
+stop_cmd="pgreplicate_stop"
+
+pgreplicate_flags="${pgreplicate_flags} -D ${pgreplicate_data}"
+pidfile="${pgreplicate_data}/pgreplicate.pid"
+
+pgreplicate_stop()
+{
+ su -m ${pgreplicate_user} -c "exec ${command} -D ${pgreplicate_data} stop"
+}
+
+load_rc_config $name
+run_rc_command "$1"
diff --git a/databases/pgcluster/files/setup-sshkey.pl b/databases/pgcluster/files/setup-sshkey.pl
new file mode 100644
index 000000000000..11c3a034de1b
--- /dev/null
+++ b/databases/pgcluster/files/setup-sshkey.pl
@@ -0,0 +1,24 @@
+#!/usr/bin/perl -w
+#
+# $FreeBSD$
+
+use strict;
+
+my $base = "$ENV{HOME}/.ssh";
+foreach (@ARGV) {
+ my $dir = "$base/$_";
+ system("mkdir -p $dir") == 0 or die;
+ if (not -r "$dir/id_dsa.pub") {
+ system("ssh-keygen -t dsa -N '' -C $ENV{USER}\@$_ -f $dir/id_dsa") == 0
+ or die
+ }
+ system("ssh-keyscan -t dsa $_ >> $base/known_hosts") == 0 or die;
+ system("sort $base/known_hosts | uniq > $base/tmp.$$") == 0 or die;
+ system("mv $base/tmp.$$ $base/known_hosts") == 0 or die;
+}
+foreach (@ARGV) {
+ my $dir = "$base/$_";
+ system("cat $base/*/id_dsa.pub > $dir/authorized_keys") == 0 or die;
+ system("cp $base/known_hosts $dir/known_hosts") == 0 or die;
+}
+
diff --git a/databases/pgcluster/pkg-descr b/databases/pgcluster/pkg-descr
new file mode 100644
index 000000000000..2eb61809a7d7
--- /dev/null
+++ b/databases/pgcluster/pkg-descr
@@ -0,0 +1,4 @@
+PGCluster is a multi-master and synchronous replication system that
+supports load balancing of PostgreSQL.
+
+WWW: http://www.csra.co.jp/~mitani/jpug/pgcluster/
diff --git a/databases/pgcluster/pkg-install b/databases/pgcluster/pkg-install
new file mode 100644
index 000000000000..e2cf87838347
--- /dev/null
+++ b/databases/pgcluster/pkg-install
@@ -0,0 +1,65 @@
+#! /bin/sh
+
+# Original: FreeBSD: ports/databases/postgresql7/pkg-install,v 1.8 2003/12/04 12:00:48 seanc Exp
+
+PATH=/bin:/usr/sbin
+
+DB_DIR=${PKG_PREFIX}/pgsql
+
+backupwarning() {
+ echo "
+ =========== BACKUP YOUR DATA! =============
+ As always, backup your data before
+ upgrading. If the upgrade leads to a higher
+ minor revision (e.g. 7.3.x -> 7.4), a dump
+ and restore of all databases is
+ required. This is *NOT* done by the port!
+
+ Press ctrl-C *now* if you need to pg_dump.
+ ===========================================
+"
+ sleep 5
+}
+
+case $2 in
+PRE-INSTALL)
+# backupwarning
+ USER=pgsql
+ GROUP=${USER}
+ UID=70
+ GID=${UID}
+
+ if pw group show "${GROUP}" 2>/dev/null; then
+ echo "You already have a group \"${GROUP}\", so I will use it."
+ else
+ if pw groupadd ${GROUP} -g ${GID}; then
+ echo "Added group \"${GROUP}\"."
+ else
+ echo "Adding group \"${GROUP}\" failed..."
+ exit 1
+ fi
+ fi
+
+ if pw user show "${USER}" 2>/dev/null; then
+ echo "You already have a user \"${USER}\", so I will use it."
+ else
+ if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - \
+ -d ${DB_DIR} -c "PostgreSQL Daemon"
+ then
+ echo "Added user \"${USER}\"."
+ else
+ echo "Adding user \"${USER}\" failed..."
+ exit 1
+ fi
+ fi
+
+ if ! [ -x ~pgsql ] ; then
+ mkdir -p ${DB_DIR}
+ chown pgsql:pgsql ${DB_DIR}
+ fi
+ ;;
+
+BACKUPWARNING)
+# backupwarning
+ ;;
+esac
diff --git a/databases/pgcluster/pkg-plist b/databases/pgcluster/pkg-plist
new file mode 100644
index 000000000000..ca1df40c4305
--- /dev/null
+++ b/databases/pgcluster/pkg-plist
@@ -0,0 +1,95 @@
+bin/clusterdb
+bin/createdb
+bin/createlang
+bin/createuser
+bin/dropdb
+bin/droplang
+bin/dropuser
+bin/ecpg
+bin/initdb
+bin/initlocation
+bin/ipcclean
+bin/pg_config
+bin/pg_controldata
+bin/pg_ctl
+bin/pg_dump
+bin/pg_dumpall
+bin/pg_encoding
+bin/pg_id
+bin/pg_resetxlog
+bin/pg_restore
+%%PGLB%%bin/pglb
+%%PGRP%%bin/pgreplicate
+bin/postgres
+bin/postmaster
+bin/psql
+bin/vacuumdb
+%%PGLB%%etc/pglb.conf.sample
+%%PGRP%%etc/pgreplicate.conf.sample
+etc/rc.d/pgcluster.sh
+%%PGLB%%etc/rc.d/pglb.sh
+%%PGRP%%etc/rc.d/pgreplicate.sh
+include/ecpgerrno.h
+include/ecpglib.h
+include/ecpgtype.h
+include/libpq-fe.h
+include/libpq/libpq-fs.h
+include/pg_config.h
+include/pg_config_os.h
+include/postgres_ext.h
+include/postgresql/internal/c.h
+include/postgresql/internal/lib/dllist.h
+include/postgresql/internal/libpq-int.h
+include/postgresql/internal/libpq/pqcomm.h
+include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/pqexpbuffer.h
+include/sql3types.h
+include/sqlca.h
+lib/libecpg.a
+lib/libecpg.so
+lib/libecpg.so.3
+lib/libpq.a
+lib/libpq.so
+lib/libpq.so.3
+lib/postgresql/ascii_and_mic.so
+lib/postgresql/cyrillic_and_mic.so
+lib/postgresql/euc_cn_and_mic.so
+lib/postgresql/euc_jp_and_sjis.so
+lib/postgresql/euc_kr_and_mic.so
+lib/postgresql/euc_tw_and_big5.so
+lib/postgresql/latin2_and_win1250.so
+lib/postgresql/latin_and_mic.so
+lib/postgresql/plpgsql.so
+lib/postgresql/utf8_and_ascii.so
+lib/postgresql/utf8_and_big5.so
+lib/postgresql/utf8_and_cyrillic.so
+lib/postgresql/utf8_and_euc_cn.so
+lib/postgresql/utf8_and_euc_jp.so
+lib/postgresql/utf8_and_euc_kr.so
+lib/postgresql/utf8_and_euc_tw.so
+lib/postgresql/utf8_and_gb18030.so
+lib/postgresql/utf8_and_gbk.so
+lib/postgresql/utf8_and_iso8859.so
+lib/postgresql/utf8_and_iso8859_1.so
+lib/postgresql/utf8_and_johab.so
+lib/postgresql/utf8_and_sjis.so
+lib/postgresql/utf8_and_tcvn.so
+lib/postgresql/utf8_and_uhc.so
+lib/postgresql/utf8_and_win1250.so
+lib/postgresql/utf8_and_win1256.so
+lib/postgresql/utf8_and_win874.so
+share/postgresql/cluster.conf.sample
+share/postgresql/conversion_create.sql
+share/postgresql/pg_hba.conf.sample
+share/postgresql/pg_ident.conf.sample
+share/postgresql/postgres.bki
+share/postgresql/postgres.description
+share/postgresql/postgresql.conf.sample
+@dirrm include/libpq
+@dirrm include/postgresql/internal/lib
+@dirrm include/postgresql/internal/libpq
+@dirrm include/postgresql/internal
+@dirrm include/postgresql
+@dirrm lib/postgresql
+@dirrm share/postgresql
+@unexec rmdir %D/pgsql 2>/dev/null || true