diff options
Diffstat (limited to 'databases/postgresql13-server/files/pkg-message-server.in')
| -rw-r--r-- | databases/postgresql13-server/files/pkg-message-server.in | 71 |
1 files changed, 0 insertions, 71 deletions
diff --git a/databases/postgresql13-server/files/pkg-message-server.in b/databases/postgresql13-server/files/pkg-message-server.in deleted file mode 100644 index 6370d4a017cc..000000000000 --- a/databases/postgresql13-server/files/pkg-message-server.in +++ /dev/null @@ -1,71 +0,0 @@ -[ -{ type: install - message: <<EOM -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. - -The port is set up to use autovacuum for new databases, but you might -also want to vacuum and perhaps backup your database regularly. There -is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perform vacuum on all -databases nightly. Per default, it performs `vacuum analyze'. See the -script for instructions. For autovacuum settings, please review -~%%PG_USER%%/data/postgresql.conf. - -If you plan to access your PostgreSQL server using ODBC, please -consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql -to get the functions required for ODBC compliance. - -Please note that if you use the rc script, -%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode -(UTF-8) will be used to store character data by default. Set -postgresql_initdb_flags or use login.conf settings described below to -alter this behaviour. See the start rc script for more info. - -To set limits, environment stuff like locale and collation and other -things, you can set up a class in /etc/login.conf before initializing -the database. Add something similar to this to /etc/login.conf: ---- -%%PG_USER%%:\ - :lang=en_US.UTF-8:\ - :setenv=LC_COLLATE=C:\ - :tc=default: ---- -and run `cap_mkdb /etc/login.conf'. -Then add 'postgresql_login_class="%%PG_USER%%"' to /etc/rc.conf, or -set it as the %%PG_USER%% user's login class in /etc/passwd. - -====================================================================== - -To use PostgreSQL, enable it in rc.conf using - - sysrc postgresql_enable=yes - -To initialize the database, run - - service postgresql initdb - -You can then start PostgreSQL by running: - - service postgresql start - -For postmaster settings, see ~%%PG_USER%%/data/postgresql.conf - -NB. FreeBSD's PostgreSQL port logs to syslog by default - See ~%%PG_USER%%/data/postgresql.conf for more info - -NB. If you're not using a checksumming filesystem like ZFS, you might - wish to enable data checksumming. It can be enabled during - the initdb phase, by adding the "--data-checksums" flag to - the postgresql_initdb_flags rcvar. Otherwise you can enable it later by - pg_checksums. Check the initdb(1) manpage for more info - and make sure you understand the performance implications. - -====================================================================== -EOM -} -] |