diff options
Diffstat (limited to 'databases/postgresql80-server/files/pkg-message-server.in')
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-server.in | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/databases/postgresql80-server/files/pkg-message-server.in b/databases/postgresql80-server/files/pkg-message-server.in index 88c35ccff457..5b8a1afdfda0 100644 --- a/databases/postgresql80-server/files/pkg-message-server.in +++ b/databases/postgresql80-server/files/pkg-message-server.in @@ -27,13 +27,19 @@ 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. -If you need to store any characters besides strict ASCII in your -database, you will want to set a character set, and possibly a -collation locale, before initializing the database. Add something -similar to this to /etc/login.conf: +Please note that if you use the rc script, +%%PREFIX%%/etc/rc.conf/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:\ - :setenv=LC_ALL=en_US.UTF-8,LC_COLLATE=C:\ + :lang=en_US.UTF-8:\ + :setenv=LC_COLLATE=C:\ :tc=default: --- and run `cap_mkdb /etc/login.conf'. @@ -51,7 +57,7 @@ You can then start PostgreSQL by running: For postmaster settings, see ~pgsql/data/postgresql.conf -NB. FreeBSD's PostgreSQL port now by default logs to syslog +NB. FreeBSD's PostgreSQL port logs to syslog by default See ~pgsql/data/postgresql.conf for more info ====================================================================== |