diff options
Diffstat (limited to 'databases/postgresql90-server/pkg-message-server')
| -rw-r--r-- | databases/postgresql90-server/pkg-message-server | 49 |
1 files changed, 0 insertions, 49 deletions
diff --git a/databases/postgresql90-server/pkg-message-server b/databases/postgresql90-server/pkg-message-server deleted file mode 100644 index ad1e6d1e82b9..000000000000 --- a/databases/postgresql90-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 - |