1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>Database Configuration</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="Managing Databases"
16
HREF="managing-databases.html"><LINK
18
TITLE="Template Databases"
19
HREF="manage-ag-templatedbs.html"><LINK
21
TITLE="Destroying a Database"
22
HREF="manage-ag-dropdb.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Template Databases"
57
HREF="manage-ag-templatedbs.html"
66
TITLE="Managing Databases"
67
HREF="managing-databases.html"
74
>Chapter 21. Managing Databases</TD
80
TITLE="Managing Databases"
81
HREF="managing-databases.html"
89
TITLE="Destroying a Database"
90
HREF="manage-ag-dropdb.html"
104
NAME="MANAGE-AG-CONFIG"
105
>21.4. Database Configuration</A
109
HREF="runtime-config.html"
115
> server provides a large number of
116
run-time configuration variables. You can set database-specific
117
default values for many of these settings.
120
> For example, if for some reason you want to disable the
124
> optimizer for a given database, you'd
125
ordinarily have to either disable it for all databases or make sure
126
that every connecting client is careful to issue <TT
130
>. To make this setting the default within a particular
131
database, you can execute the command:
133
CLASS="PROGRAMLISTING"
134
>ALTER DATABASE mydb SET geqo TO off;</PRE
136
This will save the setting (but not set it immediately). In
137
subsequent connections to this database it will appear as though
140
>SET geqo TO off;</TT
141
> had been executed just before the
143
Note that users can still alter this setting during their sessions; it
144
will only be the default. To undo any such setting, use
167
SUMMARY="Footer navigation table"
178
HREF="manage-ag-templatedbs.html"
196
HREF="manage-ag-dropdb.html"
206
>Template Databases</TD
212
HREF="managing-databases.html"
220
>Destroying a Database</TD
b'\\ No newline at end of file'