11 files changed, 457 insertions, 2 deletions

diff --git a/dev-db/pgcluster/ChangeLog b/dev-db/pgcluster/ChangeLog
index f394743aedc0..939b5a9da14f 100644
--- a/dev-db/pgcluster/ChangeLog
+++ b/dev-db/pgcluster/ChangeLog
@@ -1,6 +1,15 @@
 # ChangeLog for dev-db/pgcluster
 # Copyright 1999-2005 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/ChangeLog,v 1.1 2005/02/27 07:20:28 nakano Exp $
+# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/ChangeLog,v 1.2 2005/05/10 06:40:37 nakano Exp $
+
+*pgcluster-1.3.0c (10 May 2005)
+
+  10 May 2005; Masatomo Nakano <nakano@gentoo.org>
+  +files/pgcluster.conf-1.3.0c, +files/pgcluster.init-1.3.0c,
+  +files/pglb.conf-1.3.0c, +files/pglb.init-1.3.0c,
+  +files/pgreplicate.conf-1.3.0c, +files/pgreplicate.init-1.3.0c,
+  +files/pgcluster-1.3.0c-gentoo.patch, +pgcluster-1.3.0c.ebuild:
+  Version bump.
 
 *pgcluster-1.3.0b (27 Feb 2005)
 
diff --git a/dev-db/pgcluster/Manifest b/dev-db/pgcluster/Manifest
index 6f9c8dc21f38..12d66731646f 100644
--- a/dev-db/pgcluster/Manifest
+++ b/dev-db/pgcluster/Manifest
@@ -1,11 +1,20 @@
+MD5 df6aafac9d50a2035d5bdd35348ac4cc pgcluster-1.3.0c.ebuild 7826
 MD5 313970999e36876e3a3a16d768f3795c pgcluster-1.3.0b.ebuild 7826
-MD5 288f25bee278f9e3b0b016752b3103d8 ChangeLog 569
+MD5 2e887b575c21c6e15baeb53b67868ba8 ChangeLog 916
 MD5 f8d3d207746da2a3cd14dcaab8daab76 metadata.xml 163
 MD5 7f906690e9022c2c88c1e0165c5a66b5 files/pglb.conf-1.3.0b 49
+MD5 7f906690e9022c2c88c1e0165c5a66b5 files/pglb.conf-1.3.0c 49
 MD5 c16f1a05adaf4c554f5865f72ad1adf5 files/pgcluster.init-1.3.0b 1701
+MD5 36db72f70af827440f74d2c4b8aa0d15 files/pgcluster.init-1.3.0c 1701
 MD5 4ec662a9b662261c08747eb222363214 files/pgreplicate.init-1.3.0b 669
+MD5 a7f52fea43e9a85bfc8d81c27ab760c9 files/pgreplicate.init-1.3.0c 669
 MD5 6c9838e26eae25f8c03081b98dd62408 files/digest-pgcluster-1.3.0b 70
+MD5 c3f16a39a8ce23df03bc691c4a0b7533 files/digest-pgcluster-1.3.0c 70
 MD5 97ea3e76ea30ca5662d0b47de5036f01 files/pgcluster.conf-1.3.0b 392
+MD5 97ea3e76ea30ca5662d0b47de5036f01 files/pgcluster.conf-1.3.0c 392
+MD5 446f978a6ba60f3db6e5e72c51da03a0 files/pgcluster-1.3.0c-gentoo.patch 1853
 MD5 c676056d10d63c6a517095cf993c9eb3 files/pgreplicate.conf-1.3.0b 47
+MD5 c676056d10d63c6a517095cf993c9eb3 files/pgreplicate.conf-1.3.0c 47
 MD5 458e5022c67470ae49700fbf1bb4b915 files/pglb.init-1.3.0b 510
+MD5 befc4d100b36ec187d3997395ec4e6b7 files/pglb.init-1.3.0c 510
 MD5 bda92770ca02e1e04a8ca4fed68e7271 files/pgcluster-1.3.0b-gentoo.patch 1853
diff --git a/dev-db/pgcluster/files/digest-pgcluster-1.3.0c b/dev-db/pgcluster/files/digest-pgcluster-1.3.0c
new file mode 100644
index 000000000000..8cd6c75fabb3
--- /dev/null
+++ b/dev-db/pgcluster/files/digest-pgcluster-1.3.0c
@@ -0,0 +1 @@
+MD5 359ea5e89218e0b255fb4e34b5cc599f pgcluster-1.3.0c.tar.gz 14104466
diff --git a/dev-db/pgcluster/files/pgcluster-1.3.0c-gentoo.patch b/dev-db/pgcluster/files/pgcluster-1.3.0c-gentoo.patch
new file mode 100644
index 000000000000..e54375075029
--- /dev/null
+++ b/dev-db/pgcluster/files/pgcluster-1.3.0c-gentoo.patch
@@ -0,0 +1,42 @@
+diff -Naru pgcluster-1.3.0c.org/src/bin/initdb/initdb.c pgcluster-1.3.0c/src/bin/initdb/initdb.c
+--- pgcluster-1.3.0c.org/src/bin/initdb/initdb.c	2004-11-29 03:05:03.000000000 +0000
++++ pgcluster-1.3.0c/src/bin/initdb/initdb.c	2004-12-04 18:02:43.757485824 +0000
+@@ -2617,13 +2617,7 @@
+ 	get_parent_directory(bin_dir);
+ 	
+ 	printf(_("\nSuccess. You can now start the database server using:\n\n"
+-			 "    %s%s%s%spostmaster -D %s%s%s\n"
+-			 "or\n"
+-			 "    %s%s%s%spg_ctl -D %s%s%s -l logfile start\n\n"),
+-	  QUOTE_PATH, bin_dir, QUOTE_PATH, (strlen(bin_dir) > 0) ? DIR_SEP : "",
+-	  QUOTE_PATH, pg_data_native, QUOTE_PATH,
+-	  QUOTE_PATH, bin_dir, QUOTE_PATH, (strlen(bin_dir) > 0) ? DIR_SEP : "",
+-	  QUOTE_PATH, pg_data_native, QUOTE_PATH);
++		   "/etc/init.d/pgcluster start\n\n"));
+ 
+ 	return 0;
+ }
+diff -Naru pgcluster-1.3.0c.org/src/pgcluster/pglb/Makefile pgcluster-1.3.0c/src/pgcluster/pglb/Makefile
+--- pgcluster-1.3.0c.org/src/pgcluster/pglb/Makefile	2005-02-17 22:59:50.000000000 +0000
++++ pgcluster-1.3.0c/src/pgcluster/pglb/Makefile	2005-02-21 06:58:22.184685524 +0000
+@@ -8,7 +8,7 @@
+ top_builddir = ../../..
+ include $(top_builddir)/src/Makefile.global
+ 
+-confdir := ${exec_prefix}/etc
++confdir := /etc/pgcluster
+ 
+ OBJS= child.o cluster_table.o load_balance.o main.o pool_auth.o \
+ 	pool_connection_pool.o pool_process_query.o pool_stream.o \
+diff -Naru pgcluster-1.3.0c.org/src/pgcluster/pgrp/Makefile pgcluster-1.3.0c/src/pgcluster/pgrp/Makefile
+--- pgcluster-1.3.0c.org/src/pgcluster/pgrp/Makefile	2005-02-17 22:59:49.000000000 +0000
++++ pgcluster-1.3.0c/src/pgcluster/pgrp/Makefile	2005-02-21 05:46:56.000000000 +0000
+@@ -8,7 +8,7 @@
+ top_builddir = ../../..
+ include $(top_builddir)/src/Makefile.global
+ 
+-confdir := ${exec_prefix}/etc
++confdir := /etc/pgcluster
+ 
+ OBJS= cascade.o conf.o main.o recovery.o replicate.o rlog.o
+ 
diff --git a/dev-db/pgcluster/files/pgcluster.conf-1.3.0c b/dev-db/pgcluster/files/pgcluster.conf-1.3.0c
new file mode 100644
index 000000000000..247c8ab87220
--- /dev/null
+++ b/dev-db/pgcluster/files/pgcluster.conf-1.3.0c
@@ -0,0 +1,14 @@
+# PostgreSQL's Database Directory
+PGDATA=/var/lib/postgresql/data
+
+# Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!)
+PGLOG=/var/lib/postgresql/data/postgresql.log
+
+# Run the PostgreSQL user as:
+PGUSER=postgres
+
+# Extra options to run postmaster with.
+# If you want to enable TCP/IP for PostgreSQL, add -i to the following:
+# PGOPTS="-N 1024 -B 2048 -i"
+PGOPTS="-i"
+
diff --git a/dev-db/pgcluster/files/pgcluster.init-1.3.0c b/dev-db/pgcluster/files/pgcluster.init-1.3.0c
new file mode 100644
index 000000000000..ad1f66f183fb
--- /dev/null
+++ b/dev-db/pgcluster/files/pgcluster.init-1.3.0c
@@ -0,0 +1,90 @@
+#!/sbin/runscript
+# Copyright 1999-2005 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/files/pgcluster.init-1.3.0c,v 1.1 2005/05/10 06:40:37 nakano Exp $
+
+opts="${opts} reload"
+
+depend() {
+	use net
+}
+
+checkconfig() {
+	if [ ! -d $PGDATA ]; then
+		eerror "directory not found: $PGDATA"
+		eerror "You should create PGDATA directory first."
+		return 1
+	fi
+}
+
+start_recover() {
+	ebegin "Starting PGCluster"
+	if [ -f $PGDATA/postmaster.pid ]; then
+		rm $PGDATA/postmaster.pid
+	fi
+
+	su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS -R'"
+
+	while :
+	do
+		cnt=$(($cnt + 1))
+		if [ -f "$PGDATA/postmaster.pid" ]; then
+			ret=0
+			break
+		fi
+
+		if [ $cnt -eq 30 ]; then
+			eerror "Please see log file: $PGLOG"
+			ret=1
+			break
+		fi
+		sleep 1
+	done
+	eend $ret
+
+}
+
+start() {
+	checkconfig || return 1
+
+	ebegin "Starting PGCluster"
+	if [ -f $PGDATA/postmaster.pid ]; then
+		rm $PGDATA/postmaster.pid
+	fi
+	su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS'"
+
+	while :
+	do
+		cnt=$(($cnt + 1))
+		if [ -f "$PGDATA/postmaster.pid" ]; then
+			ret=0
+			break
+		fi
+
+		if [ $cnt -eq 30 ]; then
+			eerror "Please see log file: $PGLOG"
+			ret=1
+			break
+		fi
+		sleep 1
+	done
+	eend $ret
+}
+
+stop() {
+	ebegin "Stopping PGCluster"
+	su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
+	eend $?
+}
+
+svc_restart() {
+	ebegin "Restarting PGCluster"
+	su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l '$PGLOG' -o '$PGOPTS'"
+	eend $?
+}
+
+reload() {
+	ebegin "Reloading PGCluster configuration"
+	su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s"
+	eend $?
+}
diff --git a/dev-db/pgcluster/files/pglb.conf-1.3.0c b/dev-db/pgcluster/files/pglb.conf-1.3.0c
new file mode 100644
index 000000000000..37fbd86eb51c
--- /dev/null
+++ b/dev-db/pgcluster/files/pglb.conf-1.3.0c
@@ -0,0 +1,2 @@
+# Run the load balancer user as:
+PGUSER=postgres
diff --git a/dev-db/pgcluster/files/pglb.init-1.3.0c b/dev-db/pgcluster/files/pglb.init-1.3.0c
new file mode 100755
index 000000000000..0aadc3f8d2da
--- /dev/null
+++ b/dev-db/pgcluster/files/pglb.init-1.3.0c
@@ -0,0 +1,20 @@
+#!/sbin/runscript
+# Copyright 1999-2005 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/files/pglb.init-1.3.0c,v 1.1 2005/05/10 06:40:37 nakano Exp $
+
+depend() {
+	use net pgreplicate pgcluster
+}
+
+start() {
+	ebegin "Starting PGCluster Load Balance"
+	su - $PGUSER -c "/usr/bin/pglb -D /etc/pgcluster"
+
+}
+
+stop() {
+	ebegin "Stopping PGCluster Load Balance"
+	su - $PGUSER -c "/usr/bin/pglb -D /etc/pgcluster stop"
+	eend $?
+}
diff --git a/dev-db/pgcluster/files/pgreplicate.conf-1.3.0c b/dev-db/pgcluster/files/pgreplicate.conf-1.3.0c
new file mode 100644
index 000000000000..a6bf02915d7a
--- /dev/null
+++ b/dev-db/pgcluster/files/pgreplicate.conf-1.3.0c
@@ -0,0 +1,2 @@
+# Run the pgreplicate user as:
+PGUSER=postgres
diff --git a/dev-db/pgcluster/files/pgreplicate.init-1.3.0c b/dev-db/pgcluster/files/pgreplicate.init-1.3.0c
new file mode 100755
index 000000000000..a9fc4df04a0b
--- /dev/null
+++ b/dev-db/pgcluster/files/pgreplicate.init-1.3.0c
@@ -0,0 +1,23 @@
+#!/sbin/runscript
+# Copyright 1999-2005 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/files/pgreplicate.init-1.3.0c,v 1.1 2005/05/10 06:40:37 nakano Exp $
+
+depend() {
+	use net
+}
+
+start() {
+	ebegin "Starting PGCluster Replication Server"
+	if [ -f /var/lib/pgcluster/pgreplicate.pid ]; then
+		rm /var/lib/pgcluster/pgreplicate.pid
+	fi
+	su - $PGUSER -c "/usr/bin/pgreplicate -W /var/lib/pgcluster -D /etc/pgcluster"
+	eend $?
+}
+
+stop() {
+	ebegin "Stopping PGCluster Replication Server"
+	su - $PGUSER -c "/usr/bin/pgreplicate -W /var/lib/pgcluster -D /etc/pgcluster stop"
+	eend $?
+}
diff --git a/dev-db/pgcluster/pgcluster-1.3.0c.ebuild b/dev-db/pgcluster/pgcluster-1.3.0c.ebuild
new file mode 100644
index 000000000000..d1c70166496e
--- /dev/null
+++ b/dev-db/pgcluster/pgcluster-1.3.0c.ebuild
@@ -0,0 +1,243 @@
+# Copyright 1999-2005 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/pgcluster/pgcluster-1.3.0c.ebuild,v 1.1 2005/05/10 06:40:37 nakano Exp $
+
+inherit eutils gnuconfig flag-o-matic multilib
+
+DESCRIPTION="the synchronous replication system of the multi-master composition for PostgreSQL"
+HOMEPAGE="http://www.csra.co.jp/~mitani/jpug/pgcluster/en/"
+MY_PV=${PV/_/}
+MY_P=${PN}-${MY_PV}
+SRC_URI="http://pgfoundry.org/frs/download.php/218/${P}.tar.gz"
+
+LICENSE="POSTGRESQL"
+SLOT="0"
+KEYWORDS="~x86 ~ppc ~sparc ~mips ~alpha ~arm ~hppa ~amd64 ~ia64 ~s390 ~ppc64"
+IUSE="ssl nls python tcltk perl libg++ pam readline xml2 zlib pg-intdatetime"
+
+S=${WORKDIR}/${MY_P}
+DEPEND="virtual/libc
+	sys-devel/autoconf
+	>=sys-libs/ncurses-5.2
+	>=sys-devel/bison-1.875
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	readline? ( >=sys-libs/readline-4.1 )
+	tcltk? ( >=dev-lang/tcl-8 >=dev-lang/tk-8.3.3-r1 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt dev-util/pkgconfig )
+	nls? ( sys-devel/gettext )"
+RDEPEND="virtual/libc
+	zlib? ( >=sys-libs/zlib-1.1.3 )
+	tcltk? ( >=dev-lang/tcl-8 )
+	perl? ( >=dev-lang/perl-5.6.1-r2 )
+	python? ( >=dev-lang/python-2.2 )
+	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+	xml2? ( dev-libs/libxml2 dev-libs/libxslt )
+	!dev-db/postgresql"
+
+PG_DIR="/var/lib/postgresql"
+MAX_CONNECTIONS=1024
+
+pkg_setup() {
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
+		PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
+		if [ ${PG_MAJOR} -lt 8 ] || [ ${PG_MAJOR} -eq 8 -a ${PG_MINOR} -lt 0 ] ; then
+			eerror "Postgres ${MY_PV} cannot upgrade your existing databases, you must"
+			eerror "use pg_dump to export your existing databases to a file, and then"
+			eerror "pg_restore to import them when you have upgraded completely."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			exit 1
+		fi
+	fi
+}
+
+src_unpack() {
+	unpack ${A} || die
+	epatch ${FILESDIR}/${P}-gentoo.patch
+}
+
+src_compile() {
+	filter-flags -ffast-math
+
+	local myconf
+	use tcltk && myconf="--with-tcl"
+	use python && myconf="$myconf --with-python"
+	use perl && myconf="$myconf --with-perl"
+	use ssl && myconf="$myconf --with-openssl"
+	use nls && myconf="$myconf --enable-nls"
+	use libg++ && myconf="$myconf --with-CXX"
+	use pam && myconf="$myconf --with-pam"
+	use readline || myconf="$myconf --without-readline"
+	use zlib || myconf="$myconf --without-zlib"
+	use pg-intdatetime && myconf="$myconf --enable-integer-datetimes"
+
+	myconf="$myconf --enable-thread-safety"
+
+	# these are the only working CFLAGS I could get on ppc, so locking them
+	# down, anything more aggressive fails (i.e. -mcpu or -Ox)
+	# Gerk - Nov 26, 2002
+	use ppc && CFLAGS="-pipe -fsigned-char"
+
+	# Detect mips systems properly
+	gnuconfig_update
+
+	./configure --prefix=/usr \
+		--mandir=/usr/share/man \
+		--host=${CHOST} \
+		--with-docdir=/usr/share/doc/${PF} \
+		--libdir=/usr/$(get_libdir) \
+		--enable-depend \
+		--with-gnu-ld \
+		--with-maxbackends=${MAX_CONNECTIONS} \
+		--sysconfdir=/etc \
+		$myconf || die
+
+	make || die
+	cd contrib
+	make || die
+	if use xml2; then
+		cd xml2
+		make || die
+	fi
+}
+
+src_install() {
+	if use perl; then
+		mv ${S}/src/pl/plperl/Makefile ${S}/src/pl/plperl/Makefile_orig
+		sed -e "s:(INST_DYNAMIC) /usr/lib:(INST_DYNAMIC) ${D}/usr/lib:" \
+			${S}/src/pl/plperl/Makefile_orig > ${S}/src/pl/plperl/Makefile
+		mv ${S}/src/pl/plperl/GNUmakefile ${S}/src/pl/plperl/GNUmakefile_orig
+		sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
+			${S}/src/pl/plperl/GNUmakefile_orig > ${S}/src/pl/plperl/GNUmakefile
+	fi
+
+	make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+#	make DESTDIR=${D} install-all-headers || die
+	cd ${S}/contrib
+	make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+	if use xml2; then
+		cd ${S}/contrib/xml2
+		make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
+	fi
+	cd ${S}
+#	if use pg-hier; then
+#		dodoc ${WORKDIR}/README-${P_HIERPG}.html || die
+#	fi
+	dodoc README HISTORY COPYRIGHT INSTALL
+	dodoc contrib/adddepend/*
+
+	exeinto /usr/bin
+
+	dodir /usr/include/postgresql/pgsql
+	cp ${D}/usr/include/*.h ${D}/usr/include/postgresql/pgsql
+
+	cd ${S}/doc
+	dodoc FAQ* README.* TODO bug.template
+	if use doc; then
+		cd ${S}/doc
+		docinto FAQ_html || die
+		dodoc src/FAQ/* || die
+		docinto sgml || die
+		dodoc src/sgml/*.{sgml,dsl} || die
+		docinto sgml/ref || die
+		dodoc src/sgml/ref/*.sgml || die
+		docinto TODO.detail || die
+		dodoc TODO.detail/* || die
+	fi
+
+	mv ${D}/etc/pgcluster/pgreplicate.conf.sample \
+	${D}/etc/pgcluster/pgreplicate.conf
+	mv ${D}/etc/pgcluster/pglb.conf.sample \
+	${D}/etc/pgcluster/pglb.conf
+
+	cd ${S}
+	exeinto /etc/init.d/
+	newexe ${FILESDIR}/pgcluster.init-${PV} pgcluster || die
+	newexe ${FILESDIR}/pglb.init-${PV} pglb || die
+	newexe ${FILESDIR}/pgreplicate.init-${PV} pgreplicate || die
+#	newexe ${FILESDIR}/pg_autovacuum.init-${PV} pg_autovacuum || die
+	dosed "s:___DOCDIR___:/usr/share/doc/${PF}:" /etc/init.d/pg_autovacuum
+
+	insinto /etc/conf.d/
+	newins ${FILESDIR}/pgcluster.conf-${PV} pgcluster || die
+	newins ${FILESDIR}/pglb.conf-${PV} pglb || die
+	newins ${FILESDIR}/pgreplicate.conf-${PV} pgreplicate || die
+#	newins ${FILESDIR}/pg_autovacuum.conf-${PV} pg_autovacuum || die
+
+	keepdir $PG_DIR
+	keepdir /var/log/pgcluster
+	chown -Rf postgres:postgres ${D}/var/log/pgcluster
+
+	keepdir /var/lib/pgcluster
+	chown -Rf postgres:postgres ${D}/var/lib/pgcluster
+
+	chown -Rf postgres:postgres ${D}/etc/pgcluster
+}
+
+pkg_postinst() {
+	einfo "Make sure the postgres user in /etc/passwd has an account setup with /bin/bash as the shell"
+
+	if [ ! -f ${PG_DIR}/data/PG_VERSION ] ; then
+		einfo ""
+		einfo "Execute the following command"
+		einfo "ebuild /var/db/pkg/dev-db/${PF}/${PF}.ebuild config"
+		einfo "to setup the initial database environment."
+	fi
+
+	einfo ""
+	einfo "Python modules was removed from PostgreSQL package."
+	einfo "If you need it, please run \"emerge dev-db/pygresql\"."
+	einfo ""
+}
+
+pkg_config() {
+	einfo "Creating the data directory ..."
+	mkdir -p ${PG_DIR}/data
+	chown -Rf postgres:postgres ${PG_DIR}
+	chmod 700 ${PG_DIR}/data
+
+	einfo "Initializing the database ..."
+	if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
+		eerror "Pgcluster ${MY_PV} cannot upgrade your existing databases."
+		eerror "You must remove your entire database directory to continue."
+		eerror "(database directory = ${PG_DIR})."
+		exit 1
+	else
+		local SEM=`sysctl -n kernel.sem | cut -f-3`
+		local SEMMNI=`sysctl -n kernel.sem | cut -f4`
+		local SEMMNI_MIN=`expr \( ${MAX_CONNECTIONS} + 15 \) / 16`
+		local SHMMAX=`sysctl -n kernel.shmmax`
+		local SHMMAX_MIN=134217728 # 128M
+
+		if [ ${SEMMNI} -lt ${SEMMNI_MIN} ]; then
+			eerror "The current value of SEMMNI is too low"
+			eerror "for postgresql to run ${MAX_CONNECTIONS} connections"
+			eerror "Temporary setting this value to ${SEMMNI_MIN} while creating the initial database."
+			echo ${SEM} ${SEMMNI_MIN} > /proc/sys/kernel/sem
+		fi
+		su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+
+		if [ ! `sysctl -n kernel.sem | cut -f4` -eq ${SEMMNI} ] ; then
+			echo ${SEM} ${SEMMNI} > /proc/sys/kernel/sem
+			ewarn "Restoring the SEMMNI value to the previous value"
+			ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
+			ewarn "and set it to at least ${SEMMNI_MIN}"
+			ewarn ""
+			ewarn "  kernel.sem = ${SEM} ${SEMMNI_MIN}"
+			ewarn ""
+		fi
+
+		if [ ${SHMMAX} -lt ${SHMMAX_MIN} ]; then
+			eerror "The current value of SHMMAX is too low for postgresql to run."
+			eerror "Please edit /etc/sysctl.conf and set this value to at least ${SHMMAX_MIN}."
+			eerror ""
+			eerror "  kernel.shmmax = ${SHMMAX_MIN}"
+			eerror ""
+
+		fi
+	fi
+}