diff options
Diffstat (limited to 'databases/postgresql91-server/pkg-message-server')
| -rw-r--r-- | databases/postgresql91-server/pkg-message-server | 30 |
1 files changed, 4 insertions, 26 deletions
diff --git a/databases/postgresql91-server/pkg-message-server b/databases/postgresql91-server/pkg-message-server index 7957a3814c58..56e7442a2f42 100644 --- a/databases/postgresql91-server/pkg-message-server +++ b/databases/postgresql91-server/pkg-message-server @@ -1,36 +1,14 @@ - -Specific for updating 7.4.1->7.4.x: - - A dump/restore is *not* required for those running 7.4, BUT: - - If you want to install the fixes in the information schema you will - 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) - -===================================================================== - For procedural languages and postgresql functions, please note that -you might have to update them when updating the server. For example, -the "elog" method disappeared in postgresql-7.4, so postgresql-contrib -must be updated along with the server. +you might have to update them when updating the server. If you have many tables and many clients running, consider raising kern.maxfiles using sysctl(8), or reconfigure your kernel appropriately. You should vacuum and backup your database regularly. There is a -periodic script, /usr/local/etc/periodic/daily/502.pgsql, that you may -find useful. See the script for instructions. +periodic script, ${LOCALBASE}/etc/periodic/daily/502.pgsql, that you +may find useful. Per default, it perfoms vacuum on all databases +nightly. See the script for instructions. To allow many simultaneous connections to your PostgreSQL server, you should raise the SystemV shared memory limits in your kernel. Here are |