Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:		75344
Approved by:	portmgr@ (kris), ade & sean (mentors)

1 files changed, 11 insertions, 40 deletions

diff --git a/mail/dspam-devel/Makefile b/mail/dspam-devel/Makefile
index d89a0c827d47..9975836fc47e 100644
--- a/mail/dspam-devel/Makefile
+++ b/mail/dspam-devel/Makefile
@@ -19,7 +19,7 @@ WRKSRC=		${WRKDIR}/dspam-cvs-devel${SNAP_DATE}
 .else
 WRKSRC=		${WRKDIR}/dspam-${PORTVER_MAJ}
 .endif
-  
+
 #SNAP_DATE=	.20041225.1815
 PORTVER_MAJ=	3.3.4
 
@@ -50,8 +50,7 @@ OPTIONS+=	MYSQL40 "Use MySQL 4.0.x as back-end" on
 OPTIONS+=	MYSQL41 "Use MySQL 4.1.x as back-end" off
 OPTIONS+=	MYSQL50 "Use MySQL 5.0.x as back-end" off
 OPTIONS+=	MYSQL_COMPRESS "Compress dspam <--> MySQL" off
-OPTIONS+=	POSTGRESQL73 "Use PostgreSQL v.7.3 as back-end" off
-OPTIONS+=	POSTGRESQL74 "Use PostgreSQL v.7.4 as back-end" off
+OPTIONS+=	POSTGRESQL "Use PostgreSQL as back-end" off
 OPTIONS+=	ORACLE "Use Oracle as back-end (BROKEN)" off
 OPTIONS+=	BDB4 "Use BDB4 as back-end (not recomanded)" off
 OPTIONS+=	SQLITE2 "Use SQLite v2.x as back-end" off
@@ -213,26 +212,8 @@ CONFIGURE_ARGS+=	--disable-trusted-user-security
 DBDRV_TOTAL_COUNT=	ooooooooo # 9
 DBDRV_COUNT=	${DBDRV_TOTAL_COUNT}
 
-.if defined(WITH_POSTGRESQL73)
-LIB_DEPENDS+=	pq.3:${PORTSDIR}/databases/postgresql73
-#BUILD_DEPENDS+= ${LIB_DEPENDS}
-CONFIGURE_ARGS+=	--with-storage-driver=pgsql_drv \
-		--with-pgsql-includes=${LOCALBASE}/include \
-		--with-pgsql-libraries=${LOCALBASE}/lib
-PLIST_SUB+=	DB4="@comment "
-PLIST_SUB+=	MYSQL="@comment "
-PLIST_SUB+=	PGSQL=""
-PLIST_SUB+=	SQLITE="@comment "
-SED_SCRIPT+=	-e '/%%MYSQL%%/D'
-SED_SCRIPT+=	-e 's,%%PGSQL%%,,g'
-SED_SCRIPT+=	-e '/%%SQLITE%%/D'
-#PKGNAMESUFFIX=	-pgsql73
-DBDRV_COUNT:=	${DBDRV_COUNT:S/o//}
-.endif
-
-.if defined(WITH_POSTGRESQL74)
-LIB_DEPENDS+=	ecpg.4:${PORTSDIR}/databases/postgresql7
-#BUILD_DEPENDS+=	${LIB_DEPENDS}
+.if defined(WITH_POSTGRESQL)
+USE_PGSQL=	YES
 CONFIGURE_ARGS+=	--with-storage-driver=pgsql_drv \
 		--with-pgsql-includes=${LOCALBASE}/include \
 		--with-pgsql-libraries=${LOCALBASE}/lib
@@ -243,7 +224,7 @@ PLIST_SUB+=	SQLITE="@comment "
 SED_SCRIPT+=	-e '/%%MYSQL%%/D'
 SED_SCRIPT+=	-e 's,%%PGSQL%%,,g'
 SED_SCRIPT+=	-e '/%%SQLITE%%/D'
-#PKGNAMESUFFIX=	-pgsql74
+#PKGNAMESUFFIX=	-pgsql
 DBDRV_COUNT:=	${DBDRV_COUNT:S/o//}
 .endif
 
@@ -361,7 +342,7 @@ LDA_COUNT:=	${LDA_COUNT:S/o//}
 .if defined(WITH_EXIM_LDA)
 .	if defined(WITH_MYSQL40) || (WITH_MYSQL41)
 _EXIM_EXT=	-mysql
-.	elseif defined(WITH_POSTGRESQL74) || defined(WITH_POSTGRESQL73)
+.	elseif defined(WITH_POSTGRESQL)
 ####
 ### fix me for pg 7.3: how to pass the db option to exim port ?
 ###
@@ -457,16 +438,6 @@ pre-everything::
 	@${ECHO_CMD} ""
 
 pre-extract:
-.if defined(WITH_EXIM_LDA) && defined(WITH_POSTGRESQL73)
-	@${ECHO_CMD} "******************************************************************"
-	@${ECHO_CMD} "You have both EXIM_LDA and POSTGRESQL73 defined. To have exim"
-	@${ECHO_CMD} "built with the right pgsql please hit Ctrl-C now and do:"
-	@${ECHO_CMD} "cd ${PORTSDIR}/mail/exim-postgresql && make POSTGRESQL_PORT=postgresql73 inst
-	@${ECHO_CMD} "then return here and do:"
-	@${ECHO_CMD} "make clean && make install"
-	@${ECHO_CMD} "******************************************************************"
-	@${ECHO_CMD} ""
-.endif
 	@${ECHO_CMD} "Define vars below before make-ing if you need:"
 	@${ECHO_CMD} ""
 	@${ECHO_CMD} "SIGNATURE_LIFE=${SIGNATURE_LIFE} (default 15)"
@@ -540,22 +511,22 @@ pre-configure:
 	@${ECHO_CMD} "You can use one and only one database back-end at once."
 	@${FALSE}
 .endif
-.if defined(WITH_NEURAL_NET) && !(defined(USE_MYSQL) || defined(WITH_POSTGRESQL73) || defined(WITH_POSTGRESQL74))
+.if defined(WITH_NEURAL_NET) && !(defined(USE_MYSQL) || defined(WITH_POSTGRESQL))
 	@${ECHO_CMD} "You need MySQL or POSTGRESQL to use neural networking."
 	@${FALSE}
 .endif
 .if defined(WITH_VIRT_USERS) && !(defined(USE_MYSQL) || \
-	defined(WITH_POSTGRESQL73) || defined(WITH_POSTGRESQL74) || defined(WITH_ORACLE))
+	defined(WITH_POSTGRESQL) || defined(WITH_ORACLE))
 	@${ECHO_CMD} "You need MySQL, POSTGRESQL or ORACLE for virtual users."
 	@${FALSE}
 .endif
 .if defined(WITH_PREF_EXT) && !( defined(USE_MYSQL) || \
-	defined(WITH_POSTGRESQL73) || defined(WITH_POSTGRESQL74) )
+	defined(WITH_POSTGRESQL) )
 	@${ECHO_CMD} "You need MySQL or Postgres for preferences extension"
 	@${FALSE}
 .endif
 .if defined(WITH_DAEMON) && !( defined(USE_MYSQL) || \
-	defined(WITH_POSTGRESQL73) || defined(WITH_POSTGRESQL74) )
+	defined(WITH_POSTGRESQL) )
 	@${ECHO_CMD} "You need MySQL or Postgres for Daemon mode, because multithreading support is needed"
 	@${FALSE}
 .endif
@@ -588,7 +559,7 @@ post-install:
 	@${INSTALL_DATA} ${FILESDIR}/2x_to_3x_db.sql ${EXAMPLESDIR}/mysql
 	@${INSTALL_DATA} ${FILESDIR}/310_to_320.my.sql ${EXAMPLESDIR}/mysql
 .endif
-.if defined(WITH_POSTGRESQL73) || defined(WITH_POSTGRESQL74)
+.if defined(WITH_POSTGRESQL)
 	@${MKDIR} ${EXAMPLESDIR}/pgsql
 	@cd  ${WRKSRC}/src/tools.pgsql_drv && \
 		${INSTALL_DATA} README *.sql ${EXAMPLESDIR}/pgsql