1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
.TH postmaster.conf 5 "20 Sep 1999" Debian "PostgreSQL configuration"
.SH Description
.B /etc/postmaster.conf
is used in Debian GNU/Linux for the configurable initialisation of the
postgresql package.
.PP
.B /etc/postmaster.conf
is read by
.BR postgresql-startup ,
which in turn is called by
.BR /etc/init.d/postgresql .
.SH Configurable parameters
These are the parameters which are defined in
.BR /etc/postmaster.conf :
.TP
POSTGRES_HOME
This is the postgres home directory. Its value is taken from
.IR /etc/passwd ,
but if no entry for
.B postgres
can be found there, it is set to
.IR /var/lib/postgres .
.TP
POSTGRES_DATA
Where to find the PostgreSQL database files, including those that
define PostgresSQL users and permissions.
The default for this is
.IR /var/lib/postgres/data .
.TP
POSTGRES_LOG
Where to send logging and debugging traces; the default is
.IR /var/log/postgresql/postgres.log .
.TP
PGECHO
Whether to echo queries to the debug log: this can be either yes or no.
The default value is
.BR no .
.TP
PGDATESTYLE
This variable is used to tell PostgreSQL how to present dates to the frontend;
each user can override this setting for his own session. The choices are:
.TS
center ;
l c l
l l l.
\fBStyle Date Datetime\fP
ISO 1999-07-17 1999-07-17 07:09:18+01
SQL 17/07/1999 17/07/1999 07:09:19.00 BST
POSTGRES 17-07-1999 Sat 17 Jul 07:09:19 1999 BST
GERMAN 17.07.1999 17.07.1999 07:09:19.00 BST
.TE
The default datestyle is set when the postgresql package is installed.
In addition, "European" or "nonEuropean" can be added (separated by a comma)
to indicate whether dates are expected to have day before month, or month
before day.
.TP
PGSTATS
This is a flag to say whether to print timing and other statistics after
each query: its value can be either yes or no. The default is
.BR no .
.TP
KERNEL_FILE_MAX
The minimum number of entries in the kernel file table. If the table size is
lower, postgresql.startup attempts to increase it by writing this parameter
into
.IR /proc/sys/kernel/file-max .
The default value is
.BR 1032 .
.SH Author
This manual page was written by Oliver Elphick <olly@lfix.co.uk> for the
postgresql package in the Debian project.
|
