Maintainer update to PostgreSQL 7.4.1. This release includes fixed ident

authentication support for FreeBSD (been broken since 7.4).  Merry
Christmas to all, and to all a good night.

Release notes:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-4-1

Prompted by PR:	ports/60542
Obtained from:	maintainer

55 files changed, 363 insertions, 165 deletions

diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql-devel-server/Makefile
+++ b/databases/postgresql-devel-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql-devel-server/distinfo b/databases/postgresql-devel-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql-devel-server/distinfo
+++ b/databases/postgresql-devel-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql-devel-server/files/pkg-message.server b/databases/postgresql-devel-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql-devel-server/files/pkg-message.server
+++ b/databases/postgresql-devel-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql-devel-server/files/post-install-notes b/databases/postgresql-devel-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql-devel-server/files/post-install-notes
+++ b/databases/postgresql-devel-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql-devel-server/pkg-plist b/databases/postgresql-devel-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql-devel-server/pkg-plist
+++ b/databases/postgresql-devel-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql7/Makefile
+++ b/databases/postgresql7/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql7/distinfo b/databases/postgresql7/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql7/distinfo
+++ b/databases/postgresql7/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql7/files/pkg-message.server b/databases/postgresql7/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql7/files/pkg-message.server
+++ b/databases/postgresql7/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql7/files/post-install-notes b/databases/postgresql7/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql7/files/post-install-notes
+++ b/databases/postgresql7/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql7/pkg-plist b/databases/postgresql7/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql7/pkg-plist
+++ b/databases/postgresql7/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql74-server/distinfo
+++ b/databases/postgresql74-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql74-server/files/pkg-message.server b/databases/postgresql74-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql74-server/files/pkg-message.server
+++ b/databases/postgresql74-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql74-server/files/post-install-notes b/databases/postgresql74-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql74-server/files/post-install-notes
+++ b/databases/postgresql74-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql74-server/pkg-plist b/databases/postgresql74-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql74-server/pkg-plist
+++ b/databases/postgresql74-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql80-server/files/pkg-message.server b/databases/postgresql80-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql80-server/files/pkg-message.server
+++ b/databases/postgresql80-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql80-server/files/post-install-notes b/databases/postgresql80-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql80-server/files/post-install-notes
+++ b/databases/postgresql80-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql80-server/pkg-plist b/databases/postgresql80-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql80-server/pkg-plist
+++ b/databases/postgresql80-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql81-server/distinfo
+++ b/databases/postgresql81-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql81-server/files/pkg-message.server b/databases/postgresql81-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql81-server/files/pkg-message.server
+++ b/databases/postgresql81-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql81-server/files/post-install-notes b/databases/postgresql81-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql81-server/files/post-install-notes
+++ b/databases/postgresql81-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql81-server/pkg-plist b/databases/postgresql81-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql81-server/pkg-plist
+++ b/databases/postgresql81-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql82-server/Makefile
+++ b/databases/postgresql82-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql82-server/distinfo
+++ b/databases/postgresql82-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql82-server/files/pkg-message.server b/databases/postgresql82-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql82-server/files/pkg-message.server
+++ b/databases/postgresql82-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql82-server/files/post-install-notes b/databases/postgresql82-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql82-server/files/post-install-notes
+++ b/databases/postgresql82-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql82-server/pkg-plist b/databases/postgresql82-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql82-server/pkg-plist
+++ b/databases/postgresql82-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql83-server/files/pkg-message.server b/databases/postgresql83-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql83-server/files/pkg-message.server
+++ b/databases/postgresql83-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql83-server/files/post-install-notes b/databases/postgresql83-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql83-server/files/post-install-notes
+++ b/databases/postgresql83-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql83-server/pkg-plist b/databases/postgresql83-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql83-server/pkg-plist
+++ b/databases/postgresql83-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql84-server/files/pkg-message.server b/databases/postgresql84-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql84-server/files/pkg-message.server
+++ b/databases/postgresql84-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql84-server/files/post-install-notes b/databases/postgresql84-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql84-server/files/post-install-notes
+++ b/databases/postgresql84-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql84-server/pkg-plist b/databases/postgresql84-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql84-server/pkg-plist
+++ b/databases/postgresql84-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql90-server/files/pkg-message.server b/databases/postgresql90-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql90-server/files/pkg-message.server
+++ b/databases/postgresql90-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql90-server/files/post-install-notes b/databases/postgresql90-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql90-server/files/post-install-notes
+++ b/databases/postgresql90-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql90-server/pkg-plist b/databases/postgresql90-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql90-server/pkg-plist
+++ b/databases/postgresql90-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql91-server/distinfo
+++ b/databases/postgresql91-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql91-server/files/pkg-message.server b/databases/postgresql91-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql91-server/files/pkg-message.server
+++ b/databases/postgresql91-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql91-server/files/post-install-notes b/databases/postgresql91-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql91-server/files/post-install-notes
+++ b/databases/postgresql91-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql91-server/pkg-plist b/databases/postgresql91-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql91-server/pkg-plist
+++ b/databases/postgresql91-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index 4f17a17f902b..57567212b81e 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4
+PORTVERSION?=	7.4.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -73,12 +73,12 @@ CONFIGURE_ARGS+=	"--with-openssl=${OPENSSLBASE}"
 .if defined(WITHOUT_SERVER)
 PLIST_SUB+=	SERVER="@comment "
 PKGNAMESUFFIX=	-client
-PKGMSG=		""
+PKGMSG=		/dev/null
 CONFLICTS=	postgresql-7* postgresql-devel-*
 .else
 PKGMESSAGE=	${FILESDIR}/pkg-message.server
 PKGMSG=		${PKGMESSAGE}
-CONFLICTS=	postgresql-7*client postgreql-devel-*
+CONFLICTS=	postgresql-client-7* postgresql-devel-*
 PLIST_SUB+=	SERVER=""
 INSTALL_TARGET+=	install-all-headers
 MAKEFILE=	GNUmakefile
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index f36c65ae2d5e..56dcb82c77c6 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
-MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
-MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
-MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8
+MD5 (postgresql/postgresql-base-7.4.1.tar.bz2) = 6a608caae10fb1d90bf3c7bdcc56b876
+MD5 (postgresql/postgresql-opt-7.4.1.tar.bz2) = 5c2c63741d9c7a4168b29e4b4439b0c7
+MD5 (postgresql/postgresql-test-7.4.1.tar.bz2) = 23ddb087901fcf7bc3cf8dfa06ff45ed
+MD5 (postgresql/postgresql-docs-7.4.1.tar.bz2) = c1ed614b482df37fa0b174b3f3839752
diff --git a/databases/postgresql92-server/files/pkg-message.server b/databases/postgresql92-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql92-server/files/pkg-message.server
+++ b/databases/postgresql92-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)
diff --git a/databases/postgresql92-server/files/post-install-notes b/databases/postgresql92-server/files/post-install-notes
index 037eec446deb..0fb0604214b8 100644
--- a/databases/postgresql92-server/files/post-install-notes
+++ b/databases/postgresql92-server/files/post-install-notes
@@ -7,8 +7,7 @@ p5-Pg
   A perl5 API for client access to PostgreSQL databases.
 
 postgresql-tcltk 
-  If you want tcl/tk client support. You get a neat GUI, pgaccess, as
-  a bonus!
+  If you want tcl/tk client support.
 
 postgresql-jdbc
   For Java JDBC support.
diff --git a/databases/postgresql92-server/pkg-plist b/databases/postgresql92-server/pkg-plist
index 6c4ba1c3568b..2b172fd5e78c 100644
--- a/databases/postgresql92-server/pkg-plist
+++ b/databases/postgresql92-server/pkg-plist
@@ -28,20 +28,25 @@ include/postgresql/internal/libpq/pqcomm.h
 @dirrm include/postgresql/internal/libpq
 include/postgresql/internal/lib/dllist.h
 @dirrm include/postgresql/internal/lib
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
 include/postgresql/internal/c.h
 include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
-include/compatlib.h
-include/datetime.h
-include/decimal.h
 include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
+include/pg_config_manual.h
 include/pg_config_os.h
 include/pgtypes_date.h
 include/pgtypes_error.h
@@ -51,8 +56,6 @@ include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
-include/sqlda.h
-include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
 lib/libecpg.so.4
@@ -98,11 +101,11 @@ lib/libpgtypes.so.1
 %%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
-%%SERVER%%share/postgresql/pg_service.conf.sample
 %%SERVER%%share/postgresql/postgres.bki
 %%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
 %%SERVER%%share/postgresql/sql_features.txt
+share/postgresql/pg_service.conf.sample
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo