Mercurial > hg > portage

--- a/dev-db/postgresql-base/Manifest	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-AUX postgresql-8.3-base.patch 4130 RMD160 53cf20e4161ac9a9abd14c1a834f2e4508c5b44a SHA1 f58dbfde59f1543c8bd87527a1dfc3356c06db90 SHA256 a3bb8eca2d472a22d744a23d47d829b9931cd5bae2206e90d7e0fac4399927a5
-AUX postgresql-8.3-common.patch 2641 RMD160 0822bf1512457e91d5f32f9d192de6f197db9c55 SHA1 e4bdbd5eee1023e8f0b42ef408b34b57495d1e2b SHA256 e416c26d9c3d266b306ddbc0a2b648054739b7ace35e2b4e449fbdaf094bc197
-AUX postgresql-8.x-relax_ssl_perms.patch 764 RMD160 d1ce5164779c0b0c9229dc13d2eebe6b8c960616 SHA1 f28af41e549bbe3a0b4b8669a2762f71bf3e8a9e SHA256 98bc99954521db083320bd9a6b3a0a5d6eb960af3699527c16e53c567e22394a
-DIST postgresql-8.3.7.tar.bz2 14124712 RMD160 93b9360d83546fff2d5dadfb9ec32ca3ad7984db SHA1 96facdf7229a7f18f016d86ff6cb350ca5d50bd5 SHA256 eee00caf1860646f6c03b4266f2b2b7936e469b3305bd63b80b7b663c0ae1661
-EBUILD postgresql-base-8.3.7.ebuild 4664 RMD160 e131ef0e13d31fd982a739c8fe9c83f199852b56 SHA1 a5e1e81459439d9d683a58aa453209e35c747e48 SHA256 6978b378a20196ffb4851dac809653c6ad7c026fbbd8bc1847824c1e38d3764a
--- a/dev-db/postgresql-base/files/postgresql-8.3-base.patch	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,143 +0,0 @@
-=== contrib/Makefile
-==================================================================
---- contrib/Makefile	(revision 2)
-+++ contrib/Makefile	(local)
-@@ -5,41 +5,10 @@
- include $(top_builddir)/src/Makefile.global
-
- WANTED_DIRS = \
--		adminpack	\
--		btree_gist	\
--		chkpass		\
--		cube		\
--		dblink		\
--		dict_int	\
--		dict_xsyn	\
--		earthdistance	\
--		fuzzystrmatch	\
--		hstore		\
--		intagg		\
--		intarray	\
--		isn		\
--		lo		\
--		ltree		\
- 		oid2name	\
--		pageinspect	\
--		pg_buffercache	\
--		pg_freespacemap \
--		pg_standby	\
--		pg_trgm		\
- 		pgbench		\
--		pgcrypto	\
--		pgrowlocks	\
--		pgstattuple	\
--		seg		\
--		spi		\
--		tablefunc	\
--		test_parser	\
--		tsearch2	\
- 		vacuumlo
-
--ifeq ($(with_openssl),yes)
--WANTED_DIRS += sslinfo
--endif
-
- ifeq ($(with_ossp_uuid),yes)
- WANTED_DIRS += uuid-ossp
-=== src/Makefile
-==================================================================
---- src/Makefile	(revision 2)
-+++ src/Makefile	(local)
-@@ -15,16 +15,11 @@
-
- all install installdirs uninstall distprep:
- 	$(MAKE) -C port $@
--	$(MAKE) -C timezone $@
- 	$(MAKE) -C backend $@
--	$(MAKE) -C backend/utils/mb/conversion_procs $@
--	$(MAKE) -C backend/snowball $@
- 	$(MAKE) -C include $@
- 	$(MAKE) -C interfaces $@
- 	$(MAKE) -C bin $@
--	$(MAKE) -C pl $@
- 	$(MAKE) -C makefiles $@
--	$(MAKE) -C test/regress $@
-
- install: install-local
-
-=== src/backend/Makefile
-==================================================================
---- src/backend/Makefile	(revision 2)
-+++ src/backend/Makefile	(local)
-@@ -34,7 +34,7 @@
-
- ##########################################################################
-
--all: submake-libpgport postgres $(POSTGRES_IMP)
-+all: someheaders
-
- ifneq ($(PORTNAME), cygwin)
- ifneq ($(PORTNAME), win32)
-@@ -107,8 +107,7 @@
-
- .PHONY: $(DIRS:%=%-recursive)
- # Update the commonly used headers before building the subdirectories
--$(DIRS:%=%-recursive): $(top_builddir)/src/include/parser/parse.h $(top_builddir)/src/include/utils/fmgroids.h
--	$(MAKE) -C $(subst -recursive,,$@) all
-+someheaders $(DIRS:%=%-recursive): $(top_builddir)/src/include/parser/parse.h $(top_builddir)/src/include/utils/fmgroids.h
-
-
- # The postgres.o target is needed by the rule in Makefile.global that
-@@ -155,23 +154,7 @@
-
- ##########################################################################
-
--install: all installdirs install-bin
--ifeq ($(PORTNAME), cygwin)
--ifeq ($(MAKE_DLL), true)
--	$(INSTALL_DATA) libpostgres.a '$(DESTDIR)$(libdir)/libpostgres.a'
--endif
--endif
--ifeq ($(PORTNAME), win32)
--ifeq ($(MAKE_DLL), true)
--	$(INSTALL_DATA) libpostgres.a '$(DESTDIR)$(libdir)/libpostgres.a'
--endif
--endif
--	$(MAKE) -C catalog install-data
--	$(MAKE) -C tsearch install-data
--	$(INSTALL_DATA) $(srcdir)/libpq/pg_hba.conf.sample '$(DESTDIR)$(datadir)/pg_hba.conf.sample'
--	$(INSTALL_DATA) $(srcdir)/libpq/pg_ident.conf.sample '$(DESTDIR)$(datadir)/pg_ident.conf.sample'
--	$(INSTALL_DATA) $(srcdir)/utils/misc/postgresql.conf.sample '$(DESTDIR)$(datadir)/postgresql.conf.sample'
--	$(INSTALL_DATA) $(srcdir)/access/transam/recovery.conf.sample '$(DESTDIR)$(datadir)/recovery.conf.sample'
-+install:
-
- install-bin: postgres $(POSTGRES_IMP) installdirs
- 	$(INSTALL_PROGRAM) postgres$(X) '$(DESTDIR)$(bindir)/postgres$(X)'
-=== src/bin/Makefile
-==================================================================
---- src/bin/Makefile	(revision 2)
-+++ src/bin/Makefile	(local)
-@@ -13,8 +13,8 @@
- top_builddir = ../..
- include $(top_builddir)/src/Makefile.global
-
--DIRS = initdb ipcclean pg_ctl pg_dump \
--	psql scripts pg_config pg_controldata pg_resetxlog
-+DIRS = pg_dump \
-+	psql scripts pg_config
- ifeq ($(PORTNAME), win32)
- DIRS+=pgevent
- endif
-=== src/include/pg_config_manual.h
-==================================================================
---- src/include/pg_config_manual.h	(revision 2)
-+++ src/include/pg_config_manual.h	(local)
-@@ -184,7 +184,7 @@
-  * here's where to twiddle it.  You can also override this at runtime
-  * with the postmaster's -k switch.
-  */
--#define DEFAULT_PGSOCKET_DIR  "/tmp"
-+#define DEFAULT_PGSOCKET_DIR  "/var/run/postgresql"
-
- /*
-  * The random() function is expected to yield values between 0 and
--- a/dev-db/postgresql-base/files/postgresql-8.3-common.patch	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,88 +0,0 @@
-diff --git a/config/programs.m4 b/config/programs.m4
-index 9434113..d72b35c 100644
---- a/config/programs.m4
-+++ b/config/programs.m4
-@@ -202,8 +202,12 @@ AC_DEFUN([PGAC_CHECK_GETTEXT],
- dnl FIXME: We should probably check for version >=0.10.36.
-   AC_CHECK_PROGS(XGETTEXT, xgettext)
-
--  # Note: share/locale is always the default, independent of $datadir
--  localedir='${prefix}/share/locale'
-+  # Note: share/locale *WAS* always the default, independent of $datadir
-+  AC_ARG_WITH([locale-dir],
-+   AC_HELP_STRING([--with-locale-dir],[Set path to locale files]),
-+   [ localedir="${withval}" ],
-+   [ localedir='${prefix}/share/locale' ]
-+  )
-   AC_SUBST(localedir)
- ])# PGAC_CHECK_GETTEXT
-
-diff --git a/configure.in b/configure.in
-index 58cc61c..07ffc38 100644
---- a/configure.in
-+++ b/configure.in
-@@ -19,10 +19,6 @@ m4_pattern_forbid(^PGAC_)dnl to catch undefined macros
-
- AC_INIT([PostgreSQL], [8.3RC1], [pgsql-bugs@postgresql.org])
-
--m4_if(m4_defn([m4_PACKAGE_VERSION]), [2.59], [], [m4_fatal([Autoconf version 2.59 is required.
--Untested combinations of 'autoconf' and PostgreSQL versions are not
--recommended.  You can remove the check from 'configure.in' but it is then
--your responsibility whether the result works or not.])])
- AC_COPYRIGHT([Copyright (c) 1996-2008, PostgreSQL Global Development Group])
- AC_CONFIG_SRCDIR([src/backend/access/common/heaptuple.c])
- AC_CONFIG_AUX_DIR(config)
-diff --git a/src/include/storage/s_lock.h b/src/include/storage/s_lock.h
-index 7d9448f..07799bc 100644
---- a/src/include/storage/s_lock.h
-+++ b/src/include/storage/s_lock.h
-@@ -298,6 +298,29 @@ tas(volatile slock_t *lock)
-
- #endif	 /* __s390__ || __s390x__ */
-
-+#if defined(__sh__)
-+#define HAS_TEST_AND_SET
-+
-+typedef unsigned char slock_t;
-+
-+#define TAS(lock) tas(lock)
-+
-+static __inline__ int
-+tas(volatile slock_t *lock)
-+{
-+	register int _res = 1;
-+
-+	__asm__ __volatile__(
-+		"tas.b	@%1\n\t"
-+		"movt	%0\n\t"
-+		"xor	#1,%0"
-+:		"=z"(_res)
-+:		"r"(lock)
-+:		"t","memory");
-+	return _res;
-+}
-+
-+#endif	 /* __sh__ */
-
- #if defined(__sparc__)		/* Sparc */
- #define HAS_TEST_AND_SET
-diff --git a/src/makefiles/Makefile.darwin b/src/makefiles/Makefile.darwin
-index 9f761d4..83b2974 100644
---- a/src/makefiles/Makefile.darwin
-+++ b/src/makefiles/Makefile.darwin
-@@ -5,7 +5,15 @@ DLSUFFIX = .so
- CFLAGS_SL =
-
- ifdef PGXS
-+ifdef PGXS_IN_SERVER
-+ifndef PGXS_WITH_SERVER
-+BE_DLLLIBS= -bundle_loader $(top_builddir)/src/backend/postgres
-+else
-+BE_DLLLIBS= -bundle_loader ${PGXS_WITH_SERVER}
-+endif
-+else
- BE_DLLLIBS= -bundle_loader $(bindir)/postgres
-+endif
- else
- BE_DLLLIBS= -bundle_loader $(top_builddir)/src/backend/postgres
- endif
--- a/dev-db/postgresql-base/files/postgresql-8.x-relax_ssl_perms.patch	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,14 +0,0 @@
-diff -ur postgresql-8.0.15.orig/src/backend/libpq/be-secure.c postgresql-8.0.15/src/backend/libpq/be-secure.c
---- postgresql-8.0.15.orig/src/backend/libpq/be-secure.c	2008-02-21 04:06:04.334289203 +0100
-+++ postgresql-8.0.15/src/backend/libpq/be-secure.c	2008-02-21 04:08:47.309426324 +0100
-@@ -737,8 +737,8 @@
- 		 * data directory permission check in postmaster.c)
- 		 */
- #if !defined(WIN32) && !defined(__CYGWIN__)
--		if (!S_ISREG(buf.st_mode) || (buf.st_mode & (S_IRWXG | S_IRWXO)) ||
--			buf.st_uid != geteuid())
-+		if (!S_ISREG(buf.st_mode) || (buf.st_mode & (S_IWGRP | S_IRWXO)) ||
-+			(buf.st_uid != geteuid()) && buf.st_uid != 0)
- 			ereport(FATAL,
- 					(errcode(ERRCODE_CONFIG_FILE_ERROR),
- 				  errmsg("unsafe permissions on private key file \"%s\"",
--- a/dev-db/postgresql-base/postgresql-base-8.3.7.ebuild	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,148 +0,0 @@
-# Copyright 1999-2008 Gentoo Foundation
-# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-base/postgresql-base-8.3.5.ebuild,v 1.1 2008/12/03 19:21:50 caleb Exp $
-
-EAPI="1"
-
-WANT_AUTOCONF="latest"
-WANT_AUTOMAKE="none"
-
-inherit eutils multilib toolchain-funcs versionator autotools
-
-KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~sh ~sparc ~sparc-fbsd ~x86 ~x86-fbsd"
-
-DESCRIPTION="PostgreSQL libraries and clients"
-HOMEPAGE="http://www.postgresql.org/"
-SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2"
-LICENSE="POSTGRESQL"
-SLOT="$(get_version_component_range 1-2)"
-IUSE_LINGUAS="
-	linguas_af linguas_cs linguas_de linguas_es linguas_fa linguas_fr
-	linguas_hr linguas_hu linguas_it linguas_ko linguas_nb linguas_pl
-	linguas_pt_BR linguas_ro linguas_ru linguas_sk linguas_sl linguas_sv
-	linguas_tr linguas_zh_CN linguas_zh_TW"
-IUSE="doc kerberos nls pam pg-intdatetime readline ssl threads zlib ldap ${IUSE_LINGUAS}"
-RESTRICT="test"
-
-wanted_languages() {
-	for u in ${IUSE_LINGUAS} ; do
-		use $u && echo -n "${u#linguas_} "
-	done
-}
-
-RDEPEND="kerberos? ( virtual/krb5 )
-	pam? ( virtual/pam )
-	readline? ( >=sys-libs/readline-4.1 )
-	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
-	zlib? ( >=sys-libs/zlib-1.1.3 )
-	>=app-admin/eselect-postgresql-0.3
-	!dev-db/postgresql-libs
-	!dev-db/postgresql-client
-	!dev-db/libpq
-	!dev-db/postgresql
-	ldap? ( net-nds/openldap )"
-DEPEND="${RDEPEND}
-	sys-devel/flex
-	>=sys-devel/bison-1.875
-	nls? ( sys-devel/gettext )"
-PDEPEND="doc? ( dev-db/postgresql-docs:${SLOT} )"
-
-S="${WORKDIR}/postgresql-${PV}"
-
-src_unpack() {
-	unpack ${A}
-	cd "${S}"
-
-	epatch "${FILESDIR}/postgresql-${SLOT}-common.patch" \
-		"${FILESDIR}/postgresql-${SLOT}-base.patch" \
-		"${FILESDIR}/postgresql-8.x-relax_ssl_perms.patch"
-
-	# to avoid collision - it only should be installed by server
-	rm "${S}/src/backend/nls.mk"
-
-	# because psql/help.c includes the file
-	ln -s "${S}/src/include/libpq/pqsignal.h" "${S}/src/bin/psql/"
-
-	eautoconf
-}
-
-src_compile() {
-	econf --prefix=/usr/$(get_libdir)/postgresql-${SLOT} \
-		--datadir=/usr/share/postgresql-${SLOT} \
-		--sysconfdir=/etc/postgresql-${SLOT} \
-		--includedir=/usr/include/postgresql-${SLOT} \
-		--with-locale-dir=/usr/share/postgresql-${SLOT}/locale \
-		--mandir=/usr/share/postgresql-${SLOT}/man \
-		--without-docdir \
-		--enable-depend \
-		--without-tcl \
-		--without-perl \
-		--without-python \
-		$(use_with readline) \
-		$(use_with kerberos krb5) \
-		$(use_with kerberos gssapi) \
-		"$(use_enable nls nls "$(wanted_languages)")" \
-		$(use_with pam) \
-		$(use_enable pg-intdatetime integer-datetimes ) \
-		$(use_with ssl openssl) \
-		$(use_enable threads thread-safety) \
-		$(use_enable threads thread-safety-force) \
-		$(use_with zlib) \
-		$(use_with ldap) \
-		${myconf} \
-		|| die "configure failed"
-
-	emake LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "emake failed"
-
-	cd "${S}/contrib"
-	emake LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "emake failed"
-}
-
-src_install() {
-	emake DESTDIR="${D}" install || die "emake install failed"
-	insinto /usr/include/postgresql-${SLOT}/postmaster
-	doins "${S}"/src/include/postmaster/*.h
-	dodir /usr/share/postgresql-${SLOT}/man/man1
-	tar -zxf "${S}/doc/man.tar.gz" -C "${D}"/usr/share/postgresql-${SLOT}/man man1/{ecpg,pg_config}.1
-
-	rm "${D}/usr/share/postgresql-${SLOT}/man/man1"/{initdb,ipcclean,pg_controldata,pg_ctl,pg_resetxlog,pg_restore,postgres,postmaster}.1
-	dodoc README HISTORY doc/{README.*,TODO,bug.template}
-
-	cd "${S}/contrib"
-	emake DESTDIR="${D}" install || die "emake install failed"
-	cd "${S}"
-
-	dodir /etc/eselect/postgresql/slots/${SLOT}
-
-	IDIR="/usr/include/postgresql-${SLOT}"
-	cat > "${D}/etc/eselect/postgresql/slots/${SLOT}/base" <<-__EOF__
-postgres_ebuilds="\${postgres_ebuilds} ${PF}"
-postgres_prefix=/usr/$(get_libdir)/postgresql-${SLOT}
-postgres_datadir=/usr/share/postgresql-${SLOT}
-postgres_bindir=/usr/$(get_libdir)/postgresql-${SLOT}/bin
-postgres_symlinks=(
-	${IDIR} /usr/include/postgresql
-	${IDIR}/libpq-fe.h /usr/include/libpq-fe.h
-	${IDIR}/libpq /usr/include/libpq
-	${IDIR}/postgres_ext.h /usr/include/postgres_ext.h
-)
-__EOF__
-
-	cat >"${T}/50postgresql-94-${SLOT}" <<-__EOF__
-		LDPATH=/usr/$(get_libdir)/postgresql-${SLOT}/$(get_libdir)
-		MANPATH=/usr/share/postgresql-${SLOT}/man
-	__EOF__
-	doenvd "${T}/50postgresql-94-${SLOT}"
-
-	keepdir /etc/postgresql-${SLOT}
-}
-
-pkg_postinst() {
-	eselect postgresql update
-	[[ "$(eselect postgresql show)" = "(none)" ]] && eselect postgresql set ${SLOT}
-	elog "If you need a global psqlrc-file, you can place it in '${ROOT}/etc/postgresql-${SLOT}/'."
-}
-
-pkg_postrm() {
-	eselect postgresql update
-}
--- a/dev-db/postgresql-server/Manifest	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-AUX postgresql-8.3-common.patch 2641 RMD160 0822bf1512457e91d5f32f9d192de6f197db9c55 SHA1 e4bdbd5eee1023e8f0b42ef408b34b57495d1e2b SHA256 e416c26d9c3d266b306ddbc0a2b648054739b7ace35e2b4e449fbdaf094bc197
-AUX postgresql-8.3-server.patch 66296 RMD160 6acd5dec3b411d0439bab47a344406df25c08b7a SHA1 fca417c169d5de6c2ea036ab80a4ce02665ae881 SHA256 74684e07df2ff15f3c10d4f586cd72fba51c996ab9a97b6aee11f79987fc4de6
-AUX postgresql.conf-8.3 1725 RMD160 5bdd027b82013feddcba5d68c09e4122e219ecd2 SHA1 c1bc9ba72623efa12bfad55a0e12a57350955409 SHA256 15cb0f8052d0ecc1bced449777f76875c06ab088f67c1f7f3148b84e97082233
-AUX postgresql.init-8.3 3036 RMD160 9a6e0eab7413b82ccf4bfaf6494b3eaa1abf3c4c SHA1 8896cd60d669bdbc5b76649ee26bb23e2c5c9654 SHA256 0685e2e5ff9b97ff22cdbf590fed0c76cb13b4c087bb961a751fdb4e03fb3dea
-DIST postgresql-8.3.7.tar.bz2 14124712 RMD160 93b9360d83546fff2d5dadfb9ec32ca3ad7984db SHA1 96facdf7229a7f18f016d86ff6cb350ca5d50bd5 SHA256 eee00caf1860646f6c03b4266f2b2b7936e469b3305bd63b80b7b663c0ae1661
-EBUILD postgresql-server-8.3.7.ebuild 9662 RMD160 48e9383552053aca0728635ba977412fedbcfc73 SHA1 8a2076011865de5e03e75f80fc64d61bff70ec92 SHA256 8c6e0a3732d8ce8460155d9862fb8e6720fec95a2e62388ed8011eab9113e2e2
--- a/dev-db/postgresql-server/files/postgresql-8.3-common.patch	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,88 +0,0 @@
-diff --git a/config/programs.m4 b/config/programs.m4
-index 9434113..d72b35c 100644
---- a/config/programs.m4
-+++ b/config/programs.m4
-@@ -202,8 +202,12 @@ AC_DEFUN([PGAC_CHECK_GETTEXT],
- dnl FIXME: We should probably check for version >=0.10.36.
-   AC_CHECK_PROGS(XGETTEXT, xgettext)
-
--  # Note: share/locale is always the default, independent of $datadir
--  localedir='${prefix}/share/locale'
-+  # Note: share/locale *WAS* always the default, independent of $datadir
-+  AC_ARG_WITH([locale-dir],
-+   AC_HELP_STRING([--with-locale-dir],[Set path to locale files]),
-+   [ localedir="${withval}" ],
-+   [ localedir='${prefix}/share/locale' ]
-+  )
-   AC_SUBST(localedir)
- ])# PGAC_CHECK_GETTEXT
-
-diff --git a/configure.in b/configure.in
-index 58cc61c..07ffc38 100644
---- a/configure.in
-+++ b/configure.in
-@@ -19,10 +19,6 @@ m4_pattern_forbid(^PGAC_)dnl to catch undefined macros
-
- AC_INIT([PostgreSQL], [8.3RC1], [pgsql-bugs@postgresql.org])
-
--m4_if(m4_defn([m4_PACKAGE_VERSION]), [2.59], [], [m4_fatal([Autoconf version 2.59 is required.
--Untested combinations of 'autoconf' and PostgreSQL versions are not
--recommended.  You can remove the check from 'configure.in' but it is then
--your responsibility whether the result works or not.])])
- AC_COPYRIGHT([Copyright (c) 1996-2008, PostgreSQL Global Development Group])
- AC_CONFIG_SRCDIR([src/backend/access/common/heaptuple.c])
- AC_CONFIG_AUX_DIR(config)
-diff --git a/src/include/storage/s_lock.h b/src/include/storage/s_lock.h
-index 7d9448f..07799bc 100644
---- a/src/include/storage/s_lock.h
-+++ b/src/include/storage/s_lock.h
-@@ -298,6 +298,29 @@ tas(volatile slock_t *lock)
-
- #endif	 /* __s390__ || __s390x__ */
-
-+#if defined(__sh__)
-+#define HAS_TEST_AND_SET
-+
-+typedef unsigned char slock_t;
-+
-+#define TAS(lock) tas(lock)
-+
-+static __inline__ int
-+tas(volatile slock_t *lock)
-+{
-+	register int _res = 1;
-+
-+	__asm__ __volatile__(
-+		"tas.b	@%1\n\t"
-+		"movt	%0\n\t"
-+		"xor	#1,%0"
-+:		"=z"(_res)
-+:		"r"(lock)
-+:		"t","memory");
-+	return _res;
-+}
-+
-+#endif	 /* __sh__ */
-
- #if defined(__sparc__)		/* Sparc */
- #define HAS_TEST_AND_SET
-diff --git a/src/makefiles/Makefile.darwin b/src/makefiles/Makefile.darwin
-index 9f761d4..83b2974 100644
---- a/src/makefiles/Makefile.darwin
-+++ b/src/makefiles/Makefile.darwin
-@@ -5,7 +5,15 @@ DLSUFFIX = .so
- CFLAGS_SL =
-
- ifdef PGXS
-+ifdef PGXS_IN_SERVER
-+ifndef PGXS_WITH_SERVER
-+BE_DLLLIBS= -bundle_loader $(top_builddir)/src/backend/postgres
-+else
-+BE_DLLLIBS= -bundle_loader ${PGXS_WITH_SERVER}
-+endif
-+else
- BE_DLLLIBS= -bundle_loader $(bindir)/postgres
-+endif
- else
- BE_DLLLIBS= -bundle_loader $(top_builddir)/src/backend/postgres
- endif
--- a/dev-db/postgresql-server/files/postgresql-8.3-server.patch	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,2449 +0,0 @@
-diff -Naur postgresql-8.3.3.orig/contrib/adminpack/Makefile postgresql-8.3.3/contrib/adminpack/Makefile
---- postgresql-8.3.3.orig/contrib/adminpack/Makefile	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/contrib/adminpack/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -1,7 +1,7 @@
- # $PostgreSQL: pgsql/contrib/adminpack/Makefile,v 1.6 2007/11/10 23:59:50 momjian Exp $
-
- MODULE_big = adminpack
--PG_CPPFLAGS = -I$(libpq_srcdir)
-+PG_CPPFLAGS = -I$(libpq_srcdir) -I../../src/include/
- DATA_built = adminpack.sql
- DATA = uninstall_adminpack.sql
- OBJS = adminpack.o
-diff -Naur postgresql-8.3.3.orig/contrib/Makefile postgresql-8.3.3/contrib/Makefile
---- postgresql-8.3.3.orig/contrib/Makefile	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/contrib/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -20,22 +20,19 @@
- 		isn		\
- 		lo		\
- 		ltree		\
--		oid2name	\
- 		pageinspect	\
- 		pg_buffercache	\
- 		pg_freespacemap \
- 		pg_standby	\
- 		pg_trgm		\
--		pgbench		\
- 		pgcrypto	\
- 		pgrowlocks	\
- 		pgstattuple	\
- 		seg		\
- 		spi		\
- 		tablefunc	\
--		test_parser	\
- 		tsearch2	\
--		vacuumlo
-+		test_parser
-
- ifeq ($(with_openssl),yes)
- WANTED_DIRS += sslinfo
-diff -Naur postgresql-8.3.3.orig/contrib/uuid-ossp/Makefile postgresql-8.3.3/contrib/uuid-ossp/Makefile
---- postgresql-8.3.3.orig/contrib/uuid-ossp/Makefile	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/contrib/uuid-ossp/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -1,11 +1,13 @@
- # $PostgreSQL: pgsql/contrib/uuid-ossp/Makefile,v 1.4 2007/11/13 00:13:19 tgl Exp $
-
-+PG_CPPFLAGS += "-DHAVE_OSSP_UUID_H"
-+
- MODULE_big = uuid-ossp
- OBJS = uuid-ossp.o
- DATA_built = uuid-ossp.sql
- DATA = uninstall_uuid-ossp.sql
-
--SHLIB_LINK += $(OSSP_UUID_LIBS)
-+SHLIB_LINK += -lossp-uuid
-
- ifdef USE_PGXS
- PG_CONFIG = pg_config
-diff -Naur postgresql-8.3.3.orig/contrib/xml2/Makefile postgresql-8.3.3/contrib/xml2/Makefile
---- postgresql-8.3.3.orig/contrib/xml2/Makefile	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/contrib/xml2/Makefile	2008-06-14 13:21:32.000000000 +0200
-@@ -4,7 +4,8 @@
-
- OBJS = $(if $(filter -lxslt, $(LIBS)), xpath.o xslt_proc.o, xpath.o)
-
--SHLIB_LINK += $(filter -lxslt, $(LIBS)) $(filter -lxml2, $(LIBS))
-+PG_CPPFLAGS = $(shell xml2-config --cflags)
-+SHLIB_LINK += $(shell xml2-config --libs) $(shell xslt-config --libs)
-
- DATA_built = pgxml.sql
- DATA = uninstall_pgxml.sql
-diff -Naur postgresql-8.3.3.orig/GNUmakefile.in postgresql-8.3.3/GNUmakefile.in
---- postgresql-8.3.3.orig/GNUmakefile.in	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/GNUmakefile.in	2008-06-14 12:57:12.000000000 +0200
-@@ -11,19 +11,16 @@
- all:
- 	$(MAKE) -C doc all
- 	$(MAKE) -C src all
--	$(MAKE) -C config all
- 	@echo "All of PostgreSQL successfully made. Ready to install."
-
- install:
- 	$(MAKE) -C doc $@
- 	$(MAKE) -C src $@
--	$(MAKE) -C config $@
- 	@echo "PostgreSQL installation complete."
-
- installdirs uninstall:
- 	$(MAKE) -C doc $@
- 	$(MAKE) -C src $@
--	$(MAKE) -C config $@
-
- distprep:
- 	$(MAKE) -C doc $@
-diff -Naur postgresql-8.3.3.orig/src/bin/initdb/Makefile postgresql-8.3.3/src/bin/initdb/Makefile
---- postgresql-8.3.3.orig/src/bin/initdb/Makefile	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/bin/initdb/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -14,7 +14,7 @@
- top_builddir = ../../..
- include $(top_builddir)/src/Makefile.global
-
--override CPPFLAGS := -DFRONTEND -I$(libpq_srcdir) $(CPPFLAGS)
-+override CPPFLAGS := -DFRONTEND -I$(top_srcdir)/src/interfaces/libpq $(CPPFLAGS)
-
- OBJS=	initdb.o encnames.o pqsignal.o $(WIN32RES)
-
-diff -Naur postgresql-8.3.3.orig/src/bin/Makefile postgresql-8.3.3/src/bin/Makefile
---- postgresql-8.3.3.orig/src/bin/Makefile	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/bin/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -13,8 +13,8 @@
- top_builddir = ../..
- include $(top_builddir)/src/Makefile.global
-
--DIRS = initdb ipcclean pg_ctl pg_dump \
--	psql scripts pg_config pg_controldata pg_resetxlog
-+DIRS = initdb ipcclean pg_ctl \
-+	pg_controldata pg_resetxlog
- ifeq ($(PORTNAME), win32)
- DIRS+=pgevent
- endif
-diff -Naur postgresql-8.3.3.orig/src/include/pg_config_manual.h postgresql-8.3.3/src/include/pg_config_manual.h
---- postgresql-8.3.3.orig/src/include/pg_config_manual.h	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/src/include/pg_config_manual.h	2008-06-14 12:57:12.000000000 +0200
-@@ -184,7 +184,7 @@
-  * here's where to twiddle it.  You can also override this at runtime
-  * with the postmaster's -k switch.
-  */
--#define DEFAULT_PGSOCKET_DIR  "/tmp"
-+#define DEFAULT_PGSOCKET_DIR  "/var/run/postgresql"
-
- /*
-  * The random() function is expected to yield values between 0 and
-diff -Naur postgresql-8.3.3.orig/src/Makefile postgresql-8.3.3/src/Makefile
---- postgresql-8.3.3.orig/src/Makefile	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -19,14 +19,11 @@
- 	$(MAKE) -C backend $@
- 	$(MAKE) -C backend/utils/mb/conversion_procs $@
- 	$(MAKE) -C backend/snowball $@
--	$(MAKE) -C include $@
--	$(MAKE) -C interfaces $@
- 	$(MAKE) -C bin $@
- 	$(MAKE) -C pl $@
--	$(MAKE) -C makefiles $@
- 	$(MAKE) -C test/regress $@
-
--install: install-local
-+install:
-
- install-local: installdirs-local
- 	$(INSTALL_DATA) Makefile.global '$(DESTDIR)$(pgxsdir)/$(subdir)/Makefile.global'
-diff -Naur postgresql-8.3.3.orig/src/Makefile.global.in postgresql-8.3.3/src/Makefile.global.in
---- postgresql-8.3.3.orig/src/Makefile.global.in	2008-06-14 12:56:41.000000000 +0200
-+++ postgresql-8.3.3/src/Makefile.global.in	2008-06-14 12:57:12.000000000 +0200
-@@ -373,10 +373,8 @@
-
-
- submake-libpq:
--	$(MAKE) -C $(libpq_builddir) all
-
- submake-libpgport:
--	$(MAKE) -C $(top_builddir)/src/port all
-
- .PHONY: submake-libpq submake-libpgport
-
-@@ -419,6 +417,8 @@
-    LDFLAGS += $(PROFILE)
- endif
-
-+CFLAGS += -I${top_srcdir}/src/include
-+
-
- ##########################################################################
- #
-diff -Naur postgresql-8.3.3.orig/src/port/Makefile postgresql-8.3.3/src/port/Makefile
---- postgresql-8.3.3.orig/src/port/Makefile	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/port/Makefile	2008-06-14 12:57:12.000000000 +0200
-@@ -35,11 +35,10 @@
- # foo_srv.o and foo.o are both built from foo.c, but only foo.o has -DFRONTEND
- OBJS_SRV = $(OBJS:%.o=%_srv.o)
-
--all: libpgport.a libpgport_srv.a
-+all: libpgport_srv.a
-
- # libpgport is needed by some contrib
--install: all installdirs
--	$(INSTALL_STLIB) libpgport.a '$(DESTDIR)$(libdir)/libpgport.a'
-+install:
-
- installdirs:
- 	$(mkinstalldirs) '$(DESTDIR)$(libdir)'
-diff -Naur postgresql-8.3.3.orig/src/test/regress/GNUmakefile postgresql-8.3.3/src/test/regress/GNUmakefile
---- postgresql-8.3.3.orig/src/test/regress/GNUmakefile	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/test/regress/GNUmakefile	2008-06-14 12:57:12.000000000 +0200
-@@ -141,7 +141,7 @@
- ##
-
- check: all
--	./pg_regress --temp-install=./tmp_check --top-builddir=$(top_builddir) --srcdir=$(abs_srcdir) --temp-port=$(TEMP_PORT) --schedule=$(srcdir)/parallel_schedule --multibyte=$(MULTIBYTE) --load-language=plpgsql $(MAXCONNOPT) $(NOLOCALE) $(TEMP_CONF)
-+	./pg_regress --temp-install=./tmp_check --top-builddir=$(top_builddir) --srcdir=$(abs_srcdir) --temp-port=$(TEMP_PORT) --schedule=$(srcdir)/parallel_schedule --multibyte=$(MULTIBYTE) --load-language=plpgsql $(MAXCONNOPT) $(NOLOCALE) $(TEMP_CONF) --psqldir=/usr/lib/postgresql-${SLOT}/bin/
-
- installcheck: all
- 	./pg_regress --psqldir=$(PSQLDIR) --schedule=$(srcdir)/serial_schedule --srcdir=$(abs_srcdir) --multibyte=$(MULTIBYTE) --load-language=plpgsql $(NOLOCALE)
-diff -Naur postgresql-8.3.3.orig/src/test/regress/pg_regress.c postgresql-8.3.3/src/test/regress/pg_regress.c
---- postgresql-8.3.3.orig/src/test/regress/pg_regress.c	2008-06-14 12:56:40.000000000 +0200
-+++ postgresql-8.3.3/src/test/regress/pg_regress.c	2008-06-14 12:57:12.000000000 +0200
-@@ -781,9 +781,6 @@
- 		sprintf(tmp, "%s/install/%s", temp_install, datadir);
- 		datadir = tmp;
-
--		/* psql will be installed into temp-install bindir */
--		psqldir = bindir;
--
- 		/*
- 		 * Set up shared library paths to include the temp install.
- 		 *
-@@ -2069,7 +2066,7 @@
- 		 */
- 		snprintf(buf, sizeof(buf),
- 				 SYSTEMQUOTE "\"%s/psql\" -X postgres <%s 2>%s" SYSTEMQUOTE,
--				 bindir, DEVNULL, DEVNULL);
-+				 psqldir, DEVNULL, DEVNULL);
- 		for (i = 0; i < 60; i++)
- 		{
- 			/* Done if psql succeeds */
-diff -Naur postgresql-8.3.3.orig/src/test/regress/pg_regress.c.orig postgresql-8.3.3/src/test/regress/pg_regress.c.orig
---- postgresql-8.3.3.orig/src/test/regress/pg_regress.c.orig	1970-01-01 01:00:00.000000000 +0100
-+++ postgresql-8.3.3/src/test/regress/pg_regress.c.orig	2008-03-31 03:32:01.000000000 +0200
-@@ -0,0 +1,2221 @@
-+/*-------------------------------------------------------------------------
-+ *
-+ * pg_regress --- regression test driver
-+ *
-+ * This is a C implementation of the previous shell script for running
-+ * the regression tests, and should be mostly compatible with it.
-+ * Initial author of C translation: Magnus Hagander
-+ *
-+ * This code is released under the terms of the PostgreSQL License.
-+ *
-+ * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
-+ * Portions Copyright (c) 1994, Regents of the University of California
-+ *
-+ * $PostgreSQL: pgsql/src/test/regress/pg_regress.c,v 1.41.2.2 2008/03/31 01:32:01 tgl Exp $
-+ *
-+ *-------------------------------------------------------------------------
-+ */
-+
-+#include "pg_regress.h"
-+
-+#include <ctype.h>
-+#include <sys/stat.h>
-+#include <sys/wait.h>
-+#include <signal.h>
-+#include <unistd.h>
-+
-+#ifdef HAVE_SYS_RESOURCE_H
-+#include <sys/time.h>
-+#include <sys/resource.h>
-+#endif
-+
-+#include "getopt_long.h"
-+#include "pg_config_paths.h"
-+
-+/* for resultmap we need a list of pairs of strings */
-+typedef struct _resultmap
-+{
-+	char	   *test;
-+	char	   *type;
-+	char	   *resultfile;
-+	struct _resultmap *next;
-+}	_resultmap;
-+
-+/*
-+ * Values obtained from pg_config_paths.h and Makefile.  The PG installation
-+ * paths are only used in temp_install mode: we use these strings to find
-+ * out where "make install" will put stuff under the temp_install directory.
-+ * In non-temp_install mode, the only thing we need is the location of psql,
-+ * which we expect to find in psqldir, or in the PATH if psqldir isn't given.
-+ */
-+char	   *bindir = PGBINDIR;
-+char	   *libdir = LIBDIR;
-+char	   *datadir = PGSHAREDIR;
-+char	   *host_platform = HOST_TUPLE;
-+
-+#ifndef WIN32_ONLY_COMPILER
-+static char *makeprog = MAKEPROG;
-+#endif
-+
-+#ifndef WIN32					/* not used in WIN32 case */
-+static char *shellprog = SHELLPROG;
-+#endif
-+
-+/* currently we can use the same diff switches on all platforms */
-+const char *basic_diff_opts = "-w";
-+const char *pretty_diff_opts = "-w -C3";
-+
-+/* options settable from command line */
-+_stringlist *dblist = NULL;
-+bool		debug = false;
-+char	   *inputdir = ".";
-+char	   *outputdir = ".";
-+char	   *psqldir = NULL;
-+static _stringlist *loadlanguage = NULL;
-+static int	max_connections = 0;
-+static char *encoding = NULL;
-+static _stringlist *schedulelist = NULL;
-+static _stringlist *extra_tests = NULL;
-+static char *temp_install = NULL;
-+static char *temp_config = NULL;
-+static char *top_builddir = NULL;
-+static int	temp_port = 65432;
-+static bool nolocale = false;
-+static char *hostname = NULL;
-+static int	port = -1;
-+static char *user = NULL;
-+static char *srcdir = NULL;
-+static _stringlist *extraroles = NULL;
-+
-+/* internal variables */
-+static const char *progname;
-+static char *logfilename;
-+static FILE *logfile;
-+static char *difffilename;
-+
-+static _resultmap *resultmap = NULL;
-+
-+static PID_TYPE postmaster_pid = INVALID_PID;
-+static bool postmaster_running = false;
-+
-+static int	success_count = 0;
-+static int	fail_count = 0;
-+static int	fail_ignore_count = 0;
-+
-+static bool directory_exists(const char *dir);
-+static void make_directory(const char *dir);
-+
-+static void
-+header(const char *fmt,...)
-+/* This extension allows gcc to check the format string for consistency with
-+   the supplied arguments. */
-+__attribute__((format(printf, 1, 2)));
-+static void
-+status(const char *fmt,...)
-+/* This extension allows gcc to check the format string for consistency with
-+   the supplied arguments. */
-+__attribute__((format(printf, 1, 2)));
-+static void
-+psql_command(const char *database, const char *query,...)
-+/* This extension allows gcc to check the format string for consistency with
-+   the supplied arguments. */
-+__attribute__((format(printf, 2, 3)));
-+
-+#ifdef WIN32
-+typedef		BOOL(WINAPI * __CreateRestrictedToken) (HANDLE, DWORD, DWORD, PSID_AND_ATTRIBUTES, DWORD, PLUID_AND_ATTRIBUTES, DWORD, PSID_AND_ATTRIBUTES, PHANDLE);
-+
-+/* Windows API define missing from MingW headers */
-+#define DISABLE_MAX_PRIVILEGE	0x1
-+#endif
-+
-+/*
-+ * allow core files if possible.
-+ */
-+#if defined(HAVE_GETRLIMIT) && defined(RLIMIT_CORE)
-+static void
-+unlimit_core_size(void)
-+{
-+	struct rlimit lim;
-+
-+	getrlimit(RLIMIT_CORE, &lim);
-+	if (lim.rlim_max == 0)
-+	{
-+		fprintf(stderr,
-+				_("%s: cannot set core size,: disallowed by hard limit.\n"),
-+				progname);
-+		return;
-+	}
-+	else if (lim.rlim_max == RLIM_INFINITY || lim.rlim_cur < lim.rlim_max)
-+	{
-+		lim.rlim_cur = lim.rlim_max;
-+		setrlimit(RLIMIT_CORE, &lim);
-+	}
-+}
-+#endif
-+
-+
-+/*
-+ * Add an item at the end of a stringlist.
-+ */
-+void
-+add_stringlist_item(_stringlist ** listhead, const char *str)
-+{
-+	_stringlist *newentry = malloc(sizeof(_stringlist));
-+	_stringlist *oldentry;
-+
-+	newentry->str = strdup(str);
-+	newentry->next = NULL;
-+	if (*listhead == NULL)
-+		*listhead = newentry;
-+	else
-+	{
-+		for (oldentry = *listhead; oldentry->next; oldentry = oldentry->next)
-+			 /* skip */ ;
-+		oldentry->next = newentry;
-+	}
-+}
-+
-+/*
-+ * Free a stringlist.
-+ */
-+static void
-+free_stringlist(_stringlist ** listhead)
-+{
-+	if (listhead == NULL || *listhead == NULL)
-+		return;
-+	if ((*listhead)->next != NULL)
-+		free_stringlist(&((*listhead)->next));
-+	free((*listhead)->str);
-+	free(*listhead);
-+	*listhead = NULL;
-+}
-+
-+/*
-+ * Split a delimited string into a stringlist
-+ */
-+static void
-+split_to_stringlist(const char *s, const char *delim, _stringlist ** listhead)
-+{
-+	char	   *sc = strdup(s);
-+	char	   *token = strtok(sc, delim);
-+
-+	while (token)
-+	{
-+		add_stringlist_item(listhead, token);
-+		token = strtok(NULL, delim);
-+	}
-+	free(sc);
-+}
-+
-+/*
-+ * Print a progress banner on stdout.
-+ */
-+static void
-+header(const char *fmt,...)
-+{
-+	char		tmp[64];
-+	va_list		ap;
-+
-+	va_start(ap, fmt);
-+	vsnprintf(tmp, sizeof(tmp), fmt, ap);
-+	va_end(ap);
-+
-+	fprintf(stdout, "============== %-38s ==============\n", tmp);
-+	fflush(stdout);
-+}
-+
-+/*
-+ * Print "doing something ..." --- supplied text should not end with newline
-+ */
-+static void
-+status(const char *fmt,...)
-+{
-+	va_list		ap;
-+
-+	va_start(ap, fmt);
-+	vfprintf(stdout, fmt, ap);
-+	fflush(stdout);
-+	va_end(ap);
-+
-+	if (logfile)
-+	{
-+		va_start(ap, fmt);
-+		vfprintf(logfile, fmt, ap);
-+		va_end(ap);
-+	}
-+}
-+
-+/*
-+ * Done "doing something ..."
-+ */
-+static void
-+status_end(void)
-+{
-+	fprintf(stdout, "\n");
-+	fflush(stdout);
-+	if (logfile)
-+		fprintf(logfile, "\n");
-+}
-+
-+/*
-+ * shut down temp postmaster
-+ */
-+static void
-+stop_postmaster(void)
-+{
-+	if (postmaster_running)
-+	{
-+		/* We use pg_ctl to issue the kill and wait for stop */
-+		char		buf[MAXPGPATH * 2];
-+
-+		/* On Windows, system() seems not to force fflush, so... */
-+		fflush(stdout);
-+		fflush(stderr);
-+
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "\"%s/pg_ctl\" stop -D \"%s/data\" -s -m fast" SYSTEMQUOTE,
-+				 bindir, temp_install);
-+		system(buf);			/* ignore exit status */
-+		postmaster_running = false;
-+	}
-+}
-+
-+/*
-+ * Always exit through here, not through plain exit(), to ensure we make
-+ * an effort to shut down a temp postmaster
-+ */
-+void
-+exit_nicely(int code)
-+{
-+	stop_postmaster();
-+	exit(code);
-+}
-+
-+/*
-+ * Check whether string matches pattern
-+ *
-+ * In the original shell script, this function was implemented using expr(1),
-+ * which provides basic regular expressions restricted to match starting at
-+ * the string start (in conventional regex terms, there's an implicit "^"
-+ * at the start of the pattern --- but no implicit "$" at the end).
-+ *
-+ * For now, we only support "." and ".*" as non-literal metacharacters,
-+ * because that's all that anyone has found use for in resultmap.  This
-+ * code could be extended if more functionality is needed.
-+ */
-+static bool
-+string_matches_pattern(const char *str, const char *pattern)
-+{
-+	while (*str && *pattern)
-+	{
-+		if (*pattern == '.' && pattern[1] == '*')
-+		{
-+			pattern += 2;
-+			/* Trailing .* matches everything. */
-+			if (*pattern == '\0')
-+				return true;
-+
-+			/*
-+			 * Otherwise, scan for a text position at which we can match the
-+			 * rest of the pattern.
-+			 */
-+			while (*str)
-+			{
-+				/*
-+				 * Optimization to prevent most recursion: don't recurse
-+				 * unless first pattern char might match this text char.
-+				 */
-+				if (*str == *pattern || *pattern == '.')
-+				{
-+					if (string_matches_pattern(str, pattern))
-+						return true;
-+				}
-+
-+				str++;
-+			}
-+
-+			/*
-+			 * End of text with no match.
-+			 */
-+			return false;
-+		}
-+		else if (*pattern != '.' && *str != *pattern)
-+		{
-+			/*
-+			 * Not the single-character wildcard and no explicit match? Then
-+			 * time to quit...
-+			 */
-+			return false;
-+		}
-+
-+		str++;
-+		pattern++;
-+	}
-+
-+	if (*pattern == '\0')
-+		return true;			/* end of pattern, so declare match */
-+
-+	/* End of input string.  Do we have matching pattern remaining? */
-+	while (*pattern == '.' && pattern[1] == '*')
-+		pattern += 2;
-+	if (*pattern == '\0')
-+		return true;			/* end of pattern, so declare match */
-+
-+	return false;
-+}
-+
-+/*
-+ * Replace all occurances of a string in a string with a different string.
-+ * NOTE: Assumes there is enough room in the target buffer!
-+ */
-+void
-+replace_string(char *string, char *replace, char *replacement)
-+{
-+	char	   *ptr;
-+
-+	while ((ptr = strstr(string, replace)) != NULL)
-+	{
-+		char	   *dup = strdup(string);
-+
-+		strlcpy(string, dup, ptr - string + 1);
-+		strcat(string, replacement);
-+		strcat(string, dup + (ptr - string) + strlen(replace));
-+		free(dup);
-+	}
-+}
-+
-+/*
-+ * Convert *.source found in the "source" directory, replacing certain tokens
-+ * in the file contents with their intended values, and put the resulting files
-+ * in the "dest" directory, replacing the ".source" prefix in their names with
-+ * the given suffix.
-+ */
-+static void
-+convert_sourcefiles_in(char *source, char *dest, char *suffix)
-+{
-+	char		abs_srcdir[MAXPGPATH];
-+	char		abs_builddir[MAXPGPATH];
-+	char		testtablespace[MAXPGPATH];
-+	char		indir[MAXPGPATH];
-+	struct stat	st;
-+	int			ret;
-+	char	  **name;
-+	char	  **names;
-+	int			count = 0;
-+
-+#ifdef WIN32
-+	char	   *c;
-+#endif
-+
-+	if (!getcwd(abs_builddir, sizeof(abs_builddir)))
-+	{
-+		fprintf(stderr, _("%s: could not get current directory: %s\n"),
-+				progname, strerror(errno));
-+		exit_nicely(2);
-+	}
-+
-+	/*
-+	 * in a VPATH build, use the provided source directory; otherwise, use the
-+	 * current directory.
-+	 */
-+	if (srcdir)
-+		strlcpy(abs_srcdir, srcdir, MAXPGPATH);
-+	else
-+		strlcpy(abs_srcdir, abs_builddir, MAXPGPATH);
-+
-+	snprintf(indir, MAXPGPATH, "%s/%s", abs_srcdir, source);
-+
-+	/* Check that indir actually exists and is a directory */
-+	ret = stat(indir, &st);
-+	if (ret != 0 || !S_ISDIR(st.st_mode))
-+	{
-+		/*
-+		 * No warning, to avoid noise in tests that do not have
-+		 * these directories; for example, ecpg, contrib and src/pl.
-+		 */
-+		return;
-+	}
-+
-+	names = pgfnames(indir);
-+	if (!names)
-+		/* Error logged in pgfnames */
-+		exit_nicely(2);
-+
-+#ifdef WIN32
-+	/* in Win32, replace backslashes with forward slashes */
-+	for (c = abs_builddir; *c; c++)
-+		if (*c == '\\')
-+			*c = '/';
-+	for (c = abs_srcdir; *c; c++)
-+		if (*c == '\\')
-+			*c = '/';
-+#endif
-+
-+	snprintf(testtablespace, MAXPGPATH, "%s/testtablespace", abs_builddir);
-+
-+#ifdef WIN32
-+	/*
-+	 * On Windows only, clean out the test tablespace dir, or create it if it
-+	 * doesn't exist.  On other platforms we expect the Makefile to take
-+	 * care of that.  (We don't migrate that functionality in here because
-+	 * it'd be harder to cope with platform-specific issues such as SELinux.)
-+	 *
-+	 * XXX it would be better if pg_regress.c had nothing at all to do with
-+	 * testtablespace, and this were handled by a .BAT file or similar on
-+	 * Windows.  See pgsql-hackers discussion of 2008-01-18.
-+	 */
-+	if (directory_exists(testtablespace))
-+		rmtree(testtablespace, true);
-+	make_directory(testtablespace);
-+#endif
-+
-+	/* finally loop on each file and do the replacement */
-+	for (name = names; *name; name++)
-+	{
-+		char		srcfile[MAXPGPATH];
-+		char		destfile[MAXPGPATH];
-+		char		prefix[MAXPGPATH];
-+		FILE	   *infile,
-+				   *outfile;
-+		char		line[1024];
-+
-+		/* reject filenames not finishing in ".source" */
-+		if (strlen(*name) < 8)
-+			continue;
-+		if (strcmp(*name + strlen(*name) - 7, ".source") != 0)
-+			continue;
-+
-+		count++;
-+
-+		/* build the full actual paths to open */
-+		snprintf(prefix, strlen(*name) - 6, "%s", *name);
-+		snprintf(srcfile, MAXPGPATH, "%s/%s", indir, *name);
-+		snprintf(destfile, MAXPGPATH, "%s/%s.%s", dest, prefix, suffix);
-+
-+		infile = fopen(srcfile, "r");
-+		if (!infile)
-+		{
-+			fprintf(stderr, _("%s: could not open file \"%s\" for reading: %s\n"),
-+					progname, srcfile, strerror(errno));
-+			exit_nicely(2);
-+		}
-+		outfile = fopen(destfile, "w");
-+		if (!outfile)
-+		{
-+			fprintf(stderr, _("%s: could not open file \"%s\" for writing: %s\n"),
-+					progname, destfile, strerror(errno));
-+			exit_nicely(2);
-+		}
-+		while (fgets(line, sizeof(line), infile))
-+		{
-+			replace_string(line, "@abs_srcdir@", abs_srcdir);
-+			replace_string(line, "@abs_builddir@", abs_builddir);
-+			replace_string(line, "@testtablespace@", testtablespace);
-+			replace_string(line, "@DLSUFFIX@", DLSUFFIX);
-+			fputs(line, outfile);
-+		}
-+		fclose(infile);
-+		fclose(outfile);
-+	}
-+
-+	/*
-+	 * If we didn't process any files, complain because it probably means
-+	 * somebody neglected to pass the needed --srcdir argument.
-+	 */
-+	if (count <= 0)
-+	{
-+		fprintf(stderr, _("%s: no *.source files found in %s\n"),
-+				progname, indir);
-+		exit_nicely(2);
-+	}
-+
-+	pgfnames_cleanup(names);
-+}
-+
-+/* Create the .sql and .out files from the .source files, if any */
-+static void
-+convert_sourcefiles(void)
-+{
-+	convert_sourcefiles_in("input", "sql", "sql");
-+	convert_sourcefiles_in("output", "expected", "out");
-+}
-+
-+/*
-+ * Scan resultmap file to find which platform-specific expected files to use.
-+ *
-+ * The format of each line of the file is
-+ *		   testname/hostplatformpattern=substitutefile
-+ * where the hostplatformpattern is evaluated per the rules of expr(1),
-+ * namely, it is a standard regular expression with an implicit ^ at the start.
-+ * (We currently support only a very limited subset of regular expressions,
-+ * see string_matches_pattern() above.)  What hostplatformpattern will be
-+ * matched against is the config.guess output.	(In the shell-script version,
-+ * we also provided an indication of whether gcc or another compiler was in
-+ * use, but that facility isn't used anymore.)
-+ */
-+static void
-+load_resultmap(void)
-+{
-+	char		buf[MAXPGPATH];
-+	FILE	   *f;
-+
-+	/* scan the file ... */
-+	snprintf(buf, sizeof(buf), "%s/resultmap", inputdir);
-+	f = fopen(buf, "r");
-+	if (!f)
-+	{
-+		/* OK if it doesn't exist, else complain */
-+		if (errno == ENOENT)
-+			return;
-+		fprintf(stderr, _("%s: could not open file \"%s\" for reading: %s\n"),
-+				progname, buf, strerror(errno));
-+		exit_nicely(2);
-+	}
-+
-+	while (fgets(buf, sizeof(buf), f))
-+	{
-+		char	   *platform;
-+		char	   *file_type;
-+		char	   *expected;
-+		int			i;
-+
-+		/* strip trailing whitespace, especially the newline */
-+		i = strlen(buf);
-+		while (i > 0 && isspace((unsigned char) buf[i - 1]))
-+			buf[--i] = '\0';
-+
-+		/* parse out the line fields */
-+		file_type = strchr(buf, ':');
-+		if (!file_type)
-+		{
-+			fprintf(stderr, _("incorrectly formatted resultmap entry: %s\n"),
-+					buf);
-+			exit_nicely(2);
-+		}
-+		*file_type++ = '\0';
-+
-+		platform = strchr(file_type, ':');
-+		if (!platform)
-+		{
-+			fprintf(stderr, _("incorrectly formatted resultmap entry: %s\n"),
-+					buf);
-+			exit_nicely(2);
-+		}
-+		*platform++ = '\0';
-+		expected = strchr(platform, '=');
-+		if (!expected)
-+		{
-+			fprintf(stderr, _("incorrectly formatted resultmap entry: %s\n"),
-+					buf);
-+			exit_nicely(2);
-+		}
-+		*expected++ = '\0';
-+
-+		/*
-+		 * if it's for current platform, save it in resultmap list. Note: by
-+		 * adding at the front of the list, we ensure that in ambiguous cases,
-+		 * the last match in the resultmap file is used. This mimics the
-+		 * behavior of the old shell script.
-+		 */
-+		if (string_matches_pattern(host_platform, platform))
-+		{
-+			_resultmap *entry = malloc(sizeof(_resultmap));
-+
-+			entry->test = strdup(buf);
-+			entry->type = strdup(file_type);
-+			entry->resultfile = strdup(expected);
-+			entry->next = resultmap;
-+			resultmap = entry;
-+		}
-+	}
-+	fclose(f);
-+}
-+
-+/*
-+ * Check in resultmap if we should be looking at a different file
-+ */
-+static
-+const char *
-+get_expectfile(const char *testname, const char *file)
-+{
-+	char	   *file_type;
-+	_resultmap *rm;
-+
-+	/*
-+	 * Determine the file type from the file name. This is just what is
-+	 * following the last dot in the file name.
-+	 */
-+	if (!file || !(file_type = strrchr(file, '.')))
-+		return NULL;
-+
-+	file_type++;
-+
-+	for (rm = resultmap; rm != NULL; rm = rm->next)
-+	{
-+		if (strcmp(testname, rm->test) == 0 && strcmp(file_type, rm->type) == 0)
-+		{
-+			return rm->resultfile;
-+		}
-+	}
-+
-+	return NULL;
-+}
-+
-+/*
-+ * Handy subroutine for setting an environment variable "var" to "val"
-+ */
-+static void
-+doputenv(const char *var, const char *val)
-+{
-+	char	   *s = malloc(strlen(var) + strlen(val) + 2);
-+
-+	sprintf(s, "%s=%s", var, val);
-+	putenv(s);
-+}
-+
-+/*
-+ * Set the environment variable "pathname", prepending "addval" to its
-+ * old value (if any).
-+ */
-+static void
-+add_to_path(const char *pathname, char separator, const char *addval)
-+{
-+	char	   *oldval = getenv(pathname);
-+	char	   *newval;
-+
-+	if (!oldval || !oldval[0])
-+	{
-+		/* no previous value */
-+		newval = malloc(strlen(pathname) + strlen(addval) + 2);
-+		sprintf(newval, "%s=%s", pathname, addval);
-+	}
-+	else
-+	{
-+		newval = malloc(strlen(pathname) + strlen(addval) + strlen(oldval) + 3);
-+		sprintf(newval, "%s=%s%c%s", pathname, addval, separator, oldval);
-+	}
-+	putenv(newval);
-+}
-+
-+/*
-+ * Prepare environment variables for running regression tests
-+ */
-+static void
-+initialize_environment(void)
-+{
-+	char	   *tmp;
-+
-+	/*
-+	 * Clear out any non-C locale settings
-+	 */
-+	unsetenv("LC_COLLATE");
-+	unsetenv("LC_CTYPE");
-+	unsetenv("LC_MONETARY");
-+	unsetenv("LC_MESSAGES");
-+	unsetenv("LC_NUMERIC");
-+	unsetenv("LC_TIME");
-+	unsetenv("LC_ALL");
-+	unsetenv("LANG");
-+	unsetenv("LANGUAGE");
-+	/* On Windows the default locale cannot be English, so force it */
-+#if defined(WIN32) || defined(__CYGWIN__)
-+	putenv("LANG=en");
-+#endif
-+
-+	/*
-+	 * Set multibyte as requested
-+	 */
-+	if (encoding)
-+		doputenv("PGCLIENTENCODING", encoding);
-+	else
-+		unsetenv("PGCLIENTENCODING");
-+
-+	/*
-+	 * Set timezone and datestyle for datetime-related tests
-+	 */
-+	putenv("PGTZ=PST8PDT");
-+	putenv("PGDATESTYLE=Postgres, MDY");
-+
-+	if (temp_install)
-+	{
-+		/*
-+		 * Clear out any environment vars that might cause psql to connect to
-+		 * the wrong postmaster, or otherwise behave in nondefault ways. (Note
-+		 * we also use psql's -X switch consistently, so that ~/.psqlrc files
-+		 * won't mess things up.)  Also, set PGPORT to the temp port, and set
-+		 * or unset PGHOST depending on whether we are using TCP or Unix
-+		 * sockets.
-+		 */
-+		unsetenv("PGDATABASE");
-+		unsetenv("PGUSER");
-+		unsetenv("PGSERVICE");
-+		unsetenv("PGSSLMODE");
-+		unsetenv("PGREQUIRESSL");
-+		unsetenv("PGCONNECT_TIMEOUT");
-+		unsetenv("PGDATA");
-+		if (hostname != NULL)
-+			doputenv("PGHOST", hostname);
-+		else
-+			unsetenv("PGHOST");
-+		unsetenv("PGHOSTADDR");
-+		if (port != -1)
-+		{
-+			char		s[16];
-+
-+			sprintf(s, "%d", port);
-+			doputenv("PGPORT", s);
-+		}
-+
-+		/*
-+		 * Adjust path variables to point into the temp-install tree
-+		 */
-+		tmp = malloc(strlen(temp_install) + 32 + strlen(bindir));
-+		sprintf(tmp, "%s/install/%s", temp_install, bindir);
-+		bindir = tmp;
-+
-+		tmp = malloc(strlen(temp_install) + 32 + strlen(libdir));
-+		sprintf(tmp, "%s/install/%s", temp_install, libdir);
-+		libdir = tmp;
-+
-+		tmp = malloc(strlen(temp_install) + 32 + strlen(datadir));
-+		sprintf(tmp, "%s/install/%s", temp_install, datadir);
-+		datadir = tmp;
-+
-+		/* psql will be installed into temp-install bindir */
-+		psqldir = bindir;
-+
-+		/*
-+		 * Set up shared library paths to include the temp install.
-+		 *
-+		 * LD_LIBRARY_PATH covers many platforms.  DYLD_LIBRARY_PATH works on
-+		 * Darwin, and maybe other Mach-based systems.	LIBPATH is for AIX.
-+		 * Windows needs shared libraries in PATH (only those linked into
-+		 * executables, not dlopen'ed ones). Feel free to account for others
-+		 * as well.
-+		 */
-+		add_to_path("LD_LIBRARY_PATH", ':', libdir);
-+		add_to_path("DYLD_LIBRARY_PATH", ':', libdir);
-+		add_to_path("LIBPATH", ':', libdir);
-+#if defined(WIN32) || defined(__CYGWIN__)
-+		add_to_path("PATH", ';', libdir);
-+#endif
-+	}
-+	else
-+	{
-+		const char *pghost;
-+		const char *pgport;
-+
-+		/*
-+		 * When testing an existing install, we honor existing environment
-+		 * variables, except if they're overridden by command line options.
-+		 */
-+		if (hostname != NULL)
-+		{
-+			doputenv("PGHOST", hostname);
-+			unsetenv("PGHOSTADDR");
-+		}
-+		if (port != -1)
-+		{
-+			char		s[16];
-+
-+			sprintf(s, "%d", port);
-+			doputenv("PGPORT", s);
-+		}
-+		if (user != NULL)
-+			doputenv("PGUSER", user);
-+
-+		/*
-+		 * Report what we're connecting to
-+		 */
-+		pghost = getenv("PGHOST");
-+		pgport = getenv("PGPORT");
-+#ifndef HAVE_UNIX_SOCKETS
-+		if (!pghost)
-+			pghost = "localhost";
-+#endif
-+
-+		if (pghost && pgport)
-+			printf(_("(using postmaster on %s, port %s)\n"), pghost, pgport);
-+		if (pghost && !pgport)
-+			printf(_("(using postmaster on %s, default port)\n"), pghost);
-+		if (!pghost && pgport)
-+			printf(_("(using postmaster on Unix socket, port %s)\n"), pgport);
-+		if (!pghost && !pgport)
-+			printf(_("(using postmaster on Unix socket, default port)\n"));
-+	}
-+
-+	convert_sourcefiles();
-+	load_resultmap();
-+}
-+
-+/*
-+ * Issue a command via psql, connecting to the specified database
-+ *
-+ * Since we use system(), this doesn't return until the operation finishes
-+ */
-+static void
-+psql_command(const char *database, const char *query,...)
-+{
-+	char		query_formatted[1024];
-+	char		query_escaped[2048];
-+	char		psql_cmd[MAXPGPATH + 2048];
-+	va_list		args;
-+	char	   *s;
-+	char	   *d;
-+
-+	/* Generate the query with insertion of sprintf arguments */
-+	va_start(args, query);
-+	vsnprintf(query_formatted, sizeof(query_formatted), query, args);
-+	va_end(args);
-+
-+	/* Now escape any shell double-quote metacharacters */
-+	d = query_escaped;
-+	for (s = query_formatted; *s; s++)
-+	{
-+		if (strchr("\\\"$`", *s))
-+			*d++ = '\\';
-+		*d++ = *s;
-+	}
-+	*d = '\0';
-+
-+	/* And now we can build and execute the shell command */
-+	snprintf(psql_cmd, sizeof(psql_cmd),
-+			 SYSTEMQUOTE "\"%s%spsql\" -X -c \"%s\" \"%s\"" SYSTEMQUOTE,
-+			 psqldir ? psqldir : "",
-+			 psqldir ? "/" : "",
-+			 query_escaped,
-+			 database);
-+
-+	if (system(psql_cmd) != 0)
-+	{
-+		/* psql probably already reported the error */
-+		fprintf(stderr, _("command failed: %s\n"), psql_cmd);
-+		exit_nicely(2);
-+	}
-+}
-+
-+/*
-+ * Spawn a process to execute the given shell command; don't wait for it
-+ *
-+ * Returns the process ID (or HANDLE) so we can wait for it later
-+ */
-+PID_TYPE
-+spawn_process(const char *cmdline)
-+{
-+#ifndef WIN32
-+	pid_t		pid;
-+
-+	/*
-+	 * Must flush I/O buffers before fork.	Ideally we'd use fflush(NULL) here
-+	 * ... does anyone still care about systems where that doesn't work?
-+	 */
-+	fflush(stdout);
-+	fflush(stderr);
-+	if (logfile)
-+		fflush(logfile);
-+
-+	pid = fork();
-+	if (pid == -1)
-+	{
-+		fprintf(stderr, _("%s: could not fork: %s\n"),
-+				progname, strerror(errno));
-+		exit_nicely(2);
-+	}
-+	if (pid == 0)
-+	{
-+		/*
-+		 * In child
-+		 *
-+		 * Instead of using system(), exec the shell directly, and tell it to
-+		 * "exec" the command too.	This saves two useless processes per
-+		 * parallel test case.
-+		 */
-+		char	   *cmdline2 = malloc(strlen(cmdline) + 6);
-+
-+		sprintf(cmdline2, "exec %s", cmdline);
-+		execl(shellprog, shellprog, "-c", cmdline2, (char *) NULL);
-+		fprintf(stderr, _("%s: could not exec \"%s\": %s\n"),
-+				progname, shellprog, strerror(errno));
-+		exit(1);				/* not exit_nicely here... */
-+	}
-+	/* in parent */
-+	return pid;
-+#else
-+	char	   *cmdline2;
-+	BOOL		b;
-+	STARTUPINFO si;
-+	PROCESS_INFORMATION pi;
-+	HANDLE		origToken;
-+	HANDLE		restrictedToken;
-+	SID_IDENTIFIER_AUTHORITY NtAuthority = {SECURITY_NT_AUTHORITY};
-+	SID_AND_ATTRIBUTES dropSids[2];
-+	__CreateRestrictedToken _CreateRestrictedToken = NULL;
-+	HANDLE		Advapi32Handle;
-+
-+	ZeroMemory(&si, sizeof(si));
-+	si.cb = sizeof(si);
-+
-+	Advapi32Handle = LoadLibrary("ADVAPI32.DLL");
-+	if (Advapi32Handle != NULL)
-+	{
-+		_CreateRestrictedToken = (__CreateRestrictedToken) GetProcAddress(Advapi32Handle, "CreateRestrictedToken");
-+	}
-+
-+	if (_CreateRestrictedToken == NULL)
-+	{
-+		if (Advapi32Handle != NULL)
-+			FreeLibrary(Advapi32Handle);
-+		fprintf(stderr, "ERROR: cannot create restricted tokens on this platform\n");
-+		exit_nicely(2);
-+	}
-+
-+	/* Open the current token to use as base for the restricted one */
-+	if (!OpenProcessToken(GetCurrentProcess(), TOKEN_ALL_ACCESS, &origToken))
-+	{
-+		fprintf(stderr, "could not open process token: %lu\n", GetLastError());
-+		exit_nicely(2);
-+	}
-+
-+	/* Allocate list of SIDs to remove */
-+	ZeroMemory(&dropSids, sizeof(dropSids));
-+	if (!AllocateAndInitializeSid(&NtAuthority, 2,
-+								  SECURITY_BUILTIN_DOMAIN_RID, DOMAIN_ALIAS_RID_ADMINS, 0, 0, 0, 0, 0, 0, &dropSids[0].Sid) ||
-+		!AllocateAndInitializeSid(&NtAuthority, 2,
-+								  SECURITY_BUILTIN_DOMAIN_RID, DOMAIN_ALIAS_RID_POWER_USERS, 0, 0, 0, 0, 0, 0, &dropSids[1].Sid))
-+	{
-+		fprintf(stderr, "could not allocate SIDs: %lu\n", GetLastError());
-+		exit_nicely(2);
-+	}
-+
-+	b = _CreateRestrictedToken(origToken,
-+							   DISABLE_MAX_PRIVILEGE,
-+							   sizeof(dropSids) / sizeof(dropSids[0]),
-+							   dropSids,
-+							   0, NULL,
-+							   0, NULL,
-+							   &restrictedToken);
-+
-+	FreeSid(dropSids[1].Sid);
-+	FreeSid(dropSids[0].Sid);
-+	CloseHandle(origToken);
-+	FreeLibrary(Advapi32Handle);
-+
-+	if (!b)
-+	{
-+		fprintf(stderr, "could not create restricted token: %lu\n", GetLastError());
-+		exit_nicely(2);
-+	}
-+
-+	cmdline2 = malloc(strlen(cmdline) + 8);
-+	sprintf(cmdline2, "cmd /c %s", cmdline);
-+
-+	if (!CreateProcessAsUser(restrictedToken,
-+						NULL,
-+						cmdline2,
-+						NULL,
-+						NULL,
-+						TRUE,
-+						CREATE_SUSPENDED,
-+						NULL,
-+						NULL,
-+						&si,
-+						&pi))
-+	{
-+		fprintf(stderr, _("could not start process for \"%s\": %lu\n"),
-+				cmdline2, GetLastError());
-+		exit_nicely(2);
-+	}
-+
-+#ifndef __CYGWIN__
-+	AddUserToDacl(pi.hProcess);
-+#endif
-+
-+	free(cmdline2);
-+
-+    ResumeThread(pi.hThread);
-+	CloseHandle(pi.hThread);
-+	return pi.hProcess;
-+#endif
-+}
-+
-+/*
-+ * Count bytes in file
-+ */
-+static long
-+file_size(const char *file)
-+{
-+	long		r;
-+	FILE	   *f = fopen(file, "r");
-+
-+	if (!f)
-+	{
-+		fprintf(stderr, _("%s: could not open file \"%s\" for reading: %s\n"),
-+				progname, file, strerror(errno));
-+		return -1;
-+	}
-+	fseek(f, 0, SEEK_END);
-+	r = ftell(f);
-+	fclose(f);
-+	return r;
-+}
-+
-+/*
-+ * Count lines in file
-+ */
-+static int
-+file_line_count(const char *file)
-+{
-+	int			c;
-+	int			l = 0;
-+	FILE	   *f = fopen(file, "r");
-+
-+	if (!f)
-+	{
-+		fprintf(stderr, _("%s: could not open file \"%s\" for reading: %s\n"),
-+				progname, file, strerror(errno));
-+		return -1;
-+	}
-+	while ((c = fgetc(f)) != EOF)
-+	{
-+		if (c == '\n')
-+			l++;
-+	}
-+	fclose(f);
-+	return l;
-+}
-+
-+static bool
-+file_exists(const char *file)
-+{
-+	FILE	   *f = fopen(file, "r");
-+
-+	if (!f)
-+		return false;
-+	fclose(f);
-+	return true;
-+}
-+
-+static bool
-+directory_exists(const char *dir)
-+{
-+	struct stat st;
-+
-+	if (stat(dir, &st) != 0)
-+		return false;
-+	if (S_ISDIR(st.st_mode))
-+		return true;
-+	return false;
-+}
-+
-+/* Create a directory */
-+static void
-+make_directory(const char *dir)
-+{
-+	if (mkdir(dir, S_IRWXU | S_IRWXG | S_IRWXO) < 0)
-+	{
-+		fprintf(stderr, _("%s: could not create directory \"%s\": %s\n"),
-+				progname, dir, strerror(errno));
-+		exit_nicely(2);
-+	}
-+}
-+
-+/*
-+ * In: filename.ext, Return: filename_i.ext, where 0 < i <= 9
-+ */
-+static char *
-+get_alternative_expectfile(const char *expectfile, int i)
-+{
-+	char	   *last_dot;
-+	int			ssize = strlen(expectfile) + 2 + 1;
-+	char	   *tmp = (char *) malloc(ssize);
-+	char	   *s = (char *) malloc(ssize);
-+
-+	strcpy(tmp, expectfile);
-+	last_dot = strrchr(tmp, '.');
-+	if (!last_dot)
-+		return NULL;
-+	*last_dot = '\0';
-+	snprintf(s, ssize, "%s_%d.%s", tmp, i, last_dot + 1);
-+	free(tmp);
-+	return s;
-+}
-+
-+/*
-+ * Run a "diff" command and also check that it didn't crash
-+ */
-+static int
-+run_diff(const char *cmd, const char *filename)
-+{
-+	int			r;
-+
-+	r = system(cmd);
-+	if (!WIFEXITED(r) || WEXITSTATUS(r) > 1)
-+	{
-+		fprintf(stderr, _("diff command failed with status %d: %s\n"), r, cmd);
-+		exit_nicely(2);
-+	}
-+#ifdef WIN32
-+
-+	/*
-+	 * On WIN32, if the 'diff' command cannot be found, system() returns 1,
-+	 * but produces nothing to stdout, so we check for that here.
-+	 */
-+	if (WEXITSTATUS(r) == 1 && file_size(filename) <= 0)
-+	{
-+		fprintf(stderr, _("diff command not found: %s\n"), cmd);
-+		exit_nicely(2);
-+	}
-+#endif
-+
-+	return WEXITSTATUS(r);
-+}
-+
-+/*
-+ * Check the actual result file for the given test against expected results
-+ *
-+ * Returns true if different (failure), false if correct match found.
-+ * In the true case, the diff is appended to the diffs file.
-+ */
-+static bool
-+results_differ(const char *testname, const char *resultsfile, const char *default_expectfile)
-+{
-+	char		expectfile[MAXPGPATH];
-+	char		diff[MAXPGPATH];
-+	char		cmd[MAXPGPATH * 3];
-+	char		best_expect_file[MAXPGPATH];
-+	FILE	   *difffile;
-+	int			best_line_count;
-+	int			i;
-+	int			l;
-+	const char *platform_expectfile;
-+
-+	/*
-+	 * We can pass either the resultsfile or the expectfile, they should have
-+	 * the same type (filename.type) anyway.
-+	 */
-+	platform_expectfile = get_expectfile(testname, resultsfile);
-+
-+	strcpy(expectfile, default_expectfile);
-+	if (platform_expectfile)
-+	{
-+		/*
-+		 * Replace everything afer the last slash in expectfile with what the
-+		 * platform_expectfile contains.
-+		 */
-+		char	   *p = strrchr(expectfile, '/');
-+
-+		if (p)
-+			strcpy(++p, platform_expectfile);
-+	}
-+
-+	/* Name to use for temporary diff file */
-+	snprintf(diff, sizeof(diff), "%s.diff", resultsfile);
-+
-+	/* OK, run the diff */
-+	snprintf(cmd, sizeof(cmd),
-+			 SYSTEMQUOTE "diff %s \"%s\" \"%s\" > \"%s\"" SYSTEMQUOTE,
-+			 basic_diff_opts, expectfile, resultsfile, diff);
-+
-+	/* Is the diff file empty? */
-+	if (run_diff(cmd, diff) == 0)
-+	{
-+		unlink(diff);
-+		return false;
-+	}
-+
-+	/* There may be secondary comparison files that match better */
-+	best_line_count = file_line_count(diff);
-+	strcpy(best_expect_file, expectfile);
-+
-+	for (i = 0; i <= 9; i++)
-+	{
-+		char	   *alt_expectfile;
-+
-+		alt_expectfile = get_alternative_expectfile(expectfile, i);
-+		if (!file_exists(alt_expectfile))
-+			continue;
-+
-+		snprintf(cmd, sizeof(cmd),
-+				 SYSTEMQUOTE "diff %s \"%s\" \"%s\" > \"%s\"" SYSTEMQUOTE,
-+				 basic_diff_opts, alt_expectfile, resultsfile, diff);
-+
-+		if (run_diff(cmd, diff) == 0)
-+		{
-+			unlink(diff);
-+			return false;
-+		}
-+
-+		l = file_line_count(diff);
-+		if (l < best_line_count)
-+		{
-+			/* This diff was a better match than the last one */
-+			best_line_count = l;
-+			strcpy(best_expect_file, alt_expectfile);
-+		}
-+		free(alt_expectfile);
-+	}
-+
-+	/*
-+	 * fall back on the canonical results file if we haven't tried it yet and
-+	 * haven't found a complete match yet.
-+	 */
-+
-+	if (platform_expectfile)
-+	{
-+		snprintf(cmd, sizeof(cmd),
-+				 SYSTEMQUOTE "diff %s \"%s\" \"%s\" > \"%s\"" SYSTEMQUOTE,
-+				 basic_diff_opts, default_expectfile, resultsfile, diff);
-+
-+		if (run_diff(cmd, diff) == 0)
-+		{
-+			/* No diff = no changes = good */
-+			unlink(diff);
-+			return false;
-+		}
-+
-+		l = file_line_count(diff);
-+		if (l < best_line_count)
-+		{
-+			/* This diff was a better match than the last one */
-+			best_line_count = l;
-+			strcpy(best_expect_file, default_expectfile);
-+		}
-+	}
-+
-+	/*
-+	 * Use the best comparison file to generate the "pretty" diff, which we
-+	 * append to the diffs summary file.
-+	 */
-+	snprintf(cmd, sizeof(cmd),
-+			 SYSTEMQUOTE "diff %s \"%s\" \"%s\" >> \"%s\"" SYSTEMQUOTE,
-+			 pretty_diff_opts, best_expect_file, resultsfile, difffilename);
-+	run_diff(cmd, difffilename);
-+
-+	/* And append a separator */
-+	difffile = fopen(difffilename, "a");
-+	if (difffile)
-+	{
-+		fprintf(difffile,
-+				"\n======================================================================\n\n");
-+		fclose(difffile);
-+	}
-+
-+	unlink(diff);
-+	return true;
-+}
-+
-+/*
-+ * Wait for specified subprocesses to finish
-+ *
-+ * If names isn't NULL, report each subprocess as it finishes
-+ *
-+ * Note: it's OK to scribble on the pids array, but not on the names array
-+ */
-+static void
-+wait_for_tests(PID_TYPE * pids, char **names, int num_tests)
-+{
-+	int			tests_left;
-+	int			i;
-+
-+#ifdef WIN32
-+	PID_TYPE   *active_pids = malloc(num_tests * sizeof(PID_TYPE));
-+
-+	memcpy(active_pids, pids, num_tests * sizeof(PID_TYPE));
-+#endif
-+
-+	tests_left = num_tests;
-+	while (tests_left > 0)
-+	{
-+		PID_TYPE	p;
-+
-+#ifndef WIN32
-+		p = wait(NULL);
-+
-+		if (p == INVALID_PID)
-+		{
-+			fprintf(stderr, _("failed to wait for subprocesses: %s\n"),
-+					strerror(errno));
-+			exit_nicely(2);
-+		}
-+#else
-+		int			r;
-+
-+		r = WaitForMultipleObjects(tests_left, active_pids, FALSE, INFINITE);
-+		if (r < WAIT_OBJECT_0 || r >= WAIT_OBJECT_0 + tests_left)
-+		{
-+			fprintf(stderr, _("failed to wait for subprocesses: %lu\n"),
-+					GetLastError());
-+			exit_nicely(2);
-+		}
-+		p = active_pids[r - WAIT_OBJECT_0];
-+		/* compact the active_pids array */
-+		active_pids[r - WAIT_OBJECT_0] = active_pids[tests_left - 1];
-+#endif   /* WIN32 */
-+
-+		for (i = 0; i < num_tests; i++)
-+		{
-+			if (p == pids[i])
-+			{
-+#ifdef WIN32
-+				CloseHandle(pids[i]);
-+#endif
-+				pids[i] = INVALID_PID;
-+				if (names)
-+					status(" %s", names[i]);
-+				tests_left--;
-+				break;
-+			}
-+		}
-+	}
-+
-+#ifdef WIN32
-+	free(active_pids);
-+#endif
-+}
-+
-+/*
-+ * Run all the tests specified in one schedule file
-+ */
-+static void
-+run_schedule(const char *schedule, test_function tfunc)
-+{
-+#define MAX_PARALLEL_TESTS 100
-+	char	   *tests[MAX_PARALLEL_TESTS];
-+	_stringlist *resultfiles[MAX_PARALLEL_TESTS];
-+	_stringlist *expectfiles[MAX_PARALLEL_TESTS];
-+	_stringlist *tags[MAX_PARALLEL_TESTS];
-+	PID_TYPE	pids[MAX_PARALLEL_TESTS];
-+	_stringlist *ignorelist = NULL;
-+	char		scbuf[1024];
-+	FILE	   *scf;
-+	int			line_num = 0;
-+
-+	memset(resultfiles, 0, sizeof(_stringlist *) * MAX_PARALLEL_TESTS);
-+	memset(expectfiles, 0, sizeof(_stringlist *) * MAX_PARALLEL_TESTS);
-+	memset(tags, 0, sizeof(_stringlist *) * MAX_PARALLEL_TESTS);
-+
-+	scf = fopen(schedule, "r");
-+	if (!scf)
-+	{
-+		fprintf(stderr, _("%s: could not open file \"%s\" for reading: %s\n"),
-+				progname, schedule, strerror(errno));
-+		exit_nicely(2);
-+	}
-+
-+	while (fgets(scbuf, sizeof(scbuf), scf))
-+	{
-+		char	   *test = NULL;
-+		char	   *c;
-+		int			num_tests;
-+		bool		inword;
-+		int			i;
-+
-+		line_num++;
-+
-+		for (i = 0; i < MAX_PARALLEL_TESTS; i++)
-+		{
-+			if (resultfiles[i] == NULL)
-+				break;
-+			free_stringlist(&resultfiles[i]);
-+			free_stringlist(&expectfiles[i]);
-+			free_stringlist(&tags[i]);
-+		}
-+
-+		/* strip trailing whitespace, especially the newline */
-+		i = strlen(scbuf);
-+		while (i > 0 && isspace((unsigned char) scbuf[i - 1]))
-+			scbuf[--i] = '\0';
-+
-+		if (scbuf[0] == '\0' || scbuf[0] == '#')
-+			continue;
-+		if (strncmp(scbuf, "test: ", 6) == 0)
-+			test = scbuf + 6;
-+		else if (strncmp(scbuf, "ignore: ", 8) == 0)
-+		{
-+			c = scbuf + 8;
-+			while (*c && isspace((unsigned char) *c))
-+				c++;
-+			add_stringlist_item(&ignorelist, c);
-+
-+			/*
-+			 * Note: ignore: lines do not run the test, they just say that
-+			 * failure of this test when run later on is to be ignored. A bit
-+			 * odd but that's how the shell-script version did it.
-+			 */
-+			continue;
-+		}
-+		else
-+		{
-+			fprintf(stderr, _("syntax error in schedule file \"%s\" line %d: %s\n"),
-+					schedule, line_num, scbuf);
-+			exit_nicely(2);
-+		}
-+
-+		num_tests = 0;
-+		inword = false;
-+		for (c = test; *c; c++)
-+		{
-+			if (isspace((unsigned char) *c))
-+			{
-+				*c = '\0';
-+				inword = false;
-+			}
-+			else if (!inword)
-+			{
-+				if (num_tests >= MAX_PARALLEL_TESTS)
-+				{
-+					/* can't print scbuf here, it's already been trashed */
-+					fprintf(stderr, _("too many parallel tests in schedule file \"%s\", line %d\n"),
-+							schedule, line_num);
-+					exit_nicely(2);
-+				}
-+				tests[num_tests] = c;
-+				num_tests++;
-+				inword = true;
-+			}
-+		}
-+
-+		if (num_tests == 0)
-+		{
-+			fprintf(stderr, _("syntax error in schedule file \"%s\" line %d: %s\n"),
-+					schedule, line_num, scbuf);
-+			exit_nicely(2);
-+		}
-+
-+		if (num_tests == 1)
-+		{
-+			status(_("test %-20s ... "), tests[0]);
-+			pids[0] = (tfunc) (tests[0], &resultfiles[0], &expectfiles[0], &tags[0]);
-+			wait_for_tests(pids, NULL, 1);
-+			/* status line is finished below */
-+		}
-+		else if (max_connections > 0 && max_connections < num_tests)
-+		{
-+			int			oldest = 0;
-+
-+			status(_("parallel group (%d tests, in groups of %d): "),
-+				   num_tests, max_connections);
-+			for (i = 0; i < num_tests; i++)
-+			{
-+				if (i - oldest >= max_connections)
-+				{
-+					wait_for_tests(pids + oldest, tests + oldest, i - oldest);
-+					oldest = i;
-+				}
-+				pids[i] = (tfunc) (tests[i], &resultfiles[i], &expectfiles[i], &tags[i]);
-+			}
-+			wait_for_tests(pids + oldest, tests + oldest, i - oldest);
-+			status_end();
-+		}
-+		else
-+		{
-+			status(_("parallel group (%d tests): "), num_tests);
-+			for (i = 0; i < num_tests; i++)
-+			{
-+				pids[i] = (tfunc) (tests[i], &resultfiles[i], &expectfiles[i], &tags[i]);
-+			}
-+			wait_for_tests(pids, tests, num_tests);
-+			status_end();
-+		}
-+
-+		/* Check results for all tests */
-+		for (i = 0; i < num_tests; i++)
-+		{
-+			_stringlist *rl,
-+					   *el,
-+					   *tl;
-+			bool		differ = false;
-+
-+			if (num_tests > 1)
-+				status(_("     %-20s ... "), tests[i]);
-+
-+			/*
-+			 * Advance over all three lists simultaneously.
-+			 *
-+			 * Compare resultfiles[j] with expectfiles[j] always. Tags are
-+			 * optional but if there are tags, the tag list has the same
-+			 * length as the other two lists.
-+			 */
-+			for (rl = resultfiles[i], el = expectfiles[i], tl = tags[i];
-+				 rl != NULL;	/* rl and el have the same length */
-+				 rl = rl->next, el = el->next)
-+			{
-+				bool		newdiff;
-+
-+				if (tl)
-+					tl = tl->next;		/* tl has the same lengt has rl and el
-+										 * if it exists */
-+
-+				newdiff = results_differ(tests[i], rl->str, el->str);
-+				if (newdiff && tl)
-+				{
-+					printf("%s ", tl->str);
-+				}
-+				differ |= newdiff;
-+			}
-+
-+			if (differ)
-+			{
-+				bool		ignore = false;
-+				_stringlist *sl;
-+
-+				for (sl = ignorelist; sl != NULL; sl = sl->next)
-+				{
-+					if (strcmp(tests[i], sl->str) == 0)
-+					{
-+						ignore = true;
-+						break;
-+					}
-+				}
-+				if (ignore)
-+				{
-+					status(_("failed (ignored)"));
-+					fail_ignore_count++;
-+				}
-+				else
-+				{
-+					status(_("FAILED"));
-+					fail_count++;
-+				}
-+			}
-+			else
-+			{
-+				status(_("ok"));
-+				success_count++;
-+			}
-+
-+			status_end();
-+		}
-+	}
-+
-+	fclose(scf);
-+}
-+
-+/*
-+ * Run a single test
-+ */
-+static void
-+run_single_test(const char *test, test_function tfunc)
-+{
-+	PID_TYPE	pid;
-+	_stringlist *resultfiles = NULL;
-+	_stringlist *expectfiles = NULL;
-+	_stringlist *tags = NULL;
-+	_stringlist *rl,
-+			   *el,
-+			   *tl;
-+	bool		differ = false;
-+
-+	status(_("test %-20s ... "), test);
-+	pid = (tfunc) (test, &resultfiles, &expectfiles, &tags);
-+	wait_for_tests(&pid, NULL, 1);
-+
-+	/*
-+	 * Advance over all three lists simultaneously.
-+	 *
-+	 * Compare resultfiles[j] with expectfiles[j] always. Tags are optional
-+	 * but if there are tags, the tag list has the same length as the other
-+	 * two lists.
-+	 */
-+	for (rl = resultfiles, el = expectfiles, tl = tags;
-+		 rl != NULL;			/* rl and el have the same length */
-+		 rl = rl->next, el = el->next)
-+	{
-+		bool		newdiff;
-+
-+		if (tl)
-+			tl = tl->next;		/* tl has the same lengt has rl and el if it
-+								 * exists */
-+
-+		newdiff = results_differ(test, rl->str, el->str);
-+		if (newdiff && tl)
-+		{
-+			printf("%s ", tl->str);
-+		}
-+		differ |= newdiff;
-+	}
-+
-+	if (differ)
-+	{
-+		status(_("FAILED"));
-+		fail_count++;
-+	}
-+	else
-+	{
-+		status(_("ok"));
-+		success_count++;
-+	}
-+	status_end();
-+}
-+
-+/*
-+ * Create the summary-output files (making them empty if already existing)
-+ */
-+static void
-+open_result_files(void)
-+{
-+	char		file[MAXPGPATH];
-+	FILE	   *difffile;
-+
-+	/* create the log file (copy of running status output) */
-+	snprintf(file, sizeof(file), "%s/regression.out", outputdir);
-+	logfilename = strdup(file);
-+	logfile = fopen(logfilename, "w");
-+	if (!logfile)
-+	{
-+		fprintf(stderr, _("%s: could not open file \"%s\" for writing: %s\n"),
-+				progname, logfilename, strerror(errno));
-+		exit_nicely(2);
-+	}
-+
-+	/* create the diffs file as empty */
-+	snprintf(file, sizeof(file), "%s/regression.diffs", outputdir);
-+	difffilename = strdup(file);
-+	difffile = fopen(difffilename, "w");
-+	if (!difffile)
-+	{
-+		fprintf(stderr, _("%s: could not open file \"%s\" for writing: %s\n"),
-+				progname, difffilename, strerror(errno));
-+		exit_nicely(2);
-+	}
-+	/* we don't keep the diffs file open continuously */
-+	fclose(difffile);
-+
-+	/* also create the output directory if not present */
-+	snprintf(file, sizeof(file), "%s/results", outputdir);
-+	if (!directory_exists(file))
-+		make_directory(file);
-+}
-+
-+static void
-+drop_database_if_exists(const char *dbname)
-+{
-+	header(_("dropping database \"%s\""), dbname);
-+	psql_command("postgres", "DROP DATABASE IF EXISTS \"%s\"", dbname);
-+}
-+
-+static void
-+create_database(const char *dbname)
-+{
-+	_stringlist *sl;
-+
-+	/*
-+	 * We use template0 so that any installation-local cruft in template1 will
-+	 * not mess up the tests.
-+	 */
-+	header(_("creating database \"%s\""), dbname);
-+	if (encoding)
-+		psql_command("postgres", "CREATE DATABASE \"%s\" TEMPLATE=template0 ENCODING='%s'", dbname, encoding);
-+	else
-+		psql_command("postgres", "CREATE DATABASE \"%s\" TEMPLATE=template0", dbname);
-+	psql_command(dbname,
-+				 "ALTER DATABASE \"%s\" SET lc_messages TO 'C';"
-+				 "ALTER DATABASE \"%s\" SET lc_monetary TO 'C';"
-+				 "ALTER DATABASE \"%s\" SET lc_numeric TO 'C';"
-+				 "ALTER DATABASE \"%s\" SET lc_time TO 'C';"
-+			"ALTER DATABASE \"%s\" SET timezone_abbreviations TO 'Default';",
-+				 dbname, dbname, dbname, dbname, dbname);
-+
-+	/*
-+	 * Install any requested procedural languages
-+	 */
-+	for (sl = loadlanguage; sl != NULL; sl = sl->next)
-+	{
-+		header(_("installing %s"), sl->str);
-+		psql_command(dbname, "CREATE LANGUAGE \"%s\"", sl->str);
-+	}
-+}
-+
-+static void
-+drop_role_if_exists(const char *rolename)
-+{
-+	header(_("dropping role \"%s\""), rolename);
-+	psql_command("postgres", "DROP ROLE IF EXISTS \"%s\"", rolename);
-+}
-+
-+static void
-+create_role(const char *rolename, const _stringlist * granted_dbs)
-+{
-+	header(_("creating role \"%s\""), rolename);
-+	psql_command("postgres", "CREATE ROLE \"%s\" WITH LOGIN", rolename);
-+	for (; granted_dbs != NULL; granted_dbs = granted_dbs->next)
-+	{
-+		psql_command("postgres", "GRANT ALL ON DATABASE \"%s\" TO \"%s\"",
-+					 granted_dbs->str, rolename);
-+	}
-+}
-+
-+static void
-+help(void)
-+{
-+	printf(_("PostgreSQL regression test driver\n"));
-+	printf(_("\n"));
-+	printf(_("Usage: %s [options...] [extra tests...]\n"), progname);
-+	printf(_("\n"));
-+	printf(_("Options:\n"));
-+	printf(_("  --dbname=DB               use database DB (default \"regression\")\n"));
-+	printf(_("  --debug                   turn on debug mode in programs that are run\n"));
-+	printf(_("  --inputdir=DIR            take input files from DIR (default \".\")\n"));
-+	printf(_("  --load-language=lang      load the named language before running the\n"));
-+	printf(_("                            tests; can appear multiple times\n"));
-+	printf(_("  --create-role=ROLE        create the specified role before testing\n"));
-+	printf(_("  --max-connections=N       maximum number of concurrent connections\n"));
-+	printf(_("                            (default is 0 meaning unlimited)\n"));
-+	printf(_("  --multibyte=ENCODING      use ENCODING as the multibyte encoding\n"));
-+	printf(_("  --outputdir=DIR           place output files in DIR (default \".\")\n"));
-+	printf(_("  --schedule=FILE           use test ordering schedule from FILE\n"));
-+	printf(_("                            (can be used multiple times to concatenate)\n"));
-+	printf(_("  --srcdir=DIR              absolute path to source directory (for VPATH builds)\n"));
-+	printf(_("  --temp-install=DIR        create a temporary installation in DIR\n"));
-+	printf(_("\n"));
-+	printf(_("Options for \"temp-install\" mode:\n"));
-+	printf(_("  --no-locale               use C locale\n"));
-+	printf(_("  --top-builddir=DIR        (relative) path to top level build directory\n"));
-+	printf(_("  --temp-port=PORT          port number to start temp postmaster on\n"));
-+	printf(_("  --temp-config=PATH        append contents of PATH to temporary config\n"));
-+	printf(_("\n"));
-+	printf(_("Options for using an existing installation:\n"));
-+	printf(_("  --host=HOST               use postmaster running on HOST\n"));
-+	printf(_("  --port=PORT               use postmaster running at PORT\n"));
-+	printf(_("  --user=USER               connect as USER\n"));
-+	printf(_("  --psqldir=DIR             use psql in DIR (default: find in PATH)\n"));
-+	printf(_("\n"));
-+	printf(_("The exit status is 0 if all tests passed, 1 if some tests failed, and 2\n"));
-+	printf(_("if the tests could not be run for some reason.\n"));
-+	printf(_("\n"));
-+	printf(_("Report bugs to <pgsql-bugs@postgresql.org>.\n"));
-+}
-+
-+int
-+regression_main(int argc, char *argv[], init_function ifunc, test_function tfunc)
-+{
-+	_stringlist *sl;
-+	int			c;
-+	int			i;
-+	int			option_index;
-+	char		buf[MAXPGPATH * 4];
-+
-+	static struct option long_options[] = {
-+		{"help", no_argument, NULL, 'h'},
-+		{"version", no_argument, NULL, 'V'},
-+		{"dbname", required_argument, NULL, 1},
-+		{"debug", no_argument, NULL, 2},
-+		{"inputdir", required_argument, NULL, 3},
-+		{"load-language", required_argument, NULL, 4},
-+		{"max-connections", required_argument, NULL, 5},
-+		{"multibyte", required_argument, NULL, 6},
-+		{"outputdir", required_argument, NULL, 7},
-+		{"schedule", required_argument, NULL, 8},
-+		{"temp-install", required_argument, NULL, 9},
-+		{"no-locale", no_argument, NULL, 10},
-+		{"top-builddir", required_argument, NULL, 11},
-+		{"temp-port", required_argument, NULL, 12},
-+		{"host", required_argument, NULL, 13},
-+		{"port", required_argument, NULL, 14},
-+		{"user", required_argument, NULL, 15},
-+		{"psqldir", required_argument, NULL, 16},
-+		{"srcdir", required_argument, NULL, 17},
-+		{"create-role", required_argument, NULL, 18},
-+		{"temp-config", required_argument, NULL, 19},
-+		{NULL, 0, NULL, 0}
-+	};
-+
-+	progname = get_progname(argv[0]);
-+	set_pglocale_pgservice(argv[0], "pg_regress");
-+
-+#ifndef HAVE_UNIX_SOCKETS
-+	/* no unix domain sockets available, so change default */
-+	hostname = "localhost";
-+#endif
-+
-+	/*
-+	 * We call the initialization function here because that way we can set
-+	 * default parameters and let them be overwritten by the commandline.
-+	 */
-+	ifunc();
-+
-+	while ((c = getopt_long(argc, argv, "hV", long_options, &option_index)) != -1)
-+	{
-+		switch (c)
-+		{
-+			case 'h':
-+				help();
-+				exit_nicely(0);
-+			case 'V':
-+				printf("pg_regress (PostgreSQL %s)\n", PG_VERSION);
-+				exit_nicely(0);
-+			case 1:
-+
-+				/*
-+				 * If a default database was specified, we need to remove it
-+				 * before we add the specified one.
-+				 */
-+				free_stringlist(&dblist);
-+				split_to_stringlist(strdup(optarg), ", ", &dblist);
-+				break;
-+			case 2:
-+				debug = true;
-+				break;
-+			case 3:
-+				inputdir = strdup(optarg);
-+				break;
-+			case 4:
-+				add_stringlist_item(&loadlanguage, optarg);
-+				break;
-+			case 5:
-+				max_connections = atoi(optarg);
-+				break;
-+			case 6:
-+				encoding = strdup(optarg);
-+				break;
-+			case 7:
-+				outputdir = strdup(optarg);
-+				break;
-+			case 8:
-+				add_stringlist_item(&schedulelist, optarg);
-+				break;
-+			case 9:
-+				/* temp_install must be absolute path */
-+				if (is_absolute_path(optarg))
-+					temp_install = strdup(optarg);
-+				else
-+				{
-+					char		cwdbuf[MAXPGPATH];
-+
-+					if (!getcwd(cwdbuf, sizeof(cwdbuf)))
-+					{
-+						fprintf(stderr, _("could not get current working directory: %s\n"), strerror(errno));
-+						exit_nicely(2);
-+					}
-+					temp_install = malloc(strlen(cwdbuf) + strlen(optarg) + 2);
-+					sprintf(temp_install, "%s/%s", cwdbuf, optarg);
-+				}
-+				canonicalize_path(temp_install);
-+				break;
-+			case 10:
-+				nolocale = true;
-+				break;
-+			case 11:
-+				top_builddir = strdup(optarg);
-+				break;
-+			case 12:
-+				{
-+					int			p = atoi(optarg);
-+
-+					/* Since Makefile isn't very bright, check port range */
-+					if (p >= 1024 && p <= 65535)
-+						temp_port = p;
-+				}
-+				break;
-+			case 13:
-+				hostname = strdup(optarg);
-+				break;
-+			case 14:
-+				port = atoi(optarg);
-+				break;
-+			case 15:
-+				user = strdup(optarg);
-+				break;
-+			case 16:
-+				/* "--psqldir=" should mean to use PATH */
-+				if (strlen(optarg))
-+					psqldir = strdup(optarg);
-+				break;
-+			case 17:
-+				srcdir = strdup(optarg);
-+				break;
-+			case 18:
-+				split_to_stringlist(strdup(optarg), ", ", &extraroles);
-+				break;
-+			case 19:
-+				temp_config = strdup(optarg);
-+				break;
-+			default:
-+				/* getopt_long already emitted a complaint */
-+				fprintf(stderr, _("\nTry \"%s -h\" for more information.\n"),
-+						progname);
-+				exit_nicely(2);
-+		}
-+	}
-+
-+	/*
-+	 * if we still have arguments, they are extra tests to run
-+	 */
-+	while (argc - optind >= 1)
-+	{
-+		add_stringlist_item(&extra_tests, argv[optind]);
-+		optind++;
-+	}
-+
-+	if (temp_install)
-+		port = temp_port;
-+
-+	/*
-+	 * Initialization
-+	 */
-+	open_result_files();
-+
-+	initialize_environment();
-+
-+#if defined(HAVE_GETRLIMIT) && defined(RLIMIT_CORE)
-+	unlimit_core_size();
-+#endif
-+
-+	if (temp_install)
-+	{
-+		/*
-+		 * Prepare the temp installation
-+		 */
-+		if (!top_builddir)
-+		{
-+			fprintf(stderr, _("--top-builddir must be specified when using --temp-install\n"));
-+			exit_nicely(2);
-+		}
-+
-+		if (directory_exists(temp_install))
-+		{
-+			header(_("removing existing temp installation"));
-+			rmtree(temp_install, true);
-+		}
-+
-+		header(_("creating temporary installation"));
-+
-+		/* make the temp install top directory */
-+		make_directory(temp_install);
-+
-+		/* and a directory for log files */
-+		snprintf(buf, sizeof(buf), "%s/log", outputdir);
-+		if (!directory_exists(buf))
-+			make_directory(buf);
-+
-+		/* "make install" */
-+#ifndef WIN32_ONLY_COMPILER
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "\"%s\" -C \"%s\" DESTDIR=\"%s/install\" install with_perl=no with_python=no > \"%s/log/install.log\" 2>&1" SYSTEMQUOTE,
-+				 makeprog, top_builddir, temp_install, outputdir);
-+#else
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "perl \"%s/src/tools/msvc/install.pl\" \"%s/install\" >\"%s/log/install.log\" 2>&1" SYSTEMQUOTE,
-+				 top_builddir, temp_install, outputdir);
-+#endif
-+		if (system(buf))
-+		{
-+			fprintf(stderr, _("\n%s: installation failed\nExamine %s/log/install.log for the reason.\nCommand was: %s\n"), progname, outputdir, buf);
-+			exit_nicely(2);
-+		}
-+
-+		/* initdb */
-+		header(_("initializing database system"));
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "\"%s/initdb\" -D \"%s/data\" -L \"%s\" --noclean%s%s > \"%s/log/initdb.log\" 2>&1" SYSTEMQUOTE,
-+				 bindir, temp_install, datadir,
-+				 debug ? " --debug" : "",
-+				 nolocale ? " --no-locale" : "",
-+				 outputdir);
-+		if (system(buf))
-+		{
-+			fprintf(stderr, _("\n%s: initdb failed\nExamine %s/log/initdb.log for the reason.\nCommand was: %s\n"), progname, outputdir, buf);
-+			exit_nicely(2);
-+		}
-+
-+		/* add any extra config specified to the postgresql.conf */
-+		if (temp_config != NULL)
-+		{
-+			FILE	   *extra_conf;
-+			FILE	   *pg_conf;
-+			char		line_buf[1024];
-+
-+			snprintf(buf, sizeof(buf), "%s/data/postgresql.conf", temp_install);
-+			pg_conf = fopen(buf, "a");
-+			if (pg_conf == NULL)
-+			{
-+				fprintf(stderr, _("\n%s: could not open %s for adding extra config:\nError was %s\n"), progname, buf, strerror(errno));
-+				exit_nicely(2);
-+			}
-+			extra_conf = fopen(temp_config, "r");
-+			if (extra_conf == NULL)
-+			{
-+				fprintf(stderr, _("\n%s: could not open %s to read extra config:\nError was %s\n"), progname, buf, strerror(errno));
-+				exit_nicely(2);
-+			}
-+			while (fgets(line_buf, sizeof(line_buf), extra_conf) != NULL)
-+				fputs(line_buf, pg_conf);
-+			fclose(extra_conf);
-+			fclose(pg_conf);
-+		}
-+
-+		/*
-+		 * Start the temp postmaster
-+		 */
-+		header(_("starting postmaster"));
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "\"%s/postgres\" -D \"%s/data\" -F%s -c \"listen_addresses=%s\" > \"%s/log/postmaster.log\" 2>&1" SYSTEMQUOTE,
-+				 bindir, temp_install,
-+				 debug ? " -d 5" : "",
-+				 hostname ? hostname : "",
-+				 outputdir);
-+		postmaster_pid = spawn_process(buf);
-+		if (postmaster_pid == INVALID_PID)
-+		{
-+			fprintf(stderr, _("\n%s: could not spawn postmaster: %s\n"),
-+					progname, strerror(errno));
-+			exit_nicely(2);
-+		}
-+
-+		/*
-+		 * Wait till postmaster is able to accept connections (normally only a
-+		 * second or so, but Cygwin is reportedly *much* slower).  Don't wait
-+		 * forever, however.
-+		 */
-+		snprintf(buf, sizeof(buf),
-+				 SYSTEMQUOTE "\"%s/psql\" -X postgres <%s 2>%s" SYSTEMQUOTE,
-+				 bindir, DEVNULL, DEVNULL);
-+		for (i = 0; i < 60; i++)
-+		{
-+			/* Done if psql succeeds */
-+			if (system(buf) == 0)
-+				break;
-+
-+			/*
-+			 * Fail immediately if postmaster has exited
-+			 */
-+#ifndef WIN32
-+			if (kill(postmaster_pid, 0) != 0)
-+#else
-+			if (WaitForSingleObject(postmaster_pid, 0) == WAIT_OBJECT_0)
-+#endif
-+			{
-+				fprintf(stderr, _("\n%s: postmaster failed\nExamine %s/log/postmaster.log for the reason\n"), progname, outputdir);
-+				exit_nicely(2);
-+			}
-+
-+			pg_usleep(1000000L);
-+		}
-+		if (i >= 60)
-+		{
-+			fprintf(stderr, _("\n%s: postmaster did not respond within 60 seconds\nExamine %s/log/postmaster.log for the reason\n"), progname, outputdir);
-+
-+			/*
-+			 * If we get here, the postmaster is probably wedged somewhere in
-+			 * startup.  Try to kill it ungracefully rather than leaving a
-+			 * stuck postmaster that might interfere with subsequent test
-+			 * attempts.
-+			 */
-+#ifndef WIN32
-+			if (kill(postmaster_pid, SIGKILL) != 0 &&
-+				errno != ESRCH)
-+				fprintf(stderr, _("\n%s: could not kill failed postmaster: %s\n"),
-+						progname, strerror(errno));
-+#else
-+			if (TerminateProcess(postmaster_pid, 255) == 0)
-+				fprintf(stderr, _("\n%s: could not kill failed postmaster: %lu\n"),
-+						progname, GetLastError());
-+#endif
-+
-+			exit_nicely(2);
-+		}
-+
-+		postmaster_running = true;
-+
-+		printf(_("running on port %d with pid %lu\n"),
-+			   temp_port, (unsigned long) postmaster_pid);
-+	}
-+	else
-+	{
-+		/*
-+		 * Using an existing installation, so may need to get rid of
-+		 * pre-existing database(s) and role(s)
-+		 */
-+		for (sl = dblist; sl; sl = sl->next)
-+			drop_database_if_exists(sl->str);
-+		for (sl = extraroles; sl; sl = sl->next)
-+			drop_role_if_exists(sl->str);
-+	}
-+
-+	/*
-+	 * Create the test database(s) and role(s)
-+	 */
-+	for (sl = dblist; sl; sl = sl->next)
-+		create_database(sl->str);
-+	for (sl = extraroles; sl; sl = sl->next)
-+		create_role(sl->str, dblist);
-+
-+	/*
-+	 * Ready to run the tests
-+	 */
-+	header(_("running regression test queries"));
-+
-+	for (sl = schedulelist; sl != NULL; sl = sl->next)
-+	{
-+		run_schedule(sl->str, tfunc);
-+	}
-+
-+	for (sl = extra_tests; sl != NULL; sl = sl->next)
-+	{
-+		run_single_test(sl->str, tfunc);
-+	}
-+
-+	/*
-+	 * Shut down temp installation's postmaster
-+	 */
-+	if (temp_install)
-+	{
-+		header(_("shutting down postmaster"));
-+		stop_postmaster();
-+	}
-+
-+	fclose(logfile);
-+
-+	/*
-+	 * Emit nice-looking summary message
-+	 */
-+	if (fail_count == 0 && fail_ignore_count == 0)
-+		snprintf(buf, sizeof(buf),
-+				 _(" All %d tests passed. "),
-+				 success_count);
-+	else if (fail_count == 0)	/* fail_count=0, fail_ignore_count>0 */
-+		snprintf(buf, sizeof(buf),
-+				 _(" %d of %d tests passed, %d failed test(s) ignored. "),
-+				 success_count,
-+				 success_count + fail_ignore_count,
-+				 fail_ignore_count);
-+	else if (fail_ignore_count == 0)	/* fail_count>0 && fail_ignore_count=0 */
-+		snprintf(buf, sizeof(buf),
-+				 _(" %d of %d tests failed. "),
-+				 fail_count,
-+				 success_count + fail_count);
-+	else
-+		/* fail_count>0 && fail_ignore_count>0 */
-+		snprintf(buf, sizeof(buf),
-+				 _(" %d of %d tests failed, %d of these failures ignored. "),
-+				 fail_count + fail_ignore_count,
-+				 success_count + fail_count + fail_ignore_count,
-+				 fail_ignore_count);
-+
-+	putchar('\n');
-+	for (i = strlen(buf); i > 0; i--)
-+		putchar('=');
-+	printf("\n%s\n", buf);
-+	for (i = strlen(buf); i > 0; i--)
-+		putchar('=');
-+	putchar('\n');
-+	putchar('\n');
-+
-+	if (file_size(difffilename) > 0)
-+	{
-+		printf(_("The differences that caused some tests to fail can be viewed in the\n"
-+				 "file \"%s\".  A copy of the test summary that you see\n"
-+				 "above is saved in the file \"%s\".\n\n"),
-+			   difffilename, logfilename);
-+	}
-+	else
-+	{
-+		unlink(difffilename);
-+		unlink(logfilename);
-+	}
-+
-+	if (fail_count != 0)
-+		exit_nicely(1);
-+
-+	return 0;
-+}
--- a/dev-db/postgresql-server/files/postgresql.conf-8.3	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,52 +0,0 @@
-# PostgreSQL's Database Directory
-PGDATA="/var/lib/postgresql/8.3/data"
-
-# PostgreSQL User
-PGUSER="postgres"
-
-# PostgreSQL Group
-PGGROUP="postgres"
-
-# Extra options to run postmaster with, e.g.:
-# -N is the maximal number of client connections
-# -B is the number of shared buffers and has to be at least 2x the value for -N
-# Please read the man-page to postmaster for more options. Many of these options
-# can be set directly in the configuration-file.
-#PGOPTS="-N 512 -B 1024"
-
-
-# SERVER SHUTDOWN:
-# The server will receive 3 signals in the worst case:
-# 1. SIGTERM
-#  This signals the server to ignore new connections and to
-#  wait for all clients to end their transactions before shutting down.
-#  Use WAIT_FOR_DISCONNECT to control how much time the clients
-#  should have until the next signal is being sent.
-# 2. SIGINT
-#  Tell the server to forcefully disconnect all clients.
-#  Terminating a client results in a rollback of the open transactions for this client.
-#  Use WAIT_FOR_CLEANUP to determine how much time the server has
-#  for cleanup.
-# 3. SIGQUIT
-#  This will terminate the server immediately and results in a recovery run for the next start.
-
-# Wait for clients to disconnect
-WAIT_FOR_DISCONNECT=30
-
-# Time the server has to clean up
-WAIT_FOR_CLEANUP=60
-
-# Time the server has to quit (with a recover-run on next startup)
-# Set to 0 to deactivate it
-WAIT_FOR_QUIT=60
-
-# Comment this out if you don't want to wait for the server to
-# startup before continuing.  For example, if this server is a
-# PITR log shipping based replication standby
-WAIT_FOR_START="-w"
-
-# If you have to export environment variables for the database process,
-# this can be done here.
-#
-# Example:
-#   export R_HOME="/usr/lib/R"
--- a/dev-db/postgresql-server/files/postgresql.init-8.3	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,100 +0,0 @@
-#!/sbin/runscript
-# Copyright 1999-2008 Gentoo Foundation
-# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/files/postgresql.init-8.3,v 1.4 2008/09/28 22:53:02 caleb Exp $
-
-opts="${opts} reload"
-
-depend() {
-	use net
-	if [ -L /etc/eselect/postgresql/service ] ; then
-		local p_service="$(for f in /etc/eselect/postgresql/service/* ; do source $f ; done ; echo $postgres_service )"
-		test "${p_service}" = "${SVCNAME}" && provide postgresql
-	fi
-}
-
-checkconfig() {
-	if [ ! -d "$PGDATA" ] ; then
-		eerror "Directory not found: $PGDATA"
-		eerror "Please make sure that PGDATA points to the right path."
-		eerror "You can run 'emerge postgresql-server --config' to setup a new database cluster."
-		return 1
-	fi
-}
-
-start() {
-	checkconfig || return 1
-
-	ebegin "Starting PostgreSQL"
-
-	if [ -f "$PGDATA/postmaster.pid" ] ; then
-		rm -f "$PGDATA/postmaster.pid"
-	fi
-
-	local retval
-
-	su -l ${PGUSER} \
-		-c "env PGDATA=\"${PGDATA}\" /usr/lib/postgresql-8.3/bin/pg_ctl start ${WAIT_FOR_START} -o '--silent-mode=true ${PGOPTS}'"
-	retval=$?
-	[ $retval -ne 0 ] && eend $retval && return $retval
-
-	# The following is to catch the case of an already running server
-	# in which pg_ctl doesn't know to which server it connected to and false reports the server as 'up'
-	sleep 2
-	if [ ! -f "$PGDATA/postmaster.pid" ] ; then
-		eerror "The pid-file doesn't exist but pg_ctl reported a running server."
-		eerror "Please check whether there is another server running on the same port or read the log-file."
-		eend 1
-		return 1
-	fi
-
-	local pid=$(grep "^[0-9]\+" "$PGDATA/postmaster.pid")
-	ps -p "${pid}" &> /dev/null
-	eend $?
-}
-
-stop() {
-	ebegin "Stopping PostgreSQL (this can take up to $(( ${WAIT_FOR_DISCONNECT} + ${WAIT_FOR_CLEANUP} )) seconds)"
-
-	local retval
-
-	su -l ${PGUSER} \
-		-c "env PGDATA=\"${PGDATA}\" /usr/lib/postgresql-8.3/bin/pg_ctl stop -t ${WAIT_FOR_DISCONNECT} -m smart"
-
-	retval=$?
-	[ $retval -eq 0 ] && eend $retval && return $retval
-
-	ewarn "Some clients did not disconnect within ${WAIT_FOR_DISCONNECT} seconds."
-	ewarn "Going to shutdown the server anyway."
-
-	su -l ${PGUSER} \
-		-c "env PGDATA=\"${PGDATA}\" /usr/lib/postgresql-8.3/bin/pg_ctl stop -m fast"
-
-	retval=$?
-	[ $retval -eq 0 ] && eend $retval && return $retval
-
-	if [ ${WAIT_FOR_QUIT} -eq 0 ] ; then
-		eerror "Server did not shut down and sending the SIGQUIT has been disabled."
-		eend $retval
-		return $retval
-	fi
-
-	ewarn "Shutting down the server gracefully failed."
-	ewarn "Forcing it to shutdown which leads to a recover-run on next startup."
-
-	su -l ${PGUSER} \
-		-c "env PGDATA=\"${PGDATA}\" /usr/lib/postgresql-8.3/bin/pg_ctl stop -m immediate"
-
-	retval=$?
-	[ $retval -eq 0 ] && eend $retval && return $retval
-
-	eerror "Forced shutdown failed!!! Something is wrong with your system, please take care of it manually."
-	eend $?
-}
-
-reload() {
-	ebegin "Reloading PostgreSQL configuration"
-	su -l ${PGUSER} \
-		-c "env PGDATA=\"${PGDATA}\" /usr/lib/postgresql-8.3/bin/pg_ctl reload"
-	eend $?
-}
--- a/dev-db/postgresql-server/postgresql-server-8.3.7.ebuild	Mon Apr 06 14:24:53 2009 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,249 +0,0 @@
-# Copyright 1999-2008 Gentoo Foundation
-# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql-server/postgresql-server-8.3.5.ebuild,v 1.1 2008/12/03 19:27:06 caleb Exp $
-
-EAPI="1"
-
-WANT_AUTOCONF="latest"
-WANT_AUTOMAKE="none"
-inherit eutils multilib toolchain-funcs versionator autotools
-
-KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~sh ~sparc ~x86 ~x86-fbsd"
-
-DESCRIPTION="PostgreSQL server"
-HOMEPAGE="http://www.postgresql.org/"
-SRC_URI="mirror://postgresql/source/v${PV}/postgresql-${PV}.tar.bz2"
-LICENSE="POSTGRESQL"
-SLOT="$(get_version_component_range 1-2)"
-IUSE_LINGUAS="
-	linguas_af linguas_cs linguas_de linguas_es linguas_fa linguas_fr
-	linguas_hr linguas_hu linguas_it linguas_ko linguas_nb linguas_pl
-	linguas_pt_BR linguas_ro linguas_ru linguas_sk linguas_sl linguas_sv
-	linguas_tr linguas_zh_CN linguas_zh_TW"
-IUSE="doc perl python selinux tcl uuid xml nls kernel_linux ${IUSE_LINGUAS}"
-
-wanted_languages() {
-	for u in ${IUSE_LINGUAS} ; do
-		use $u && echo -n "${u#linguas_} "
-	done
-}
-
-RDEPEND="~dev-db/postgresql-base-${PV}:${SLOT}
-	perl? ( >=dev-lang/perl-5.6.1-r2 )
-	python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
-	selinux? ( sec-policy/selinux-postgresql )
-	tcl? ( >=dev-lang/tcl-8 )
-	uuid? ( dev-libs/ossp-uuid )
-	xml? ( dev-libs/libxml2 dev-libs/libxslt )"
-DEPEND="${RDEPEND}
-	sys-devel/flex
-	xml? ( dev-util/pkgconfig )"
-PDEPEND="doc? ( dev-db/postgresql-docs:${SLOT} )"
-
-S="${WORKDIR}/postgresql-${PV}"
-
-pkg_setup() {
-	enewgroup postgres 70
-	enewuser postgres 70 /bin/bash /var/lib/postgresql postgres
-}
-
-src_unpack() {
-	unpack ${A}
-	cd "${S}"
-
-	epatch "${FILESDIR}/postgresql-${SLOT}-common.patch" \
-		"${FILESDIR}/postgresql-${SLOT}-server.patch"
-
-	if hasq test ${FEATURES}; then
-		sed -e "s|/no/such/location|${S}/src/test/regress/tmp_check/no/such/location|g" -i src/test/regress/{input,output}/tablespace.source
-	else
-		echo "all install:" > "${S}/src/test/regress/GNUmakefile"
-	fi
-
-	eautoconf
-}
-
-src_compile() {
-	# TODO: test if PPC really cannot work with other CFLAGS settings
-	# use ppc && CFLAGS="-pipe -fsigned-char"
-
-	# eval is needed to get along with pg_config quotation of space-rich entities.
-	eval econf "$(/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --configure)" \
-		--disable-thread-safety \
-		$(use_with perl) \
-		$(use_with python) \
-		$(use_with tcl) \
-		$(use_with xml libxml) \
-		$(use_with xml libxslt) \
-		$(use_with uuid ossp-uuid) \
-		--with-system-tzdata="/usr/share/zoneinfo" \
-		--with-includes="/usr/include/postgresql-${SLOT}/" \
-		"$(built_with_use ~dev-db/postgresql-base-${PV} nls && use_enable nls nls "$(wanted_languages)")" \
-		|| die "configure failed"
-
-	for bd in . contrib $(use xml && echo contrib/xml2); do
-		PATH="/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \
-			emake -C $bd -j1 LD="$(tc-getLD) $(get_abi_LDFLAGS)" \
-				PGXS=$(/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \
-				PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \
-				NO_PGXS=0 USE_PGXS=1 docdir=/usr/share/doc/${PF} || die "emake in $bd failed"
-	done
-}
-
-src_install() {
-	if use perl ; then
-		mv -f "${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
-
-	for bd in . contrib $(use xml && echo contrib/xml2) ; do
-		PATH="/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \
-			emake install -C $bd -j1 DESTDIR="${D}" \
-				PGXS_IN_SERVER=1 PGXS_WITH_SERVER="${S}/src/backend/postgres" \
-				PGXS=$(/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \
-				NO_PGXS=0 USE_PGXS=1 docdir=/usr/share/doc/${PF} || die "emake install in $bd failed"
-	done
-
-	rm -rf "${D}/usr/share/postgresql-${SLOT}/man/man7/" "${D}/usr/share/doc/${PF}/html"
-	rm "${D}"/usr/share/postgresql-${SLOT}/man/man1/{clusterdb,create{db,lang,user},drop{db,lang,user},ecpg,pg_{config,dump,dumpall,restore},psql,reindexdb,vacuumdb}.1
-
-	dodoc README HISTORY doc/{README.*,TODO,bug.template}
-
-	dodir /etc/eselect/postgresql/slots/${SLOT}
-	cat >"${D}/etc/eselect/postgresql/slots/${SLOT}/service" <<-__EOF__
-		postgres_ebuilds="\${postgres_ebuilds} ${PF}"
-		postgres_service="postgresql-${SLOT}"
-	__EOF__
-
-	newinitd "${FILESDIR}/postgresql.init-${SLOT}" postgresql-${SLOT} || die "Inserting init.d-file failed"
-	newconfd "${FILESDIR}/postgresql.conf-${SLOT}" postgresql-${SLOT} || die "Inserting conf.d-file failed"
-
-	keepdir /var/run/postgresql
-	fperms 0770 /var/run/postgresql
-	fowners postgres:postgres /var/run/postgresql
-}
-
-pkg_postinst() {
-	eselect postgresql update
-	[[ "$(eselect postgresql show)" = "(none)" ]] && eselect postgresql set ${SLOT}
-	[[ "$(eselect postgresql show-service)" = "(none)" ]] && eselect postgresql set-service ${SLOT}
-
-	ewarn "Please note that the standard location of the socket has changed from /tmp"
-	ewarn "to /var/run/postgresql and you have to be in the 'postgres' group to access"
-	ewarn "the socket."
-	ewarn "This can break applications which have the standard location hard-coded."
-	ewarn "If such an application links against the libpq, please re-emerge it,"
-	ewarn "if that doesn't help or the application accesses the socket without using libpq,"
-	ewarn "please file a bug-report."
-	ewarn "You can set PGOPTS='-k /tmp' in /etc/conf.d/postgresql-${SLOT} to restore the original location."
-
-	elog "Execute the following command to setup the initial database environment:"
-	elog
-	elog "emerge --config =${CATEGORY}/${PF}"
-	elog
-	elog "The autovacuum function, which was in contrib, has been moved to the main"
-	elog "PostgreSQL functions starting with 8.1."
-	elog "You can enable it in the clusters postgresql.conf."
-}
-
-pkg_postrm() {
-	eselect postgresql update
-}
-
-pkg_config() {
-	[[ -z "${PGDATA}" ]] && PGDATA="/var/lib/postgresql/${SLOT}/data"
-
-	einfo "You can pass options to initdb by setting the PG_INITDB_OPTS variable."
-	einfo "More information can be found here:"
-	einfo "    http://www.postgresql.org/docs/${SLOT}/static/creating-cluster.html"
-	einfo "    http://www.postgresql.org/docs/${SLOT}/static/app-initdb.html"
-	einfo "Simply add the options you would have added to initdb to the PG_INITDB_OPTS variable."
-	einfo
-	einfo "You can change the directory where the database cluster is being created by setting"
-	einfo "the PGDATA variable."
-	einfo
-	einfo "PG_INITDB_OPTS is currently set to:"
-	einfo "    \"${PG_INITDB_OPTS}\""
-	einfo "and the database cluster will be created in:"
-	einfo "    \"${PGDATA}\""
-	einfo "Are you ready to continue? (Y/n)"
-	read answer
-	[ -z $answer ] && answer=Y
-	[ "$answer" == "Y" ] || [ "$answer" == "y" ] || die "aborted"
-
-	if [[ -f "${PGDATA}/PG_VERSION" ]] ; then
-		eerror "The given directory \"${PGDATA}\" already contains a database cluster."
-		die "cluster already exists"
-	fi
-
-	[ -z "${PG_MAX_CONNECTIONS}" ] && PG_MAX_CONNECTIONS="128"
-	einfo "Checking system parameters..."
-
-	if ! use kernel_linux ; then
-		SKIP_SYSTEM_TESTS=yes
-		einfo "  Tests not supported on this OS (yet)"
-	fi
-
-	if [ -z ${SKIP_SYSTEM_TESTS} ] ; then
-		einfo "Checking whether your system supports at least ${PG_MAX_CONNECTIONS} connections..."
-
-		local SEMMSL=$(sysctl -n kernel.sem | cut -f1)
-		local SEMMNS=$(sysctl -n kernel.sem | cut -f2)
-		local SEMMNI=$(sysctl -n kernel.sem | cut -f4)
-		local SHMMAX=$(sysctl -n kernel.shmmax)
-
-		local SEMMSL_MIN=17
-		local SEMMNS_MIN=$(( ( ${PG_MAX_CONNECTIONS}/16 ) * 17 ))
-		local SEMMNI_MIN=$(( ( ${PG_MAX_CONNECTIONS}+15 ) / 16 ))
-		local SHMMAX_MIN=$(( 500000 + ( 30600 * ${PG_MAX_CONNECTIONS} ) ))
-
-		for p in SEMMSL SEMMNS SEMMNI SHMMAX ; do
-			if [ $(eval echo \$$p) -lt $(eval echo \$${p}_MIN) ] ; then
-				eerror "The value for ${p} $(eval echo \$$p) is below the recommended value $(eval echo \$${p}_MIN)"
-				eerror "You have now several options:"
-				eerror "  - Change the mentioned system parameter"
-				eerror "  - Lower the number of max.connections by setting PG_MAX_CONNECTIONS to a value lower than ${PG_MAX_CONNECTIONS}"
-				eerror "  - Set SKIP_SYSTEM_TESTS in case you want to ignore this test completely"
-				eerror "More information can be found here:"
-				eerror "  http://www.postgresql.org/docs/${SLOT}/static/kernel-resources.html"
-				die "system test failed"
-			fi
-		done
-		einfo "Passed."
-	else
-		einfo "Skipped."
-	fi
-
-	einfo "Creating the data directory ..."
-	mkdir -p "${PGDATA}"
-	chown -Rf postgres:postgres "${PGDATA}"
-	chmod 0700 "${PGDATA}"
-
-	einfo "Initializing the database ..."
-
-	su postgres -c "/usr/$(get_libdir)/postgresql-${SLOT}/bin/initdb --pgdata \"${PGDATA}\" ${PG_INITDB_OPTS}"
-
-	einfo
-	einfo "You can use the '${ROOT}/etc/init.d/postgresql-${SLOT}' script to run PostgreSQL instead of 'pg_ctl'."
-	einfo
-
-	if [ "${PGDATA}" != "/var/lib/postgresql/${SLOT}/data" ] ; then
-		ewarn "You didn't install the database cluster in the standard location, please make sure that you set"
-		ewarn "PGDATA=\"${PGDATA}\" in the appropriate conf.d file (probably /etc/conf.d/postgresql-${SLOT})"
-	fi
-}
-
-src_test() {
-	einfo ">>> Test phase [check]: ${CATEGORY}/${PF}"
-	PATH="/usr/$(get_libdir)/postgresql-${SLOT}/bin:${PATH}" \
-		emake -j1 check \
-			PGXS=$(/usr/$(get_libdir)/postgresql-${SLOT}/bin/pg_config --pgxs) \
-			NO_PGXS=0 USE_PGXS=1 SLOT=${SLOT} || die "Make check failed. See above for details."
-
-	einfo "Yes, there are other tests which could be run."
-	einfo "... and no, we don't plan to add/support them."
-	einfo "For now, the main regressions tests will suffice."
-	einfo "If you think other tests are necessary, please submit a"
-	einfo "bug including a patch for this ebuild to enable them."
-}