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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
.TH postmaster.init 5 "20 Sep 1999" Debian "PostgreSQL configuration"
.SH Description
.B /etc/postmaster.init
is used in Debian GNU/Linux for the configurable initialisation of the
postgresql package.
.PP
.B /etc/postmaster.init
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.init :
.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/postgres.log .
.TP
PGBUFFERS
The number of shared-memory buffers the postmaster is
to allocate for backend server processes. Each buffer is 8Kb.
The default is
.BR 64 .
.TP
PGDEBUG
The debugging level at which the backend servers are to operate.
1: trace connection traffic only; >=2: turn on debugging in the backends
giving more information according to the debug level. Debug logs are
sent to $POSTGRES_LOG
The default value is
.BR 0 ,
which turns off debugging.
.TP
PGECHO
Whether to echo queries to the debug log: this can be either yes or no.
The default value is
.BR no .
.TP
PGFSYNC
This variable tells PostgreSQL whether to disable the fsync() call after
each transaction. (If fsync() is
disabled, performance will improve at the cost of an increased risk of data
corruption in the event of power or other hardware failure.): this can be either yes or no.
The default value is
.BR yes .
.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
NONEURO 07-17-1999 Sat Jul 17 07:09:19 1999 BST
US 07-17-1999 Sat Jul 17 07:09:19 1999 BST
EURO 17-07-1999 Sat 17 Jul 07:09:19 1999 BST
.TE
The default datestyle is set when the postgresql package is installed.
.TP
PGSORTMEM
This variable determines how much memory PostgreSQL should use for internal
sorts before resorting to the disk. This value is in kilobytes, and the
default value is
.BR 512 .
.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
PGALLOWTCPIP
This flag says whether to allow connections through TCP/IP as well as
through Unix sockets: its value can be either yes or no. By default, for
greater security, we do not allow TCP/IP access. This means that only
users on this machine can access the database. The default value is
.BR no .
.TP
PGPORT
This is the Internet TCP port on which postmaster is to listen for connections
from frontend applications. The default is
.BR 5432 ,
which is the value with which PostgreSQL is built.
.TP
LANG
This is the locale setting for the postmaster and backend to use: this is not
necessary for USA users, but most others will probably want to set it; it
controls things like the format of numbers and sort collation.
For example, use `LANG=en_GB' for British English.
By default, this variable is not set.
.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.
|
