summaryrefslogtreecommitdiff
path: root/databases/postgresql7/files
diff options
context:
space:
mode:
authorSean Chittenden <seanc@FreeBSD.org>2003-12-25 10:55:39 +0000
committerSean Chittenden <seanc@FreeBSD.org>2003-12-25 10:55:39 +0000
commitb919b91069c1ba6836d4dff773524b7963f1a185 (patch)
treec3614d15270727cb0aef796ce215da3bc577d25e /databases/postgresql7/files
parent- Update to 0.35 (diff)
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
Notes
Notes: svn path=/head/; revision=96563
Diffstat (limited to 'databases/postgresql7/files')
-rw-r--r--databases/postgresql7/files/pkg-message.server16
-rw-r--r--databases/postgresql7/files/post-install-notes3
2 files changed, 17 insertions, 2 deletions
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.