head	1.74;
access;
symbols
	pkgsrc-2013Q2:1.74.0.48
	pkgsrc-2013Q2-base:1.74
	pkgsrc-2012Q4:1.74.0.46
	pkgsrc-2012Q4-base:1.74
	pkgsrc-2011Q4:1.74.0.44
	pkgsrc-2011Q4-base:1.74
	pkgsrc-2011Q2:1.74.0.42
	pkgsrc-2011Q2-base:1.74
	pkgsrc-2009Q4:1.74.0.40
	pkgsrc-2009Q4-base:1.74
	pkgsrc-2008Q4:1.74.0.38
	pkgsrc-2008Q4-base:1.74
	pkgsrc-2008Q3:1.74.0.36
	pkgsrc-2008Q3-base:1.74
	cube-native-xorg:1.74.0.34
	cube-native-xorg-base:1.74
	pkgsrc-2008Q2:1.74.0.32
	pkgsrc-2008Q2-base:1.74
	pkgsrc-2008Q1:1.74.0.30
	pkgsrc-2008Q1-base:1.74
	pkgsrc-2007Q4:1.74.0.28
	pkgsrc-2007Q4-base:1.74
	pkgsrc-2007Q3:1.74.0.26
	pkgsrc-2007Q3-base:1.74
	pkgsrc-2007Q2:1.74.0.24
	pkgsrc-2007Q2-base:1.74
	pkgsrc-2007Q1:1.74.0.22
	pkgsrc-2007Q1-base:1.74
	pkgsrc-2006Q4:1.74.0.20
	pkgsrc-2006Q4-base:1.74
	pkgsrc-2006Q3:1.74.0.18
	pkgsrc-2006Q3-base:1.74
	pkgsrc-2006Q2:1.74.0.16
	pkgsrc-2006Q2-base:1.74
	pkgsrc-2006Q1:1.74.0.14
	pkgsrc-2006Q1-base:1.74
	pkgsrc-2005Q4:1.74.0.12
	pkgsrc-2005Q4-base:1.74
	pkgsrc-2005Q3:1.74.0.10
	pkgsrc-2005Q3-base:1.74
	pkgsrc-2005Q2:1.74.0.8
	pkgsrc-2005Q2-base:1.74
	pkgsrc-2005Q1:1.74.0.6
	pkgsrc-2005Q1-base:1.74
	pkgsrc-2004Q4:1.74.0.4
	pkgsrc-2004Q4-base:1.74
	pkgsrc-2004Q3:1.74.0.2
	pkgsrc-2004Q3-base:1.74
	pkgsrc-2004Q2:1.72.0.4
	pkgsrc-2004Q2-base:1.72
	pkgsrc-2004Q1:1.72.0.2
	pkgsrc-2004Q1-base:1.72
	pkgsrc-2003Q4:1.71.0.2
	pkgsrc-2003Q4-base:1.71
	netbsd-1-6-1:1.69.0.2
	netbsd-1-6-1-base:1.69
	netbsd-1-6:1.67.0.8
	netbsd-1-6-RELEASE-base:1.67
	pkgviews:1.67.0.4
	pkgviews-base:1.67
	buildlink2:1.67.0.2
	buildlink2-base:1.67
	netbsd-1-5-PATCH003:1.67
	netbsd-1-5-PATCH001:1.63
	netbsd-1-5-RELEASE:1.54
	netbsd-1-4-PATCH003:1.54
	netbsd-1-4-PATCH002:1.46
	comdex-fall-1999:1.42
	netbsd-1-4-PATCH001:1.35
	netbsd-1-4-RELEASE:1.31
	netbsd-1-3-PATCH003:1.18
	netbsd-1-3-PATCH002:1.10
	FreeBSD-current-1998-02-16:1.1.1.1
	FREEBSD:1.1.1;
locks; strict;
comment	@# @;


1.74
date	2004.07.24.22.48.13;	author recht;	state dead;
branches;
next	1.73;

1.73
date	2004.06.26.09.23.46;	author darcy;	state Exp;
branches;
next	1.72;

1.72
date	2004.03.26.02.27.36;	author wiz;	state Exp;
branches;
next	1.71;

1.71
date	2003.04.01.05.14.08;	author jmc;	state Exp;
branches;
next	1.70;

1.70
date	2003.03.28.21.14.15;	author wiz;	state Exp;
branches;
next	1.69;

1.69
date	2003.01.05.20.12.07;	author jlam;	state Exp;
branches;
next	1.68;

1.68
date	2002.10.19.04.01.22;	author jlam;	state Exp;
branches;
next	1.67;

1.67
date	2002.04.04.07.48.18;	author jlam;	state Exp;
branches;
next	1.66;

1.66
date	2001.12.03.08.06.25;	author jlam;	state Exp;
branches;
next	1.65;

1.65
date	2001.05.15.15.59.22;	author jlam;	state Exp;
branches;
next	1.64;

1.64
date	2001.05.14.14.52.36;	author jlam;	state Exp;
branches;
next	1.63;

1.63
date	2001.03.25.11.29.37;	author wennmach;	state Exp;
branches;
next	1.62;

1.62
date	2001.02.26.18.09.40;	author lukem;	state Exp;
branches;
next	1.61;

1.61
date	2001.02.16.14.17.37;	author wiz;	state Exp;
branches;
next	1.60;

1.60
date	2001.02.13.02.37.43;	author jlam;	state Exp;
branches;
next	1.59;

1.59
date	2001.01.29.11.34.23;	author wiz;	state Exp;
branches;
next	1.58;

1.58
date	2000.12.11.20.18.56;	author jlam;	state Exp;
branches;
next	1.57;

1.57
date	2000.12.11.16.43.11;	author jlam;	state Exp;
branches;
next	1.56;

1.56
date	2000.12.07.16.57.54;	author jlam;	state Exp;
branches;
next	1.55;

1.55
date	2000.12.07.16.56.39;	author jlam;	state Exp;
branches;
next	1.54;

1.54
date	2000.09.21.14.34.56;	author jlam;	state Exp;
branches;
next	1.53;

1.53
date	2000.09.03.09.51.12;	author wiz;	state Exp;
branches;
next	1.52;

1.52
date	2000.07.15.01.23.56;	author jlam;	state Exp;
branches;
next	1.51;

1.51
date	2000.07.14.04.44.11;	author jlam;	state Exp;
branches;
next	1.50;

1.50
date	2000.05.29.15.29.11;	author fredb;	state Exp;
branches;
next	1.49;

1.49
date	2000.05.20.19.32.18;	author jlam;	state Exp;
branches;
next	1.48;

1.48
date	2000.04.09.03.53.16;	author jlam;	state Exp;
branches;
next	1.47;

1.47
date	2000.03.18.17.43.16;	author jlam;	state Exp;
branches;
next	1.46;

1.46
date	2000.02.20.00.11.19;	author jwise;	state Exp;
branches;
next	1.45;

1.45
date	2000.01.15.18.46.24;	author jlam;	state Exp;
branches;
next	1.44;

1.44
date	99.12.28.04.56.09;	author wiz;	state Exp;
branches;
next	1.43;

1.43
date	99.12.02.01.47.05;	author darcy;	state Exp;
branches;
next	1.42;

1.42
date	99.09.20.23.38.45;	author jlam;	state Exp;
branches;
next	1.41;

1.41
date	99.09.20.03.56.25;	author jlam;	state Exp;
branches;
next	1.40;

1.40
date	99.09.19.04.24.53;	author jlam;	state Exp;
branches;
next	1.39;

1.39
date	99.09.06.18.19.49;	author hubertf;	state Exp;
branches;
next	1.38;

1.38
date	99.09.06.07.01.43;	author sakamoto;	state Exp;
branches;
next	1.37;

1.37
date	99.08.24.14.18.53;	author tron;	state Exp;
branches;
next	1.36;

1.36
date	99.08.18.09.00.23;	author agc;	state Exp;
branches;
next	1.35;

1.35
date	99.07.13.17.42.57;	author bad;	state Exp;
branches;
next	1.34;

1.34
date	99.06.06.14.25.45;	author tv;	state Exp;
branches;
next	1.33;

1.33
date	99.06.04.16.55.12;	author drochner;	state Exp;
branches;
next	1.32;

1.32
date	99.05.24.20.39.36;	author tv;	state Exp;
branches;
next	1.31;

1.31
date	99.04.13.15.31.05;	author agc;	state Exp;
branches;
next	1.30;

1.30
date	99.04.01.13.36.55;	author agc;	state Exp;
branches;
next	1.29;

1.29
date	99.03.28.21.50.17;	author hubertf;	state Exp;
branches;
next	1.28;

1.28
date	99.02.19.09.02.25;	author frueauf;	state Exp;
branches;
next	1.27;

1.27
date	99.02.06.20.06.32;	author hwr;	state Exp;
branches;
next	1.26;

1.26
date	99.01.17.00.59.37;	author frueauf;	state Exp;
branches;
next	1.25;

1.25
date	99.01.17.00.52.08;	author frueauf;	state Exp;
branches;
next	1.24;

1.24
date	99.01.09.20.49.26;	author kleink;	state Exp;
branches;
next	1.23;

1.23
date	99.01.08.11.17.21;	author frueauf;	state Exp;
branches;
next	1.22;

1.22
date	99.01.04.13.05.01;	author frueauf;	state Exp;
branches;
next	1.21;

1.21
date	99.01.03.13.13.12;	author frueauf;	state Exp;
branches;
next	1.20;

1.20
date	98.11.16.21.13.01;	author agc;	state Exp;
branches;
next	1.19;

1.19
date	98.11.12.16.24.39;	author agc;	state Exp;
branches;
next	1.18;

1.18
date	98.09.22.06.11.35;	author garbled;	state Exp;
branches;
next	1.17;

1.17
date	98.09.10.11.46.31;	author frueauf;	state Exp;
branches;
next	1.16;

1.16
date	98.08.20.15.16.44;	author tsarna;	state Exp;
branches;
next	1.15;

1.15
date	98.07.15.12.40.14;	author agc;	state Exp;
branches;
next	1.14;

1.14
date	98.06.22.13.58.26;	author frueauf;	state Exp;
branches;
next	1.13;

1.13
date	98.06.22.11.19.41;	author agc;	state Exp;
branches;
next	1.12;

1.12
date	98.06.10.13.55.34;	author agc;	state Exp;
branches;
next	1.11;

1.11
date	98.06.03.12.43.25;	author agc;	state Exp;
branches;
next	1.10;

1.10
date	98.05.09.15.24.42;	author frueauf;	state Exp;
branches;
next	1.9;

1.9
date	98.04.22.14.22.40;	author agc;	state Exp;
branches;
next	1.8;

1.8
date	98.04.20.11.56.22;	author frueauf;	state Exp;
branches;
next	1.7;

1.7
date	98.04.15.10.38.18;	author agc;	state Exp;
branches;
next	1.6;

1.6
date	98.03.16.14.40.48;	author hubertf;	state Exp;
branches;
next	1.5;

1.5
date	98.03.16.12.57.37;	author hubertf;	state Exp;
branches;
next	1.4;

1.4
date	98.02.18.17.35.25;	author agc;	state Exp;
branches;
next	1.3;

1.3
date	98.02.18.11.50.33;	author frueauf;	state Exp;
branches;
next	1.2;

1.2
date	98.02.17.15.37.40;	author agc;	state Exp;
branches;
next	1.1;

1.1
date	98.02.17.15.29.55;	author agc;	state Exp;
branches
	1.1.1.1;
next	;

1.1.1.1
date	98.02.17.15.29.55;	author agc;	state Exp;
branches;
next	;


desc
@@


1.74
log
@Delete old postgresql packages now that we have the postgresql73 ones.
@
text
@# $NetBSD: Makefile,v 1.73 2004/06/26 09:23:46 darcy Exp $

PKGNAME=	postgresql-${BASE_VERS}
COMMENT=	Robust, next generation, object-relational DBMS

DEPENDS+=	postgresql-client>=${BASE_VERS}:../../databases/postgresql-client
DEPENDS+=	postgresql-server>=${BASE_VERS}:../../databases/postgresql-server
DEPENDS+=	postgresql-docs>=${BASE_VERS}:../../databases/postgresql-docs

.include "Makefile.common"

EXTRACT_ONLY=	# empty
NO_CHECKSUM=	YES
NO_CONFIGURE=	YES
NO_BUILD=	YES

do-install:	# empty
do-patch:	# empty

.include "../../mk/bsd.pkg.mk"
@


1.73
log
@Forgot to remove PKGREVISION when I updated the package.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.72 2004/03/26 02:27:36 wiz Exp $
@


1.72
log
@PKGREVISION bump after openssl-security-fix-update to 0.9.6m.
Buildlink files: RECOMMENDED version changed to current version.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.71 2003/04/01 05:14:08 jmc Exp $
a3 1
PKGREVISION=	1
@


1.71
log
@Add an empty do-patch rule.

A simple make test here would have shown this to break by removing NO_PATCH
without otherwise seeing why it was there..
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.70 2003/03/28 21:14:15 wiz Exp $
d4 1
@


1.70
log
@NO_PATCH is deprecated, says pkglint. Remove it.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.69 2003/01/05 20:12:07 jlam Exp $
d18 1
@


1.69
log
@Updated databases/postgresql to 7.3.1.

      ==================================================================
      | NOTE:  A dump-and-restore is required to update your databases |
      |        if you wish to update postgresql-server. If your        |
      |        application examines the system catalogs, additional    |
      |        changes will be required due to the introduction of     |
      |        schemas in 7.3; for more information, see:              |
      |                                                                |
      |   http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3   |
      ==================================================================

Major changes from version 7.2.3 include:

   Schemas
          Schemas allow users to create objects in separate namespaces,
          so two people or applications can have tables with the same
          name. There is also a public schema for shared tables.
          Table/index creation can be restricted by removing permissions
          on the public schema.

   Drop Column
          PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
          functionality.

   Table Functions
          Functions returning multiple rows and/or multiple columns are
          now much easier to use than before. You can call such a "table
          function" in the SELECT FROM clause, treating its output like a
          table. Also, PL/pgSQL functions can now return sets.

   Prepared Queries
          PostgreSQL now supports prepared queries, for improved
          performance.

   Dependency Tracking
          PostgreSQL now records object dependencies, which allows
          improvements in many areas. "DROP" statements now take either
          CASCADE or RESTRICT to control whether dependent objects are
          also dropped.

   Privileges
          Functions and procedural languages now have privileges, and
          functions can be defined to run with the privileges of their
          creator.

   Internationalization
          Both multibyte and locale support are now always enabled.

   Logging
          A variety of logging options have been enhanced.

   Interfaces
          A large number of interfaces have been moved to
          http://gborg.postgresql.org where they can be developed and
          released independently.

   Functions/Identifiers
          By default, functions can now take up to 32 parameters, and
          identifiers can be up to 63 bytes long. Also, OPAQUE is now
          deprecated: there are specific "pseudo-datatypes" to represent
          each of the former meanings of OPAQUE in function argument and
          result types.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.68 2002/10/19 04:01:22 jlam Exp $
a13 1
NO_PATCH=	YES
@


1.68
log
@Trivially use buildlink2.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.67 2002/04/04 07:48:18 jlam Exp $
d10 1
a10 1
.include "../../databases/postgresql/Makefile.common"
a12 1
USE_BUILDLINK2=	YES
@


1.67
log
@Update postgresql and related packages to 7.2.  Thanks to Michael Graff
<explorer@@flame.org> for most of the work on this update.

Pkgsrc changes from the previous version include removing Makefile.ssl and
some patches that have been integrated into this release of PostgreSQL.  We
leave open the question of when to byte-compile the Python modules for the
PyGreSQL interface and just do it as before, although we should consider
doing the compilation as a post-install step to ensure that the timestamps
are correct.  We also reorder some lines in the Makefile to include
Makefile.common below certain definitions (GNU_CONFIGURE, USE_BUILDLINK_ONLY)
as they may possibly trigger different portions of Makefile.common.

*** Please note that a dump/restore is required to migrate an existing ***
*** PostgreSQL installation to 7.2.                                    ***

Major changes from version 7.1.3 are geared toward improving use in
high-volume applications and include:

   VACUUM
	   Vacuuming no longer locks tables, thus allowing normal user access
           during the vacuum. A new "VACUUM FULL" command does old-style
           vacuum by locking the table and shrinking the on-disk copy of the
           table.

   Transactions
           There is no longer a problem with installations that exceed four
           billion transactions.

   OID's
           OID's are now optional. Users can now create tables without OID's
           for cases where OID usage is excessive.

   Optimizer
           The system now computes histogram column statistics during
           "ANALYZE", allowing much better optimizer choices.

   Security
           A new MD5 encryption option allows more secure storage and
           transfer of passwords. A new Unix-domain socket authentication
           option is available on Linux and BSD systems. PAM authentication
           is also available.

   Statistics
           Administrators can use the new table access statistics module to
           get fine-grained information about table and index usage.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.66 2001/12/03 08:06:25 jlam Exp $
d13 1
@


1.66
log
@Use PKGREVISION to manage the package-specific version number when it
differs from the distfile version number.  G/C some the unused variables
in postgresql/Makefile.common related to the old way of handling version
numbers.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.65 2001/05/15 15:59:22 jlam Exp $
d3 2
a4 1
.include "../../databases/postgresql/Makefile.common"
d6 3
a8 2
PKGNAME=	postgresql-${PG_BASE_VERS}
COMMENT=	Robust, next generation, object-relational DBMS
d10 1
a10 3
DEPENDS+=	postgresql-client>=${PG_BASE_VERS}:../../databases/postgresql-client
DEPENDS+=	postgresql-server>=${PG_BASE_VERS}:../../databases/postgresql-server
DEPENDS+=	postgresql-docs>=${PG_BASE_VERS}:../../databases/postgresql-docs
d13 4
a16 4
NO_CHECKSUM=	# defined
NO_PATCH=	# defined
NO_CONFIGURE=	# defined
NO_BUILD=	# defined
@


1.65
log
@Fix dependencies and post-extract target.  "Make build" in
databases/postgresql should now correctly trigger the full build and
installation of PostgreSQL.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.64 2001/05/14 14:52:36 jlam Exp $
d5 1
a5 2
PKGNAME=	postgresql-${PG_VERS}
PG_PKG_VERS=	# empty
@


1.64
log
@Update postgresql to 7.1.1  Pkgsrc changes include splitting into:

	postgresql-lib
	postgresql-client
	postgresql-server
	postgresql-doc

with postgresql as a meta-package.  Major changes from version 7.1.1
include:

	Write-ahead Log (WAL) - To maintain database consistency in
case of an operating system crash, previous releases of PostgreSQL
have forced all data modifications to disk before each transaction
commit.  With WAL, only one log file must be flushed to disk, greatly
improving performance.  If you have been using -F in previous releases
to disable disk flushes, you may want to consider discontinuing its
use.

	TOAST - Previous releases had a compiled-in row length limit,
typically 8 - 32 kB.  This limit made storage of long text fields
difficult.  With TOAST, long rows of any length can be stored with
good performance.

	Outer Joins - We now support outer joins.  The UNION/NOT IN
workaround for outer joins is no longer required.  We use the SQL92
outer join syntax.

	Function Manager - The previous C function manager did not
handle NULLs properly, nor did it support 64-bit CPU's (Alpha).  The
new function manager does.  You can continue using your old custom
functions, but you may want to rewrite them in the future to use the
new function manager call interface.

	Complex Queries - A large number of complex queries that were
unsupported in previous releases now work.  Many combinations of
views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited
tables now work properly. Inherited tables are now accessed by
default.  Subqueries in FROM are now supported.

Migration to 7.1.1

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release.
@
text
@d1 1
a1 1
# $NetBSD$
d9 3
a11 3
DEPENDS+=	postgresql-client>=${PG_BASE_VERS}:../../postgresql-client
DEPENDS+=	postgresql-server>=${PG_BASE_VERS}:../../postgresql-server
DEPENDS+=	postgresql-docs>=${PG_BASE_VERS}:../../postgresql-docs
@


1.63
log
@Make pgsql's home directory configurable. This is useful e. g. in cases
where ${PREFIX} is mounted read-only etc. Checked with Johnny C. Lam,
who suggested two additional changes.
@
text
@d1 1
a1 3
# $NetBSD: Makefile,v 1.62 2001/02/26 18:09:40 lukem Exp $
# FreeBSD Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp
#
d5 13
a17 1
COMMENT=		Robust, next generation, object-relational DBMS
d19 1
a19 141
# NetBSD libedit's readline emulation doesn't support enough features, yet.
DEPENDS+=		readline-*:../../devel/readline

MAKEFILE=		GNUmakefile

# Needs ELF clue, mips has no TAS implementation
NOT_FOR_PLATFORM=	*-*-mips

.include "../../mk/bsd.prefs.mk"

# PGUSER	username of the database administrator
# PGGROUP	group of the database administrator
# PGHOME	home directory of the database administrator and
#		location of the databases
#
PGUSER?=		pgsql
PGGROUP?=		pgsql
PGHOME?=		${PREFIX}/${PGUSER}

MESSAGE=		${FILESDIR}/post-install-notes
DEINSTALL_FILE=		${WRKDIR}/DEINSTALL
INSTALL_FILE=		${WRKDIR}/INSTALL

BUILD_DEFS=		PGUSER PGROUP PGHOME
PLIST_SUBST=		PGUSER=${PGUSER}
PLIST_SRC+=		${PKGDIR}/PLIST
PLIST_SRC+=		${PKGDIR}/PLIST.spi
PLIST_SRC+=		${PKGDIR}/PLIST.dirrm

CONFIGURE_ARGS+=	--without-perl --without-odbc --without-tcl
CONFIGURE_ARGS+=	--with-includes="${LOCALBASE}/include"
CONFIGURE_ENV+=		CPPFLAGS="${CPPFLAGS}"

.if ${OPSYS} == "NetBSD"
.if exists(/usr/sbin/user)
ADDUSER=		/usr/sbin/useradd
ADDGROUP=		/usr/sbin/groupadd
.else
DEPENDS+=		user>=20000313:../../sysutils/user
ADDUSER=		${LOCALBASE}/sbin/useradd
ADDGROUP=		${LOCALBASE}/sbin/groupadd
.endif
.elif ${OPSYS} == "SunOS"
ADDUSER=		useradd
ADDGROUP=		groupadd
.endif

# The following alpha-specific patch fixes problems in the 7.0.x release
# that will be fixed in a more complete way in the forthcoming 7.1 release.
#
.if ${MACHINE_ARCH} == "alpha"
post-patch:
	cd ${WRKSRC} && ${PATCH} < ${FILESDIR}/postgresql-7.0.3-alpha.diff
.endif

post-build:
	${SED}	-e 's|@@PATH@@|${PATH}|g' \
		-e 's|@@MANPATH@@|${MANPATH}|g' \
		-e 's|@@PREFIX@@|${PREFIX}|g' \
		< ${FILESDIR}/profile.pgsql > ${WRKDIR}/profile.pgsql
	${SED}	-e "s|@@PREFIX@@|${PREFIX}|g" \
		-e "s|@@PGUSER@@|${PGUSER}|g" \
		-e "s|@@PGHOME@@|${PGHOME}|g" \
		-e "s|@@SU@@|${SU}|g" \
		< ${FILESDIR}/pgsql.sh > ${WRKDIR}/pgsql.sh

pre-install:
	@@case "X${PGUSER}" in						\
	Xbin|Xetc|Xinclude|Xinfo|Xlib|Xlibdata|Xlibexec|Xman|Xsbin|Xshare) \
		${ECHO} "You have chosen PGUSER=${PGUSER} which will";	\
		${ECHO} "cause trouble, because the postgres home directory"; \
		${ECHO} "would be ${PGHOME}.  Please";			\
		${ECHO} "set PGUSER to something more reasonable";	\
		${ECHO} "like pgsql.";					\
		${ECHO} "";						\
		${FALSE};						\
		;;							\
	esac

	${SED}	-e 's|@@PGUSER@@|${PGUSER}|g' \
		-e "s,@@PGGROUP@@,${PGGROUP},g" \
		-e "s,@@PGHOME@@,${PGHOME},g" \
		-e "s,@@CAT@@,${CAT},g" \
		< ${PKGDIR}/DEINSTALL > ${DEINSTALL_FILE}
	${SED}	-e "s,@@PGUSER@@,${PGUSER},g" \
		-e "s,@@PGGROUP@@,${PGGROUP},g" \
		-e "s,@@PGHOME@@,${PGHOME},g" \
		-e "s,@@ADDUSER@@,${ADDUSER},g" \
		-e "s,@@ADDGROUP@@,${ADDGROUP},g" \
		-e "s,@@CAT@@,${CAT},g" \
		-e "s,@@CHGRP@@,${CHGRP},g" \
		-e "s,@@CHMOD@@,${CHMOD},g" \
		-e "s,@@CHOWN@@,${CHOWN},g" \
		-e "s,@@CP@@,${CP},g" \
		-e "s,@@GREP@@,${GREP},g" \
		-e "s,@@MKDIR@@,${MKDIR},g" \
		-e "s,@@RM@@,${RM},g" \
		-e "s,@@SU@@,${SU},g" \
		-e "s,@@TOUCH@@,${TOUCH},g" \
		< ${PKGDIR}/INSTALL > ${INSTALL_FILE}
	PKG_PREFIX=${PREFIX} ${SH} ${INSTALL_FILE} ${PKGNAME} PRE-INSTALL

post-install:
	cd ${PREFIX}/include/pgsql; ${RMDIR} -p port/netbsd

	dirlist=`${GREP} "^@@dirrm" ${PKGDIR}/PLIST.spi \
	    | ${AWK} '{ print $$2 }'`; \
	for dir in $$dirlist; do \
		${INSTALL_DATA_DIR} ${PREFIX}/$$dir; \
	done
	filelist=`${GREP} "^include/pgsql/" ${PKGDIR}/PLIST.spi \
	    | ${SED} "s,^include/pgsql/,,g"`; \
	cd ${WRKSRC}/include; for file in $$filelist; do \
		${INSTALL_DATA} $$file ${PREFIX}/include/pgsql/$$file; \
	done

.for PROG in ecpg pg_dump pg_encoding pg_id pg_passwd pg_version postgres psql
	strip ${PREFIX}/bin/${PROG}
.endfor
	${INSTALL_DATA} ${WRKDIR}/profile.pgsql \
		${PREFIX}/share/postgresql/profile.pgsql.sample

	${INSTALL_SCRIPT} ${WRKDIR}/pgsql.sh ${PREFIX}/etc/rc.d/pgsql

	${CAT} ${FILESDIR}/exclude ${FILESDIR}/man.tcl ${FILESDIR}/man.tk \
		| ${SED} "s,^#.*,," \
		| ${GTAR} zxCXf ${PREFIX}/man - \
			${WRKDIR}/${DISTNAME}/doc/man.tar.gz

	${INSTALL_DATA_DIR} ${PREFIX}/share/doc/postgresql
	cd ${WRKDIR}/${DISTNAME}/doc; \
		${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${MAKE_FLAGS} all
	cd ${WRKDIR}/${DISTNAME}/doc; ${INSTALL_DATA} \
		FAQ FAQ_DEV README.Charsets README.fsync README.inet \
		README.locale README.mb README.mb.jp TODO \
		bug.template internals.ps \
		${PREFIX}/share/doc/postgresql
	${CHOWN} -R ${SHAREOWN}:${SHAREGRP} ${PREFIX}/share/doc/postgresql
	${CHOWN} -R ${SHAREOWN}:${SHAREGRP} ${PREFIX}/share/doc/html/postgresql

	PKG_PREFIX=${PREFIX} ${SH} ${INSTALL_FILE} ${PKGNAME} POST-INSTALL
@


1.62
log
@change default group from ingres to pgsql, to match behaviour of other
applications (uname == gname), and because we've removed the default
ingres group anyway.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.61 2001/02/16 14:17:37 wiz Exp $
d21 2
d26 1
a30 1
PGHOME=			${PREFIX}/${PGUSER}
d32 1
a32 1
BUILD_DEFS=		PGUSER PGROUP
d71 1
d90 1
d95 1
d128 2
a129 3
	${INSTALL_DATA} ${WRKDIR}/profile.pgsql ${PGHOME}/.profile.pgsql
	${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PGHOME}
	${CHOWN} -R ${PGUSER}:${PGGROUP} ${PGHOME}
@


1.61
log
@Update to new COMMENT style: COMMENT var in Makefile instead of pkg/COMMENT.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.60 2001/02/13 02:37:43 jlam Exp $
d23 1
a23 1
PGGROUP?=		ingres
@


1.60
log
@Apply patch to fix alpha-related problems.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.59 2001/01/29 11:34:23 wiz Exp $
d6 2
@


1.59
log
@Add automatic ${VARIABLE} handling for MESSAGE files.
Convert most MESSAGE files to new syntax (${VARIABLE} gets replaced,
not @@VARIABLE@@, nor @@@@VARIABLE@@@@).
By default, substitutions are done for LOCALBASE, PKGNAME, PREFIX,
X11BASE, X11PREFIX; additional patterns can be added via MESSAGE_SUBST.
Clean up some packages while I'm there; add RCS tags to most MESSAGEs.
Remove some uninteresting MESSAGEs.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.58 2000/12/11 20:18:56 jlam Exp $
d13 1
a13 1
NOT_FOR_PLATFORM=	*-*-alpha *-*-mips
d50 8
@


1.58
log
@Rename this script to pgsql.sh, make this script a bit more complete
and robust, and add example command_args setting to allow TCP/IP
connections to the PostgreSQL database.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.57 2000/12/11 16:43:11 jlam Exp $
d23 1
a23 1
MESSAGE_FILE=		${FILESDIR}/post-install-notes
@


1.57
log
@Cosmetic adjustments.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.56 2000/12/07 16:57:54 jlam Exp $
d52 10
a112 4
	${SED}	-e 's|@@PATH@@|${PATH}|g' \
		-e 's|@@MANPATH@@|${MANPATH}|g' \
		-e 's|@@PREFIX@@|${PREFIX}|g' \
		< ${FILESDIR}/profile.pgsql > ${WRKDIR}/profile.pgsql
a116 3
	${SED}	-e "s|@@PREFIX@@|${PREFIX}|g" \
		-e "s|@@PGUSER@@|${PGUSER}|g" \
		< ${FILESDIR}/pgsql.sh.tmpl > ${WRKDIR}/pgsql.sh
@


1.56
log
@Remove unnecessary substitution of @@PGHOME@@ in pgsql.sh.tmpl.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.55 2000/12/07 16:56:39 jlam Exp $
d5 3
a11 9
.include "../../mk/bsd.prefs.mk"

.if exists(/usr/sbin/user)
USERDIR=		/usr/sbin
.else
DEPENDS+=		user>=20000313:../../sysutils/user
USERDIR=		${LOCALBASE}/sbin
.endif

d15 2
d38 14
d66 2
d69 14
a82 3
	${SED}	-e 's|@@PGUSER@@|${PGUSER}|g' \
		-e 's|@@PGGROUP@@|${PGGROUP}|g' \
		-e 's|@@USERDIR@@|${USERDIR}|g' \
d114 1
a114 2
	${INSTALL} -c -o root -g ${PGGROUP} -m 554 \
		${WRKDIR}/pgsql.sh ${PREFIX}/etc/rc.d/pgsql
d134 1
a134 1
.include "../../databases/postgresql/Makefile.common"
@


1.55
log
@PGHOME is a subdir of ${PREFIX}, so pass -b ${PREFIX} to useradd instead
of directly specifying -d ${PGHOME}.  Canonicalize usage of PGHOME while
I'm at it.  Fixes pkg/11660 by Ben Collver <collver@@softhome.net>.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.54 2000/09/21 14:34:56 jlam Exp $
a89 1
		-e "s|@@PGHOME@@|${PGHOME}|g" \
@


1.54
log
@Install rc.d control script as "pgsql" instead of "pgsql.sh" to comply with
how NetBSD's rc.d system interprets script names.  Also add appropriate
REQUIRE and PROVIDE sections to allow direct use in NetBSD's rc.d system.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.53 2000/09/03 09:51:12 wiz Exp $
a55 1
		-e 's|@@PGHOME@@|${PGHOME}|g' \
a58 1
		-e 's|@@PGHOME@@|${PGHOME}|g' \
@


1.53
log
@remove unnecessary whitespace
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.52 2000/07/15 01:23:56 jlam Exp $
d95 1
a95 1
		${WRKDIR}/pgsql.sh ${PREFIX}/etc/rc.d/pgsql.sh
@


1.52
log
@Install the Server Programming Interface header files.
Closes PR#10480.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.51 2000/07/14 04:44:11 jlam Exp $
d78 1
a78 1
	
@


1.51
log
@Update postgresql to 7.0.2.  Relevant changes from 7.0:

* Enhance rc.d/pgsql.sh script to accept start/stop/restart.
* Add fixes for alpha from Kevin P. Neal <kpn@@neutralgood.org> in PR#10543.

  XXX Includes a patch which removes inlining of the alpha's TAS function.
  XXX This is apparently some code-gen bug in GCC for alpha.

* Fix many CLUSTER failures (Tom)
* Allow ALTER TABLE RENAME works on indexes (Tom)
* Fix plpgsql to handle datetime->timestamp and timespan->interval (Bruce)
* New configure --with-setproctitle switch to use setproctitle() (Marc, Bruce)
* Fix the off by one errors in ResultSet from 6.5.3, and more.
* jdbc ResultSet fixes (Joseph Shraibman)
* optimizer tunings (Tom)
* Fix create user for pgaccess
* Fix for UNLISTEN failure
* Reduce COPY IN lock level (Tom)
* Change libpqeasy to use PQconnectdb() style parameters (Bruce)
* Fix pg_dump to handle OID indexes (Tom)
* Fix small memory leak (Tom)
* Solaris fix for createdb/dropdb (Tatsuo)
* Fix for non-blocking connections (Alfred Perlstein)
* Fix improper recovery after RENAME TABLE failures (Tom)
* Copy pg_ident.conf.sample into /lib directory in install (Bruce)
* Add SJIS UDC (NEC selection IBM kanji) support (Eiji Tokuya)
* Fix too long syslog message (Tatsuo)
* Fix problem with quoted indexes that are too long (Tom)
* JDBC ResultSet.getTimestamp() fix (Gregory Krasnow & Floyd Marinescu)
* ecpg changes (Michael)
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.50 2000/05/29 15:29:11 fredb Exp $
d34 3
d68 11
@


1.50
log
@Remove dependency on "bison". Closes PR pkg/10224, by SUNAGAWA Keiki.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.49 2000/05/20 19:32:18 jlam Exp $
d36 1
a38 2
CPPFLAGS+=		-I${LOCALBASE}/include	# readline.h

d52 2
a53 1
	${SED}	-e 's|@@PGHOME@@|${PGHOME}|g' \
d93 2
a94 3
		README.locale README.mb README.mb.jp TODO admin.ps.gz \
		bug.template internals.ps programmer.ps.gz tutorial.ps.gz \
		user.ps.gz \
@


1.49
log
@Update postgresql to 7.0.  Also closes PR#8616.  Changes from 6.5.3:

   A HUGE number of bug/performance fixes and minor enhancements.

   Foreign Keys
          Foreign keys are now implemented, with the exception of PARTIAL
          MATCH foreign keys. Many users have been asking for this
          feature, and we are pleased to offer it.

   Optimizer Overhaul
          Continuing on work started a year ago, the optimizer has been
          overhauled, allowing improved query execution and better
          performance with less memory usage.

   Updated psql
          psql, our interactive terminal monitor, has been updated with a
          variety of new features. See the psql manual page for details.

   Upcoming Features
          In 7.1 or 7.2, we plan to have outer joins, storage for very
          long rows, and a write-ahead logging system.

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release. For those upgrading from 6.5.*, you
   can use pg_upgrade to upgrade to this release.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.48 2000/04/09 03:53:16 jlam Exp $
a4 1
BUILD_DEPENDS+=		${LOCALBASE}/bin/bison:../../devel/bison
@


1.48
log
@Put headers into /include/pgsql.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.47 2000/03/18 17:43:16 jlam Exp $
a5 1
DEPENDS+=		ncurses>=4.2:../../devel/ncurses
d39 1
a39 3
CPPFLAGS+=		-I${LOCALBASE}/include	# ncurses.h, readline.h

INSTALL_TARGET=		install install-man
a63 1
	cd ${PREFIX}; ${MV} include/pgsql/libpq++.H include/pgsql/libpq++.h
d66 1
a66 1
.for PROG in ecpg pg_dump pg_id pg_passwd pg_version postgres psql
d84 6
d93 4
a96 2
		FAQ FAQ_DEV README.fsync TODO bug.template internals.ps \
		admin.ps.gz programmer.ps.gz tutorial.ps.gz user.ps.gz \
d99 1
@


1.47
log
@Change structure of postgresql package.  Shared library build is now
unlibtoolized.  Things now install into ${PREFIX} instead of
${PREFIX}/${PGSQL_USER} to match hier(7) expectations.  The Tcl and Tk
interfaces are now split out into separate packages.

This closes the following PRs: 7384, 8747, 8789, 9272, 9461.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.46 2000/02/20 00:11:19 jwise Exp $
d67 2
a68 2
	cd ${PREFIX}; ${MV} include/libpq++.H include/libpq++.h
	cd ${PREFIX}/include; ${RMDIR} -p port/netbsd
@


1.46
log
@Hmmm.  I thought I'd committed this a long time ago...

Split PGSQL_USE_TCL into PGSQL_USE_TCL and PGSQL_USE_TK so that postgres
can be built with tcl support on a machine without tk (such as a machine
without X installed...)
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.45 2000/01/15 18:46:24 jlam Exp $
d5 3
a7 6
DISTNAME=		postgresql-6.5.3
WRKSRC=			${WRKDIR}/${DISTNAME}/src
CATEGORIES=		databases
MASTER_SITES=		ftp://ftp.PostgreSQL.org/pub/ \
			ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/ \
			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/
d9 1
a9 2
MAINTAINER=		jlam@@netbsd.org
HOMEPAGE=		http://www.PostgreSQL.ORG/
d11 1
a11 1
DEPENDS+=		addnerd-1.6:../../sysutils/addnerd
d13 5
a17 9
BUILD_DEPENDS+=		${LOCALBASE}/bin/bison:../../devel/bison

# Evil stuff follows: I haven't figured out how to add flags to configure to
# nicely disable the ncurses and readline checks in the configure script, yet.
.if exists(${LOCALBASE}/include/ncurses.h)
DEPENDS+=		ncurses>=4.2:../../devel/ncurses
.endif
.if exists(${LOCALBASE}/include/readline.h)
DEPENDS+=		readline-4.0:../../devel/readline
d23 2
a24 12
MAKEFILE=		GNUmakefile
USE_GMAKE=		YES
USE_LIBTOOL=		YES

# Don't use GNU_CONFIGURE or else bsd.pkg.mk will override our custom PREFIX.
HAS_CONFIGURE=		YES

.include "../../mk/bsd.prefs.mk"

# If you don't want to use the Tcl/Tk frontend pgaccess, then you need to
# remove Tcl/Tk support by defining `PGSQL_USE_TCL=NO' in /etc/mk.conf
# or by typing: ${MAKE} PGSQL_USE_TCL=NO.
a25 32

# Default to building with Tcl/Tk interface.
#
PGSQL_USE_TCL?=		YES
PGSQL_USE_TK?=		YES

.if (${PGSQL_USE_TCL} == "YES")
DEPENDS+=		tcl-8.0.5:../../lang/tcl80

TCLSH=			${LOCALBASE}/bin/tclsh8.0
TCL_INCDIR=		${LOCALBASE}/include/tcl8.0
TCL_CONFIGDIR=		${LOCALBASE}/lib/tcl8.0

CONFIGURE_ENV+=		TCLSH="${TCLSH}"

.if (${PGSQL_USE_TK} == "YES")
DEPENDS+=		tk-8.0.5:../../x11/tk80

TK_INCDIR=		${LOCALBASE}/include/tk8.0
TK_CONFIGDIR=		${LOCALBASE}/lib/tk8.0

USE_X11=		YES

TK_CONFIG=		--with-tkconfig="${TK_CONFIGDIR}"
.endif
CONFIGURE_ARGS+=	--with-tcl \
			--with-tclconfig="${TCL_CONFIGDIR}" \
			--with-includes="${TCL_INCDIR} ${TK_INCDIR}" \
			--with-libraries="${LOCALBASE}/lib" \
			${TK_CONFIG}
.endif

a27 1
PGPREFIX=		${PREFIX}/${PGUSER}
a28 1
BUILD_DEFS=		PGUSER PGROUP PGSQL_USE_TCL PGSQL_USE_TK
d30 3
a32 1
REQ_FILE=		${WRKDIR}/REQ
d34 1
a34 8
PLIST_SRC=		${PKGDIR}/PLIST.notcl
.if (${PGSQL_USE_TCL} == "YES")
PLIST_SRC+=		${PKGDIR}/PLIST.tcl
.if (${PGSQL_USE_TK} == "YES")
PLIST_SRC+=		${PKGDIR}/PLIST.tk
.endif
.endif
PLIST_SRC+=		${PKGDIR}/PLIST.doc ${PKGDIR}/PLIST.dirrm
d37 13
a49 19
CONFIGURE_ARGS+=	--host=${MACHINE_GNU_PLATFORM} \
			--prefix=${PGPREFIX} \
			--with-template="${LOWER_OPSYS}" \
			--enable-locale
LDFLAGS+=		-Wl,-R${PGPREFIX}/lib -L${PGPREFIX}/lib

pre-extract:
	@@(case "X${PGUSER}" in						\
	Xbin|Xetc|Xinclude|Xinfo|Xlib|Xlibdata|Xlibexec|Xman|Xsbin|Xshare)\
		gooduser=no;						\
		;;							\
	*)								\
		gooduser=yes;						\
		;;							\
	esac;								\
	if [ $$gooduser = "no" ]; then					\
		${ECHO} "You have choosen PGUSER=${PGUSER} which will";	\
		${ECHO} "cause trouble, because postgres would get";	\
		${ECHO} "installed to ${PGPREFIX}. So please";	\
d54 2
a55 1
	fi)
d57 8
a64 2
post-extract:
	@@${CP} ${FILESDIR}/Makefile.custom ${WRKSRC}
d66 3
a68 7
pre-build:
.if ${PGSQL_USE_TCL} == "YES"
	@@${ECHO} "Building PostgreSQL with Tcl/Tk interface library."
.else
	@@${ECHO} "To build without the \"PostgreSQL Tcl/Tk interface library\","
	@@${ECHO} "libpgtcl, type: \"${MAKE} PGSQL_USE_TCL=NO\"."
.endif
d70 5
a74 12
post-build:
	@@${ECHO} "------------------------------------------------------------"
	@@${ECHO} "Dump existing databases, before installing new db version !!"
	@@${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}...  "
	@@${ECHO} "------------------------------------------------------------"

pre-install:
	${RM} -rf ${PGPREFIX}
	${MKDIR} ${PGPREFIX}
	@@${SED}	-e 's|@@LOCALBASE@@|${LOCALBASE}|g' \
		-e 's|@@PGUSER@@|${PGUSER}|g' \
		-e 's|@@PGGROUP@@|${PGGROUP}|g' \
d76 4
a79 6
		< ${PKGDIR}/REQ > ${REQ_FILE}
	${SH} ${REQ_FILE} ${PKGNAME} INSTALL

post-install:
	@@${MV} ${PGPREFIX}/include/libpq++.H ${PGPREFIX}/include/libpq++.h
	@@${TOUCH} ${PGPREFIX}/include/port/bsd/.keep_me
d81 1
a81 15
	@@if [ ! -f ${PGPREFIX}/.profile ]; then \
		(${ECHO} "PATH=\$${PATH}:${PGPREFIX}/bin"; \
		 ${ECHO} "MANPATH=\$${MANPATH}:${PGPREFIX}/man"; \
		 ${ECHO} "PGLIB=${PGPREFIX}/lib"; \
		 ${ECHO} "# note: PGDATA overwrites the -D startup option"; \
		 ${ECHO} "PGDATA=${PGPREFIX}/data"; \
		 ${ECHO} "DISPLAY=:0"; \
		 ${ECHO} "export PATH MANPATH PGLIB PGDATA DISPLAY"; \
		 ${ECHO}; \
		 ${ECHO} "# if you want to make regression tests use this TZ"; \
		 ${ECHO} "#TZ=PST8PDT"; \
		 ${ECHO} "#export TZ"; \
		) > ${PGPREFIX}/.profile; \
	fi
	@@${SED}	-e "s|@@PGPREFIX@@|${PGPREFIX}|g" \
d83 1
d85 1
a85 1
	@@${INSTALL} -c -o root -g ${PGGROUP} -m 554 \
a86 2
	@@${INSTALL} -c -o ${PGUSER} -g ${PGGROUP} -m 444 \
		${FILESDIR}/post-install-notes ${PGPREFIX}
d88 7
a94 8
	@@cd ${WRKDIR}/${DISTNAME}/doc; ${MAKE_PROGRAM} ${INSTALL_TARGET}
	@@for file in \
	    FAQ FAQ_DEV README.fsync TODO bug.template internals.ps \
	    admin.ps.gz programmer.ps.gz tutorial.ps.gz user.ps.gz; do \
		${INSTALL_DATA} ${WRKDIR}/${DISTNAME}/doc/$${file} \
			${PREFIX}/share/doc/postgresql/$${file}; \
	done
	@@${CHOWN} -R ${PGUSER}:${PGGROUP} ${PGPREFIX}
d96 1
a96 2
	@@${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
	@@${ECHO} '${SETENV} PATH=${PGPREFIX}/bin:$$PATH ${PGPREFIX}/bin/initdb --pglib=${PGPREFIX}/lib --pgdata=${PGPREFIX}/data' | ${SU} -l ${PGUSER}
d98 1
a98 1
.include "../../mk/bsd.pkg.mk"
@


1.45
log
@Update dependency on ncurses to >=4.2
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.44 1999/12/28 04:56:09 wiz Exp $
d48 1
a51 1
DEPENDS+=		tk-8.0.5:../../x11/tk80
d56 6
d66 3
a68 1
CONFIGURE_ENV+=		TCLSH="${TCLSH}"
a70 1
			--with-tkconfig="${TK_CONFIGDIR}" \
d72 2
a73 1
			--with-libraries="${LOCALBASE}/lib"
d80 1
a80 1
BUILD_DEFS=		PGUSER PGROUP PGSQL_USE_TCL
d87 3
@


1.44
log
@replaced some commands by their ${COMMAND} counterparts
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.43 1999/12/02 01:47:05 darcy Exp $
d22 1
a22 1
DEPENDS+=		ncurses-4.2:../../devel/ncurses
@


1.43
log
@upgraded PostgreSQL to 6.5.3 and updated the dependent Makefiles
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.42 1999/09/20 23:38:45 jlam Exp $
d171 1
a171 1
	@@${ECHO} '${SETENV} PATH=${PGPREFIX}/bin:$$PATH ${PGPREFIX}/bin/initdb --pglib=${PGPREFIX}/lib --pgdata=${PGPREFIX}/data' | su -l ${PGUSER}
@


1.42
log
@Update PostgreSQL to 6.5.2.  The pgaccess binary is no longer available
from the main PostgreSQL distribution, and must be installed separately
(databases/pgaccess).  Relevant changes from 6.5.1:

       subselect+CASE fixes(Tom)
       Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren
       Sefcik)
       Fixes for CASE in WHERE join clauses(Tom)
       Fix BTScan abort(Tom)
       Repair the check for redundant UNIQUE and PRIMARY KEY indices(Thomas)
       Improve it so that it checks for multi-column constraints(Tom)
       Fix for Win32 making problem with MB enabled(Hiroki Kataoka)
       Allow BSD yacc and bison to compile pl code(Bruce)
       Fix SET NAMES
       int8 fixes(Thomas)
       Fix vacuum's memory consumption(Hiroshi,Tatsuo)
       Reduce the total memory consumption of vacuum(Tom)
       Fix for timestamp(datetime)
       Rule deparsing bugfixes(Tom)
       Fix quoting problems in mkMakefile.tcldefs.sh.in and
       mkMakefile.tkdefs.sh.in(Tom)
       This is to re-use space on index pages freed by vacuum(Vadim)
       document -x for pg_dump(Bruce)
       Fix for unary operators in rule deparser(Tom)
       Comment out FileUnlink of excess segments during mdtruncate()(Tom)
       Irix linking fix from Yu Cao <yucao@@falcon.kla-tencor.com>
       Repair logic error in LIKE: should not return LIKE_ABORT
       when reach end of pattern before end of text(Tom)
       Repair incorrect cleanup of heap memory allocation during transaction
       abort(Tom)
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.41 1999/09/20 03:56:25 jlam Exp $
d5 1
a5 1
DISTNAME=		postgresql-6.5.2
d15 2
a17 1
DEPENDS+=		addnerd-1.6:../../sysutils/addnerd
d124 1
a124 1
	
@


1.41
log
@Change the semantics of PGSQL_USE_TCL to be YES/NO, defaulting to YES since
the old 6.4.2 package included the Tcl/Tk stuff.  "Backwards compatible
upgrade."
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.40 1999/09/19 04:24:53 jlam Exp $
d5 1
a5 1
DISTNAME=		postgresql-6.5.1
d112 1
a112 1
	@@${ECHO} "Building PostgreSQL with \"libpgtcl\"."
d114 1
a114 1
	@@${ECHO} "To build without the \"PostgreSQL Tcl interface library\","
@


1.40
log
@Update postgresql to 6.5.1.  Completely libtoolized and ldconfig statements
removed, but this should still function correctly on a.out systems.  This
package was originally submitted by D'Arcy J.M. Cain, but with major
overhauling by me.

Closes PR#7865 and relevant part of PR#8299.

Major changes from version 6.4.2:

        Multi-version concurrency control(MVCC)
          This removes our old table-level locking, and replaces it with a
         locking system that is superior to most commercial database
         systems. In a traditional system, each row that is modified is
         locked until committed, preventing reads by other users. MVCC
         uses the natural multi-version nature of PostgreSQL to allow
         readers to continue reading consistent data during writer
         activity. Writers continue to use the compact pg_log transaction
         system. This is all performed without having to allocate a lock
         for every row like traditional database systems. So, basically,
         we no longer are restricted by simple table-level locking; we
         have something better than row-level locking.

        Hot backups from pg_dump
          pg_dump takes advantage of the new MVCC features to give a
         consistant database dump/backup while the database stays online
         and available for queries.

        Numeric data type
          We now have a true numeric data type, with user-specified
         precision.

        Temporary tables
          Temporary tables are guaranteed to have unique names within a
         database session, and are destroyed on session exit.

        New SQL features
          We now have CASE, INTERSECT, and EXCEPT statement support. We
         have new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL, SELECT
         ... FOR UPDATE, and an improved LOCK TABLE command.

        Speedups
          We continue to speed up PostgreSQL, thanks to the variety of
         talents within our team. We have sped up memory allocation,
         optimization, table joins, and row transfer routines.

        Ports
          We continue to expand our port list, this time including
         WinNT/ix86 and NetBSD/arm32.

        Interfaces
          Most interfaces have new versions, and existing functionality
         has been improved.

        Documentation
          New and updated material is present throughout the
         documentation. New FAQs have been contributed for SGI and AIX
         platforms. The Tutorial has introductory information on SQL from
         Stefan Simkovics. For the User's Guide, there are reference pages
         covering the postmaster and more utility programs, and a new
         appendix contains details on date/time behavior. The
         Administrator's Guide has a new chapter on troubleshooting from
         Tom Lane. And the Programmer's Guide has a description of query
         processing, also from Stefan, and details on obtaining the
         Postgres source tree via anonymous CVS and CVSup.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.34 1999/06/06 14:25:45 tv Exp $
d39 3
a41 3
# If you want to use the tcl/tk frontend pgaccess, then you need to build
# postgresql with tcl support by defining `PGSQL_USE_TCL=' in /etc/mk.conf
# or by typing: ${MAKE} PGSQL_USE_TCL=.
d43 6
a48 1
.if defined(PGSQL_USE_TCL)
d71 1
a71 1
BUILD_DEFS=		PGUSER PGROUP
d76 1
a76 1
.if defined(PGSQL_USE_TCL)
d106 6
a111 1
.if defined(PGSQL_USE_TCL)
d114 2
a115 2
	@@${ECHO} "To build the \"PostgreSQL Tcl interface library\","
	@@${ECHO} "libpgtcl, type: \"${MAKE} PGSQL_USE_TCL=\"."
a116 3

pre-build:
	@@${CP} ${FILESDIR}/Makefile.custom ${WRKSRC}
@


1.39
log
@Add dependency on ncurses, and create ${PREFIX}/${PGUSER} before
"make install". Makes this package compile on 1.4.1.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.38 1999/09/06 07:01:43 sakamoto Exp $
d5 1
a5 1
DISTNAME=		postgresql-6.4.2
d12 1
a12 1
MAINTAINER=		packages@@netbsd.org
d16 10
a25 4
DEPENDS+=		tk-8.0.5:../../x11/tk80 \
			tcl-8.0.5:../../lang/tcl80 \
			addnerd-1.6:../../sysutils/addnerd \
			ncurses-4.2:../../devel/ncurses
d30 31
a60 1
REQ_FILE=		${WRKDIR}/REQ
d64 1
a64 1
PLIST_SUBST=		PGUSER=${PGUSER}
d66 3
a68 10
USE_GMAKE=
MAKEFILE=		GNUmakefile
HAS_CONFIGURE=		yes
CONFIGURE_ARGS= 	--prefix=${PREFIX}/${PGUSER} \
			--enable-locale \
			--with-tcl \
			--with-tclconfig="${LOCALBASE}/lib/tcl8.0 ${LOCALBASE}/lib/tk8.0" \
			--with-includes="${LOCALBASE}/include ${LOCALBASE}/include/tcl8.0 ${LOCALBASE}/include/tk8.0" \
			--with-libs=${PREFIX}/lib \
			--with-template=`${ECHO} ${OPSYS} | ${TR} '[A-Z]' '[a-z]'`
d70 6
a75 1
INSTALL_TARGET=		install install-man
d77 5
a81 3
BUILD_DEFS+=		PGGROUP PGUSER

.include "../../mk/bsd.prefs.mk"
d95 1
a95 1
		${ECHO} "installed to ${PREFIX}/${PGUSER}. So please";	\
d101 9
d112 5
a116 5
	@@ ${ECHO} "------------------------------------------------------------"
	@@ ${ECHO} "Dump existing databases, before installing new db version !!"
	@@ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}...  "
	@@ ${ECHO} "------------------------------------------------------------"

d118 3
a120 3
	${RM} -rf ${PREFIX}/${PGUSER}
	${MKDIR} ${PREFIX}/${PGUSER}
	@@${SED}  \
d124 1
a124 2
		-e 's|@@LOCALBASE@@|${LOCALBASE}|g' \
		<${PKGDIR}/REQ > ${REQ_FILE}
d128 16
a143 21
	@@ if [ ! -f ${PREFIX}/${PGUSER}/.profile ]; then \
		${ECHO} "PATH=\$${PATH}:${PREFIX}/${PGUSER}/bin" \
			> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "MANPATH=\$${MANPATH}:${PREFIX}/${PGUSER}/man" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "PGLIB=${PREFIX}/${PGUSER}/lib" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "# note: PGDATA overwrites the -D startup option" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "PGDATA=${PREFIX}/${PGUSER}/data" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "DISPLAY=:0" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "export PATH MANPATH PGLIB PGDATA DISPLAY" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "# if you want to make regression tests use this TZ" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "#TZ=PST8PDT" \
			>> ${PREFIX}/${PGUSER}/.profile; \
		${ECHO} "#export TZ" \
			>> ${PREFIX}/${PGUSER}/.profile; \
d145 17
a161 1
	@@${CHOWN} -R ${PGUSER}:${PGGROUP} ${PREFIX}/${PGUSER}
d163 1
a163 26
	${LDCONFIG} ${PREFIX}/${PGUSER}/lib || ${TRUE}
	@@${ECHO} '${SETENV} PATH=${PREFIX}/${PGUSER}/bin:$$PATH ${PREFIX}/${PGUSER}/bin/initdb --pglib=${PREFIX}/${PGUSER}/lib --pgdata=${PREFIX}/${PGUSER}/data' | ${SU} -l ${PGUSER}
	@@${SED} -e "s=!!PREFIX!!=${PREFIX}=g" -e "s=!!PGUSER!!=${PGUSER}=g" \
		< ${FILESDIR}/pgsql.sh.tmpl > ${PREFIX}/etc/rc.d/pgsql.sh
	@@${CHMOD} 554 ${PREFIX}/etc/rc.d/pgsql.sh
	@@${CHOWN} root:${PGGROUP} ${PREFIX}/etc/rc.d/pgsql.sh
	@@${INSTALL} -c -o ${PGUSER} -g ${PGGROUP} -m 444 \
		${FILESDIR}/post-install-notes ${PREFIX}/${PGUSER}
	-${MKDIR} ${PREFIX}/share/doc/pgsql
	${CP} -R ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql
	${RM} -rf ${PREFIX}/share/doc/pgsql/src/CVS \
		${PREFIX}/share/doc/pgsql/src/graphics/CVS \
		${PREFIX}/share/doc/pgsql/src/sgml/ref/CVS \
		${PREFIX}/share/doc/pgsql/src/sgml/CVS \
		${PREFIX}/share/doc/pgsql/CVS
.if !defined(BATCH)
	@@${CAT} ${FILESDIR}/post-install-notes
.endif
	@@case `${GREP} -c '^${PREFIX}/${PGUSER}/lib$$' /etc/ld.so.conf` in	\
	0)									\
		${ECHO} "************** WARNING ********************";		\
		${ECHO} "Please add ${PREFIX}/${PGUSER}/lib to /etc/ld.so.conf";\
		${ECHO} "so that this package is usable after any reboot";	\
		${ECHO} "************** WARNING ********************";		\
		;;								\
	esac
@


1.38
log
@Use "PLIST_SUBST=PGUSER=${PGUSER}".
Add NetBSD Id to patch-ae.
s|/usr/sbin/chown|${CHOWN}|
s|/bin/chmod|${CHMOD}|
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.37 1999/08/24 14:18:53 tron Exp $
d18 2
a19 1
			addnerd-1.6:../../sysutils/addnerd
d74 1
@


1.37
log
@Make sure that "bison" binary from package sources is used.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.36 1999/08/18 09:00:23 agc Exp $
a22 1
PLIST_SRC=		${WRKDIR}/PLIST.tmp
d27 1
a78 3
	@@${SED}  \
		-e 's|@@PGUSER@@|${PGUSER}|g' \
		<${PKGDIR}/PLIST > ${PLIST_SRC}
d104 1
a104 1
	@@/usr/sbin/chown -R ${PGUSER}:${PGGROUP} ${PREFIX}/${PGUSER}
d107 1
a107 1
	@@${ECHO} '${SETENV} PATH=${PREFIX}/${PGUSER}/bin:$$PATH ${PREFIX}/${PGUSER}/bin/initdb --pglib=${PREFIX}/${PGUSER}/lib --pgdata=${PREFIX}/${PGUSER}/data' | su -l ${PGUSER}
d110 2
a111 2
	@@/bin/chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh
	@@/usr/sbin/chown root:${PGGROUP} ${PREFIX}/etc/rc.d/pgsql.sh
@


1.36
log
@Record build options in the BuildInfo file via BUILD_DEFS. These can be
displayed using the -B option to pkg_info(1).
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.35 1999/07/13 17:42:57 bad Exp $
d15 1
a15 1
BUILD_DEPENDS+=		bison:../../devel/bison
@


1.35
log
@Must list tcl and tk includes in --with-includes.  Noticed by
Bjoern Labitzke.

Also, libs and includes are found in LOCALBASE.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.34 1999/06/06 14:25:45 tv Exp $
d40 3
a42 1
INSTALL_TARGET=	install install-man
@


1.34
log
@${...:M...} is not fully glob() compliant.  Don't use {,} constructs.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.33 1999/06/04 16:55:12 drochner Exp $
d35 2
a36 2
			--with-tclconfig="${PREFIX}/lib/tcl8.0 ${PREFIX}/lib/tk8.0" \
			--with-includes=${PREFIX}/include \
a38 1
CPPFLAGS+=		-I${LOCALBASE}/include/tcl8.0 -I${LOCALBASE}/include/tk8.0
@


1.33
log
@NOT_FOR_PLATFORM= *-*-{alpha,mips} doesn't work.
Worse - it matches (almost?) everything.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.32 1999/05/24 20:39:36 tv Exp $
d39 1
a39 1
CONFIGURE_ENV+=		CPPFLAGS="-I${PREFIX}/include/tcl8.0 -I${PREFIX}/include/tk8.0"
@


1.32
log
@Change {ONLY,NOT}_FOR_{ARCH,OPSYS} format to {ONLY,NOT}_FOR_PLATFORM
pattern match format.  Minor pkglint along the way.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.31 1999/04/13 15:31:05 agc Exp $
d21 1
a21 1
NOT_FOR_PLATFORM=	*-*-{alpha,mips}
@


1.31
log
@Remove NOPORTDOCS definition - it was useless anyway, as any attempt to
build a binary package with this definition would fail as the PLIST is
not correct.

If a package's documentation is overwhelming, it should arguably be handled
in a separate pre-requisite documentation package.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.30 1999/04/01 13:36:55 agc Exp $
d5 14
a18 14
DISTNAME=	postgresql-6.4.2
WRKSRC=		${WRKDIR}/${DISTNAME}/src
CATEGORIES=	databases
MASTER_SITES=	ftp://ftp.PostgreSQL.org/pub/ \
		ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/ \
		ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/

MAINTAINER=	packages@@netbsd.org
HOMEPAGE=	http://www.PostgreSQL.ORG/

BUILD_DEPENDS+=	bison:../../devel/bison
DEPENDS+=	tk-8.0.5:../../x11/tk80
DEPENDS+=	tcl-8.0.5:../../lang/tcl80
DEPENDS+=	addnerd-1.6:../../sysutils/addnerd
d21 1
a21 1
NOT_FOR_ARCHS=	alpha mips
d23 2
a24 2
PLIST_SRC=	${WRKDIR}/PLIST.tmp
REQ_FILE=	${WRKDIR}/REQ
d26 2
a27 2
PGUSER?=	pgsql
PGGROUP?=	ingres
d29 11
a39 11
USE_GMAKE=	yes
MAKEFILE=	GNUmakefile
HAS_CONFIGURE=	yes
CONFIGURE_ARGS= --prefix=${PREFIX}/${PGUSER} \
		--enable-locale \
		--with-tcl \
		--with-tclconfig="${PREFIX}/lib/tcl8.0 ${PREFIX}/lib/tk8.0" \
		--with-includes=${PREFIX}/include \
		--with-libs=${PREFIX}/lib \
		--with-template=`${ECHO} ${OPSYS} | ${TR} '[A-Z]' '[a-z]'`
CONFIGURE_ENV+=	CPPFLAGS="-I${PREFIX}/include/tcl8.0 -I${PREFIX}/include/tk8.0"
@


1.30
log
@Upgrade to tcl version 8.0.5. This seems to be primarily a bug-fix
release.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.29 1999/03/28 21:50:17 hubertf Exp $
a115 1
.if !defined(NOPORTDOCS)
a122 1
.endif
@


1.29
log
@Make it possible to build a binary package by moving the "account
management" into a REQ script.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.28 1999/02/19 09:02:25 frueauf Exp $
d16 2
a17 2
DEPENDS+=	tk-8.0p2:../../x11/tk80
DEPENDS+=	tcl-8.0p2:../../lang/tcl80
@


1.28
log
@Chane versioned DEPENDS on bison to BUILD_DEPENDS. This should have been
done with the bison update.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.27 1999/02/06 20:06:32 hwr Exp $
a22 2
NO_PACKAGE=	"Requires pgsql uid"

d24 1
a70 1
.if defined(PACKAGE_BUILDING)
d72 10
a81 3
.endif
	@@${SETENV} ${MAKE_ENV} ${PREFIX}/sbin/addnerd -h ${PREFIX} -g ${PGGROUP} ${PGUSER}
	@@${SED} -e 's|@@PGUSER@@|${PGUSER}|g' ${PKGDIR}/PLIST > ${PLIST_SRC}
@


1.27
log
@Don't build the directory, as addnerd does this for us and will fail
if it already exists. Should fix pkg/6949 by Nigel Reed <nigel@@nelgin.nu>.
Also don't assume ${prefix}/sbin is in the search path and call addnerd
with complete path.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.26 1999/01/17 00:59:37 frueauf Exp $
d3 1
d15 1
a18 3
DEPENDS+=	bison-1.25:../../devel/bison

CONFLICTS=	postgresql-6.3.2
@


1.26
log
@Whoops, I wanted to adjust the comment.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.25 1999/01/17 00:52:08 frueauf Exp $
d76 1
a76 2
	-@@${MKDIR} ${PREFIX}/${PGUSER}
	@@${SETENV} ${MAKE_ENV} addnerd -h ${PREFIX} -g ${PGGROUP} ${PGUSER}
@


1.25
log
@Add mips to NOT_FOR_ARCHS list. There is no TAS implementation.
Someone with mips assemply knowledge needed :)
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.24 1999/01/09 20:49:26 kleink Exp $
d22 1
a22 1
NOT_FOR_ARCHS=	alpha mips	# Needs ELF clue, mips has no TAS implementation
@


1.24
log
@Get rid of obsolete chown(8) operand usage.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.23 1999/01/08 11:17:21 frueauf Exp $
d21 2
a22 1
NOT_FOR_ARCHS=	alpha	# Needs ELF clue
@


1.23
log
@Add some cosmetics pointed out in pr 6758 by Greg A. Woods:

- add INSTALL_TARGET=install install-man and remove the patch that did
  modify the GNUMakefile, for better maintainance.
- add - in front of @@${MKDIR} to silently fail if the dir already exists
- move ld.so.conf warning near the end, so it can be better spotted.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.22 1999/01/04 13:05:01 frueauf Exp $
d109 1
a109 1
	@@/usr/sbin/chown root.${PGGROUP} ${PREFIX}/etc/rc.d/pgsql.sh
@


1.22
log
@Update postgresql to 6.4.2. Among bugfixes and new features, this also
adds patches for m68k support, provided in pr 6664 by MOCHIDA Shuji.
@
text
@d1 1
a1 1
# $NetBSD$
d36 1
a36 1
		--with-tclconfig=${PREFIX}/lib/tcl8.0 \
d42 2
d75 1
a75 1
	@@${MKDIR} ${PREFIX}/${PGUSER}
a103 8
	@@case `${GREP} -c '^${PREFIX}/${PGUSER}/lib$$' /etc/ld.so.conf` in	\
	0)									\
		${ECHO} "************** WARNING ********************";		\
		${ECHO} "Please add ${PREFIX}/${PGUSER}/lib to /etc/ld.so.conf";\
		${ECHO} "so that this package is usable after any reboot";	\
		${ECHO} "************** WARNING ********************";		\
		;;								\
	esac
d113 1
a113 1
	${MKDIR} ${PREFIX}/share/doc/pgsql
d124 8
@


1.21
log
@Reflect that addnerd has version 1.6 now, as noted in pr 6721.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.20 1998/11/16 21:13:01 agc Exp $
d4 2
a5 1
DISTNAME=	postgresql-6.3.2
d8 1
d19 2
a21 1
NOT_FOR_ARCHS+=	m68k
a24 1
WRKSRC=		${WRKDIR}/${DISTNAME}/src
d36 1
d40 1
d110 1
d112 2
a113 2
	@@${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
		> ${PREFIX}/etc/rc.d/pgsql.sh
d116 2
a117 1
	@@${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/${PGUSER}
d121 5
@


1.20
log
@Use ${OPSYS}, rather than calling `uname -s` again.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.19 1998/11/12 16:24:39 agc Exp $
d14 1
a14 1
DEPENDS+=	addnerd-1.5:../../sysutils/addnerd
@


1.19
log
@Group the NOT_FOR_ARCHS definitions together, for consistency, and make
the second definition "+=", rather than "=".
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.18 1998/09/22 06:11:35 garbled Exp $
d36 1
a36 1
		--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'`
@


1.18
log
@add NOT_FOR_ARCHS= alpha for all of these pkgs which are *known* to fail
on alpha.  There may be more, but I haven't seen them yet.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.17 1998/09/10 11:46:31 frueauf Exp $
a8 2
NOT_FOR_ARCHS=	alpha	# Needs ELF clue

d17 2
a18 1
NOT_FOR_ARCHS=	m68k
@


1.17
log
@Set NOT_FOR_ARCHS=m68k since postgres does not work on this architecture yet.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.16 1998/08/20 15:16:44 tsarna Exp $
d8 2
@


1.16
log
@The Grand Homepagification:
	- New, optional Makefile variable HOMEPAGE, specifies a URL for
	  the home page of the software if it has one.
	- The value of HOMEPAGE is used to add a link from the
	  README.html files.
	- pkglint updated to know about it.  The "correct" location for
	  HOMEPAGE in the Makefile is after MAINTAINER, in that same
	  section.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.15 1998/07/15 12:40:14 agc Exp $
d16 2
@


1.15
log
@Use automatic shared object handling
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.14 1998/06/22 13:58:26 frueauf Exp $
d10 1
@


1.14
log
@Add bison to DEPENDS; give addnerd the homedir path; be sure that .profile
gets installed to ${PGUSER}s home. Pointed out by Mathias Drochner.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.13 1998/06/22 11:19:41 agc Exp $
d94 8
a101 1
	@@${LDCONFIG} -m ${PREFIX}/${PGUSER}/lib || ${TRUE}
@


1.13
log
@Update package Makefiles for automatic manual page handling.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.12 1998/06/10 13:55:34 agc Exp $
d14 1
d17 1
d19 1
d27 1
a27 1
CONFIGURE_ARGS= --prefix=${PREFIX}/pgsql \
d36 19
d63 1
a63 1
	${RM} -rf ${PREFIX}/pgsql
d65 3
a67 2
	@@${MKDIR} ${PREFIX}/pgsql
	@@${SETENV} ${MAKE_ENV} addnerd -g ${PGGROUP} ${PGUSER}
d70 7
a76 7
	@@ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \
		${ECHO} "PATH=\$${PATH}:${PREFIX}/pgsql/bin" \
			> ${PREFIX}/pgsql/.profile; \
		${ECHO} "MANPATH=\$${MANPATH}:${PREFIX}/pgsql/bin" \
			>> ${PREFIX}/pgsql/.profile; \
		${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \
			>> ${PREFIX}/pgsql/.profile; \
d78 3
a80 3
			>> ${PREFIX}/pgsql/.profile; \
		${ECHO} "PGDATA=${PREFIX}/pgsql/data" \
			>> ${PREFIX}/pgsql/.profile; \
d82 1
a82 1
			>> ${PREFIX}/pgsql/.profile; \
d84 1
a84 1
			>> ${PREFIX}/pgsql/.profile; \
d86 1
a86 1
			>> ${PREFIX}/pgsql/.profile; \
d88 1
a88 1
			>> ${PREFIX}/pgsql/.profile; \
d90 1
a90 1
			>> ${PREFIX}/pgsql/.profile; \
d92 1
a92 1
	@@/usr/sbin/chown -R ${PGUSER}:${PGGROUP} ${PREFIX}/pgsql
d94 2
a95 2
	@@${LDCONFIG} -m ${PREFIX}/pgsql/lib || ${TRUE}
	@@${ECHO} '${SETENV} PATH=${PREFIX}/pgsql/bin:$$PATH ${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' | su -l ${PGUSER}
d100 1
a100 1
	@@${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
@


1.12
log
@Upgrade to the latest and greatest version (6.3.2) of PostgreSQL.
They told me to say that.

Use addnerd to create the user.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.11 1998/06/03 12:43:25 agc Exp $
a29 22

MAN1=		cleardbdir.1 createdb.1 createuser.1 destroydb.1 \
		destroyuser.1 initdb.1 ipcclean.1 pg_dump.1 \
		pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \
		postmaster.1 psql.1 initlocation.1 ecpg.1
MAN3=		catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3
MAN5=		bki.5 page.5 pg_hba.conf.5
MANL=		abort.l alter_table.l begin.l close.l cluster.l \
		commit.l copy.l create_aggregate.l create_database.l \
		create_function.l create_index.l create_operator.l \
		create_rule.l create_sequence.l create_table.l \
		create_trigger.l create_type.l create_version.l \
		create_view.l declare.l delete.l drop.l drop_aggregate.l \
		drop_database.l drop_function.l drop_index.l drop_operator.l \
		drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \
		drop_type.l drop_view.l end.l explain.l fetch.l grant.l \
		insert.l listen.l load.l move.l notify.l \
		reset.l revoke.l rollback.l select.l set.l show.l sql.l \
		update.l vacuum.l lock.l drop_user.l drop_language.l \
		create_user.l create_language.l alter_user.l

MANPREFIX=	${PREFIX}/pgsql
@


1.11
log
@Include bsd.prefs.mk, so that /etc/mk.conf is read properly
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.10 1998/05/09 15:24:42 frueauf Exp $
d4 1
a4 1
DISTNAME=	postgresql-6.2.1
d13 1
a16 1
ONLY_FOR_ARCHS=	i386
d19 1
d21 1
a21 2
USE_GMAKE=	YES
USE_PERL5=	yes
d23 1
a23 2
MAKE_ENV+=	USE_TCL=true
HAS_CONFIGURE=	YES
d26 3
d32 1
a32 1
		destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \
d34 1
a34 1
		postmaster.1 psql.1
d46 1
a46 1
		insert.l listen.l load.l move.l notify.l purge.l rename.l \
d48 2
a49 1
		update.l vacuum.l
d65 2
a66 2
	@@ ${MKDIR} ${PREFIX}/pgsql
	@@ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser ${PGUSER}
d91 1
a91 1
	@@/usr/sbin/chown -R ${PGUSER}:${PGUSER} ${PREFIX}/pgsql
d94 1
a94 1
	@@${ECHO} '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' | su -l ${PGUSER}
d98 1
a98 1
	@@/usr/sbin/chown root.${PGUSER} ${PREFIX}/etc/rc.d/pgsql.sh
@


1.10
log
@Mostly cosmetic changes to shut up portlint. Little bugfix for apache.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.9 1998/04/22 14:22:40 agc Exp $
d49 2
@


1.9
log
@Remove the old deprecated DEPENDS definition from bsd.pkg.mk.
Implement a new DEPENDS definition, which looks for an installed
package, building it if not present, and use it in preference to
LIB_DEPENDS.  This should make the package collection more useful on
NetBSD ELF ports.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.8 1998/04/20 11:56:22 frueauf Exp $
a10 1
MAKE_ENV+=	USE_TCL=true
d23 1
@


1.8
log
@Substitute all obvious FreeBSD ppl as MAINTAINER with packages@@netbsd.org.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.7 1998/04/15 10:38:18 agc Exp $
d12 2
a13 2
LIB_DEPENDS+=	tcl80.1.:${PORTSDIR}/lang/tcl80 \
		tk80.1.:${PORTSDIR}/x11/tk80
@


1.7
log
@Use the bsd.pkg.mk and bsd.pkg.subdir.mk files in the pkgsrc tree.
Remove redundant (and sometimes erroneous) comments.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.6 1998/03/16 14:40:48 hubertf Exp $
d9 1
a9 1
MAINTAINER=	andreas@@FreeBSD.ORG
@


1.6
log
@Fix last commit after feedback from Klaus.
@
text
@d1 1
a1 6
# New ports collection makefile for:	PostgreSQL
# Version required:	6.2.1
# Date created:		April 2, 1997
# Whom:			Marc G. Fournier <scrappy@@FreeBSD.ORG>
#
# $NetBSD: Makefile,v 1.5 1998/03/16 12:57:37 hubertf Exp $
d103 1
a103 1
.include <bsd.port.mk>
@


1.5
log
@don't expand PATH and MANPATH - fixes PR 5165 by Klaus Klein.
@
text
@d6 1
a6 1
# $NetBSD: Makefile,v 1.4 1998/02/18 17:35:25 agc Exp $
d70 1
a70 1
		${ECHO} "PATH=$${PATH}:${PREFIX}/pgsql/bin" \
d72 1
a72 1
		${ECHO} "MANPATH=$${MANPATH}'":${PREFIX}/pgsql/bin" \
@


1.4
log
@The .if defined(USE_TCL) part wouldn't work anyway, so don't bother
checking just now.

The 'recursive' argument to cp(1) is -R, not -r.
@
text
@d6 1
a6 1
# $NetBSD: Makefile,v 1.3 1998/02/18 11:50:33 frueauf Exp $
d70 1
a70 1
		${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \
d72 1
a72 1
		${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \
@


1.3
log
@portlint: add "|| ${TRUE}" after ldconfig.
@
text
@d6 1
a6 1
# $NetBSD: Makefile,v 1.2 1998/02/17 15:37:40 agc Exp $
d16 3
a18 4
.if defined(USE_TCL)
MAKE_ENV=	USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0
LIB_DEPENDS=	tcl80.1.:${PORTSDIR}/lang/tcl80
.endif
d102 1
a102 1
	${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql
@


1.2
log
@Mention dependency on Perl5.
Define PGUSER variable, and use it (defaults to pgsql).
Add NetBSD RCS Id.
There is no '-c' argument to NetBSD's su(1).
cat post-install-notes, rather than using more(1). Just in case.
Use explicit paths for executables.
@
text
@d6 1
a6 1
# $NetBSD$
d94 1
a94 1
	@@${LDCONFIG} -m ${PREFIX}/pgsql/lib
@


1.1
log
@Initial revision
@
text
@d6 1
a15 2
# if you want to use the tcl/tk frontend pgaccess, then you need to build
# postgresql with tcl support by typing: make USE_TCL=yes
d18 1
a18 1
LIB_DEPENDS=	tcl80\\.1\\.:${PORTSDIR}/lang/tcl80
d23 3
d28 1
a55 8
pre-fetch:
.if !defined(USE_TCL)
	@@${ECHO_MSG} "To build the \"PostgreSQL to Tcl interface library\", libpgtcl, type:"
	@@${ECHO_MSG} "    make USE_TCL=yes"
.else
	@@${ECHO_MSG} "Building PostgreSQL with \"libpgtcl\"."
.endif

d64 1
a64 1
	/bin/rm -rf ${PREFIX}/pgsql
d67 1
a67 1
	@@ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser
d92 5
a96 5
	@@ chown -R pgsql:pgsql ${PREFIX}/pgsql
	@@ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
	@@ ${LDCONFIG} -m ${PREFIX}/pgsql/lib
	@@ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data'
	@@ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
d98 3
a100 3
	@@ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh
	@@ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh
	@@ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
d106 1
a106 1
	@@ more -e ${FILESDIR}/post-install-notes
@


1.1.1.1
log
@Initial import of Postgresql 6.2.1, an Object Relational Database
Management System, into the NetBSD packages collection, from the
FreeBSD port.
@
text
@@