summaryrefslogtreecommitdiffstats
path: root/postgresqlrc.5
blob: b0e52a5ee2f7a48f3fc1ba21a9f389e0078f6440 (plain)
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
.TH POSTGRESQLRC 5 "Feburary 2005" "Debian" "Debian PostgreSQL infrastructure"

.SH NAME
~/.postgresqlrc \- Per\-user PostgreSQL cluster configuration

.SH DESCRIPTION
The file
.B ~/.postgresqlrc
configures the default PostgreSQL version/cluster and the default
database for an user. If it is not present, the system\-wide file
.B /etc/postgresql\-common/user_clusters
is used instead.

.SH FORMAT
.P
Comments are introduced by the character
.BR # .
Comments may follow data on a line; the first comment character terminates
the data.
Leading whitespace and blank lines are ignored.

The first uncommented, non\-blank line is used, all following lines are ignored.

Fields must be given in the following order, separated by white space:

.TP
.B VERSION
The major PostgreSQL version of the cluster to connect to.
.TP
.B CLUSTER
The name of a cluster to connect to. A remote cluster is specified
with \fIhost\fR:\fIport\fR. If port is empty, it defaults to 5432.
.TP
.B DATABASE
Within the cluster, the database to which the user will connect by default
if he does not specify a database on the command line.  If this is
.BR * ,
the default database will be the one named by the user's login id.

.SH SEE ALSO
.BR pg_wrapper (1),
.BR user_clusters (5)