Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitb9d8ea2

Browse files
committed
Some further editorial adjustment of PITR recovery procedure description.
1 parent4a6fd46 commitb9d8ea2

File tree

1 file changed

+25
-17
lines changed

1 file changed

+25
-17
lines changed

‎doc/src/sgml/backup.sgml

Lines changed: 25 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.51 2004/11/15 06:32:13 neilc Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.52 2004/11/17 18:29:02 tgl Exp $
33
-->
44
<chapter id="backup">
55
<title>Backup and Restore</title>
@@ -615,8 +615,10 @@ archive_command = 'test ! -f .../%f &amp;&amp; cp %p .../%f'
615615
Note that although WAL archiving will allow you to restore any
616616
modifications made to the data in your <productname>PostgreSQL</> database
617617
it will not restore changes made to configuration files (that is,
618-
<filename>postgresql.conf</>, <filename>pg_hba.conf</> and
618+
<filename>postgresql.conf</>, <filename>pg_hba.conf</> and
619619
<filename>pg_ident.conf</>) after the initial base backup.
620+
You may wish to keep the configuration files in a location that will
621+
be backed up by your regular filesystem backup procedures.
620622
</para>
621623
</sect2>
622624

@@ -638,11 +640,11 @@ archive_command = 'test ! -f .../%f &amp;&amp; cp %p .../%f'
638640
SELECT pg_start_backup('label');
639641
</programlisting>
640642
where <literal>label</> is any string you want to use to uniquely
641-
identify this backup operation.<function>pg_start_backup</> creates
642-
a <firstterm>backup label</> file, called <filename>backup_label</>,
643-
in the cluster directory with information about yourbackup.
644-
One good practice is to usethefull path where you intend to put the
645-
backup dump file as.
643+
identify this backup operation. (One good practice is to use the
644+
full path where you intend to put the backup dump file.)
645+
<function>pg_start_backup</> creates a <firstterm>backup label</> file,
646+
called <filename>backup_label</>, inthecluster directory with
647+
information about your backup.
646648
</para>
647649

648650
<para>
@@ -762,19 +764,25 @@ SELECT pg_stop_backup();
762764
<orderedlist>
763765
<listitem>
764766
<para>
765-
Stop the postmaster, if it's running. If you have the space to do so,
766-
copy the cluster data directory and any tablespaces to a temporary
767-
location so that you can reference them later. Note that this will
767+
Stop the postmaster, if it's running.
768+
</para>
769+
</listitem>
770+
<listitem>
771+
<para>
772+
If you have the space to do so,
773+
copy the whole cluster data directory and any tablespaces to a temporary
774+
location in case you need them later. Note that this precaution will
768775
require that you have enough free space on your system to hold two
769776
copies of your existing database. If you do not have enough space,
770-
you need at the least tobackup the <filename>pg_xlog</> directory in
771-
the cluster data directory as it may contain logs which were not archived
772-
before the system went down.
777+
you need at the least tocopy thecontents of the<filename>pg_xlog</>
778+
subdirectory ofthe cluster data directory, as it may contain logs which
779+
were not archivedbefore the system went down.
773780
</para>
774-
781+
</listitem>
782+
<listitem>
775783
<para>
776-
Next, cleanout all existing files under the cluster data directory and
777-
under the root directories of any tablespaces you are using.
784+
Cleanout all existing filesand subdirectoriesunder the cluster data
785+
directory andunder the root directories of any tablespaces you are using.
778786
</para>
779787
</listitem>
780788
<listitem>
@@ -797,7 +805,7 @@ SELECT pg_stop_backup();
797805
</listitem>
798806
<listitem>
799807
<para>
800-
If you had unarchived WAL segment files that you saved in step1,
808+
If you had unarchived WAL segment files that you saved in step2,
801809
copy them into <filename>pg_xlog/</>. (It is best to copy them,
802810
not move them, so that you still have the unmodified files if a
803811
problem occurs and you have to start over.)

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp