|
1 |
| -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v 2.19 2001/11/18 22:17:30 tgl Exp $ --> |
| 1 | +<!-- |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v 2.20 2001/11/18 22:27:00 tgl Exp $ |
| 3 | +--> |
2 | 4 | <chapter id="backup">
|
3 | 5 | <title>Backup and Restore</title>
|
4 | 6 |
|
@@ -81,10 +83,12 @@ pg_dump <replaceable class="parameter">dbname</replaceable> > <replaceable cl
|
81 | 83 |
|
82 | 84 | <important>
|
83 | 85 | <para>
|
84 |
| - When your database schema relies on OIDs (for instances as foreign |
| 86 | + When your database schema relies on OIDs (for instance as foreign |
85 | 87 | keys) you must instruct <application>pg_dump</> to dump the OIDs
|
86 | 88 | as well. To do this, use the <option>-o</option> command line
|
87 |
| - option. |
| 89 | + option. <quote>Large objects</> are not dumped by default, either. |
| 90 | + See <application>pg_dump</>'s command reference page if you use |
| 91 | + large objects. |
88 | 92 | </para>
|
89 | 93 | </important>
|
90 | 94 |
|
@@ -115,16 +119,16 @@ psql <replaceable class="parameter">dbname</replaceable> < <replaceable class
|
115 | 119 | users, then the dump will instruct <application>psql</> to connect
|
116 | 120 | as each affected user in turn and then create the relevant
|
117 | 121 | objects. This way the original ownership is preserved. This also
|
118 |
| - means, however, that all these user must already exist, and |
| 122 | + means, however, that all these users must already exist, and |
119 | 123 | furthermore that you must be allowed to connect as each of them.
|
120 | 124 | It might therefore be necessary to temporarily relax the client
|
121 | 125 | authentication settings.
|
122 | 126 | </para>
|
123 | 127 |
|
124 | 128 | <para>
|
125 | 129 | The ability of <application>pg_dump</> and <application>psql</> to
|
126 |
| - write or read from pipes also make it possible to dump a database |
127 |
| - directory from one server to another, for example |
| 130 | + write to or read from pipes makes it possible to dump a database |
| 131 | + directly from one server to another, for example |
128 | 132 | <informalexample>
|
129 | 133 | <programlisting>
|
130 | 134 | pg_dump -h <replaceable>host1</> <replaceable>dbname</> | psql -h <replaceable>host2</> <replaceable>dbname</>
|
|
0 commit comments