From 40a3261d1a6e2617f6afde0cd6d762a7e211af7a Mon Sep 17 00:00:00 2001 From: cvs2svn Date: Sun, 16 Oct 2005 07:41:55 +0000 Subject: This commit was manufactured by cvs2svn to create tag 'RELEASE_6_0_0'. --- databases/postgresql82-server/pkg-message-server | 49 ------------------------ 1 file changed, 49 deletions(-) delete mode 100644 databases/postgresql82-server/pkg-message-server (limited to 'databases/postgresql82-server/pkg-message-server') 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 - -- cgit v1.2.3