diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 17 |
2 files changed, 18 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 450383083d7..a10ae0c6227 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -143,7 +143,8 @@ PostgreSQL documentation <para> Output commands to clean (drop) database objects prior to outputting the commands for creating them. - (Restore might generate some harmless errors.) + (Restore might generate some harmless error messages, if any objects + were not present in the destination database.) </para> <para> @@ -161,8 +162,10 @@ PostgreSQL documentation <para> Begin the output with a command to create the database itself and reconnect to the created database. (With a - script of this form, it doesn't matter which database you connect - to before running the script.) + script of this form, it doesn't matter which database in the + destination installation you connect to before running the script.) + If <option>--clean</option> is also specified, the script drops and + recreates the target database before reconnecting to it. </para> <para> diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index b276da6afe6..d4f61669b88 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -109,6 +109,8 @@ <listitem> <para> Clean (drop) database objects before recreating them. + (This might generate some harmless error messages, if any objects + were not present in the destination database.) </para> </listitem> </varlistentry> @@ -118,11 +120,16 @@ <term><option>--create</option></term> <listitem> <para> - Create the database before restoring into it. (When this - option is used, the database named with <option>-d</option> is - used only to issue the initial <command>CREATE DATABASE</> - command. All data is restored into the database name that - appears in the archive.) + Create the database before restoring into it. + If <option>--clean</option> is also specified, drop and + recreate the target database before connecting to it. + </para> + + <para> + When this option is used, the database named with <option>-d</option> + is used only to issue the initial <command>DROP DATABASE</> and + <command>CREATE DATABASE</> commands. All data is restored into the + database name that appears in the archive. </para> </listitem> </varlistentry> |