diff options
Diffstat (limited to 'databases/postgresql74-server/files')
| -rw-r--r-- | databases/postgresql74-server/files/pkg-message.server | 16 | ||||
| -rw-r--r-- | databases/postgresql74-server/files/post-install-notes | 3 |
2 files changed, 17 insertions, 2 deletions
diff --git a/databases/postgresql74-server/files/pkg-message.server b/databases/postgresql74-server/files/pkg-message.server index a2e7293..6982668 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 037eec4..0fb0604 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. |
