1[
2{ type: install
3  message: <<EOM
4For procedural languages and postgresql functions, please note that
5you might have to update them when updating the server.
6
7If you have many tables and many clients running, consider raising
8kern.maxfiles using sysctl(8), or reconfigure your kernel
9appropriately.
10
11The port is set up to use autovacuum for new databases, but you might
12also want to vacuum and perhaps backup your database regularly. There
13is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that
14you may find useful. You can use it to backup and perform vacuum on all
15databases nightly. Per default, it performs `vacuum analyze'. See the
16script for instructions. For autovacuum settings, please review
17~%%PG_USER%%/data/postgresql.conf.
18
19If you plan to access your PostgreSQL server using ODBC, please
20consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql
21to get the functions required for ODBC compliance.
22
23Please note that if you use the rc script,
24%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode
25(UTF-8) will be used to store character data by default.  Set
26postgresql_initdb_flags or use login.conf settings described below to
27alter this behaviour. See the start rc script for more info.
28
29To set limits, environment stuff like locale and collation and other
30things, you can set up a class in /etc/login.conf before initializing
31the database. Add something similar to this to /etc/login.conf:
32---
33%%PG_USER%%:\
34	:lang=en_US.UTF-8:\
35	:setenv=LC_COLLATE=C:\
36	:tc=default:
37---
38and run `cap_mkdb /etc/login.conf'.
39Then add 'postgresql_login_class="%%PG_USER%%"' to /etc/rc.conf, or
40set it as the %%PG_USER%% user's login class in /etc/passwd.
41
42======================================================================
43
44To use PostgreSQL, enable it in rc.conf using
45
46  sysrc postgresql_enable=yes
47
48To initialize the database, run
49
50  service postgresql initdb
51
52You can then start PostgreSQL by running:
53
54  service postgresql start
55
56For postmaster settings, see ~%%PG_USER%%/data/postgresql.conf
57
58NB. FreeBSD's PostgreSQL port logs to syslog by default
59    See ~%%PG_USER%%/data/postgresql.conf for more info
60
61NB. If you're not using a checksumming filesystem like ZFS, you might
62    wish to enable data checksumming. It can be enabled during
63    the initdb phase, by adding the "--data-checksums" flag to
64    the postgresql_initdb_flags rcvar. Otherwise you can enable it later by
65    pg_checksums.  Check the initdb(1) manpage for more info
66    and make sure you understand the performance implications.
67
68======================================================================
69EOM
70}
71]
72