diff options
author | Palle Girgensohn <girgen@FreeBSD.org> | 2021-05-20 10:53:00 +0200 |
---|---|---|
committer | Palle Girgensohn <girgen@FreeBSD.org> | 2021-05-20 16:38:55 +0200 |
commit | fccc45e5ff4a8aea150005196c0d4f2cbaeed5db (patch) | |
tree | b308d056494290f6e3b9e2bfa8e6750ec82183e6 /databases/postgresql14-server/files/pkg-message-server.in | |
parent | databases/postgresql1[123]-server: remove trailing space in pkg-plist (diff) |
databases/postgresql14-*: Add postgresql 14 beta1 the the ports tree.
Release notes: https://www.postgresql.org/docs/devel/release-14.html
Also reintroduce parallel builds. Some components, namely plperl,
plpython, pltcl and contrib, fail to build properly when using parallel
builds. Something with static linking using `ar` that fails.
MAKE_JOBS_UNSAFE is set for these ports.
Diffstat (limited to 'databases/postgresql14-server/files/pkg-message-server.in')
-rw-r--r-- | databases/postgresql14-server/files/pkg-message-server.in | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/databases/postgresql14-server/files/pkg-message-server.in b/databases/postgresql14-server/files/pkg-message-server.in new file mode 100644 index 000000000000..9bfbcc7b4a83 --- /dev/null +++ b/databases/postgresql14-server/files/pkg-message-server.in @@ -0,0 +1,69 @@ +[ +{ 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 +~postgres/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: +--- +postgres:\ + :lang=en_US.UTF-8:\ + :setenv=LC_COLLATE=C:\ + :tc=default: +--- +and run `cap_mkdb /etc/login.conf'. +Then add 'postgresql_class="postgres"' to /etc/rc.conf. + +====================================================================== + +To initialize the database, run + + %%PREFIX%%/etc/rc.d/postgresql initdb + +You can then start PostgreSQL by running: + + %%PREFIX%%/etc/rc.d/postgresql start + +For postmaster settings, see ~postgres/data/postgresql.conf + +NB. FreeBSD's PostgreSQL port logs to syslog by default + See ~postgres/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. + +====================================================================== + +To run PostgreSQL at startup, add +'postgresql_enable="YES"' to /etc/rc.conf +EOM +} +] |