diff options
author | Palle Girgensohn <girgen@FreeBSD.org> | 2006-12-06 16:50:34 +0000 |
---|---|---|
committer | Palle Girgensohn <girgen@FreeBSD.org> | 2006-12-06 16:50:34 +0000 |
commit | 5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639 (patch) | |
tree | 749e476703326e12f11da8801bcad38fd8919838 /databases/postgresql82-server/pkg-message-server | |
parent | More rubust regex to determine which version of postgresql that is (diff) |
Welcome new release of the world's most advanced open source database:
PostgreSQL 8.2.0
Complete release notes are available at
http://www.postgresql.org/docs/current/static/release-8-2.html
Notes
Notes:
svn path=/head/; revision=179046
Diffstat (limited to 'databases/postgresql82-server/pkg-message-server')
-rw-r--r-- | databases/postgresql82-server/pkg-message-server | 49 |
1 files changed, 0 insertions, 49 deletions
diff --git a/databases/postgresql82-server/pkg-message-server b/databases/postgresql82-server/pkg-message-server deleted file mode 100644 index ad1e6d1e82b9..000000000000 --- a/databases/postgresql82-server/pkg-message-server +++ /dev/null @@ -1,49 +0,0 @@ -For procedural languages and postgresql functions, please note that -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, ${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 -example values for allowing up to 180 clients (configurations in -postgresql.conf also needed, of course): - options SYSVSHM - options SYSVSEM - options SYSVMSG - options SHMMAXPGS=65536 - options SEMMNI=40 - options SEMMNS=240 - options SEMUME=40 - options SEMMNU=120 - -If you plan to access your PostgreSQL server using ODBC, please -consider running the SQL script /usr/local/share/postgresql/odbc.sql -to get the functions required for ODBC compliance. - -====================================================================== - -To initialize the database, run - - /usr/local/etc/rc.d/010.pgsql.sh initdb - -You can then start PostgreSQL by running: - - /usr/local/etc/rc.d/010.pgsql.sh start - -For postmaster settings, see ~pgsql/data/postgresql.conf - -NB. FreeBSD's PostgreSQL port now by default logs to syslog - See ~pgsql/data/postgresql.conf for more info - -====================================================================== - -To run PostgreSQL at startup, add -'postgresql_enable="YES"' to /etc/rc.conf - |