diff options
Diffstat (limited to 'databases/postgresql14-server/files/pkg-message-server.in')
| -rw-r--r-- | databases/postgresql14-server/files/pkg-message-server.in | 34 |
1 files changed, 24 insertions, 10 deletions
diff --git a/databases/postgresql14-server/files/pkg-message-server.in b/databases/postgresql14-server/files/pkg-message-server.in index 9bfbcc7b4a83..0f60433892bb 100644 --- a/databases/postgresql14-server/files/pkg-message-server.in +++ b/databases/postgresql14-server/files/pkg-message-server.in @@ -14,7 +14,7 @@ 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. +~%%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 @@ -30,40 +30,54 @@ 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:\ +%%PG_USER%%:\ :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. +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 - %%PREFIX%%/etc/rc.d/postgresql initdb + service postgresql initdb You can then start PostgreSQL by running: - %%PREFIX%%/etc/rc.d/postgresql start + service postgresql start -For postmaster settings, see ~postgres/data/postgresql.conf +For postmaster settings, see ~%%PG_USER%%/data/postgresql.conf NB. FreeBSD's PostgreSQL port logs to syslog by default - See ~postgres/data/postgresql.conf for more info + 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 + using 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 +SECURITY ADVICE + +If upgrading from a version 14.x < 14.12: +A security vulnerability was found in the system views pg_stats_ext +and pg_stats_ext_exprs, potentially allowing authenticated database +users to see data they shouldn't. If this is of concern in your +installation, run the SQL script %%DATADIR%%/fix-CVE-2024-4317.sql +for each of your databases. For details, see +https://www.postgresql.org/support/security/CVE-2024-4317/ + + EOM } ] |