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

Commitb4035fd

Browse files
committed
PBCKP-817 Add an example of the restore command
1 parentf8c46ef commitb4035fd

File tree

1 file changed

+23
-2
lines changed

1 file changed

+23
-2
lines changed

‎doc/pgprobackup.xml‎

Lines changed: 23 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -565,7 +565,7 @@ INFO: Wait for WAL segment /mnt/backups/backups/mydb/S6OBFN/database/pg_wal/0000
565565
INFO: PGDATA size: 29MB
566566
INFO: Current Start LSN: 0/2000060, TLI: 1
567567
INFO: Start transferring data files
568-
INFO: Data files are transferred, time elapsed:1s
568+
INFO: Data files are transferred, time elapsed:0
569569
INFO: wait for pg_stop_backup()
570570
INFO: pg_stop backup() successfully executed
571571
INFO: stop_lsn: 0/2003CB0
@@ -689,7 +689,7 @@ INFO: PGDATA size: 29MB
689689
INFO: Current Start LSN: 0/6000028, TLI: 1
690690
INFO: Parent Start LSN: 0/4000028, TLI: 1
691691
INFO: Start transferring data files
692-
INFO: Data files are transferred, time elapsed:1s
692+
INFO: Data files are transferred, time elapsed:0
693693
INFO: wait for pg_stop_backup()
694694
INFO: pg_stop backup() successfully executed
695695
INFO: stop_lsn: 0/6000168
@@ -714,6 +714,27 @@ backup_user@backup_host:~$ pg_probackup-16 show -B /mnt/backups --instance=mydb
714714
mydb 16 S6OBFN 2024-01-03 06:59:49+00 FULL STREAM 1/0 10s 29MB 16MB 1.00 0/2000060 0/2003CB0 OK
715715
</programlisting>
716716
</step>
717+
<stepid="pbk-quickstart-restore">
718+
<para>Restore the data from the latest available backup to an arbitrary location:</para>
719+
<programlisting>
720+
backup_user@backup_host:~$ pg_probackup-16 restore -B /mnt/backups -D /var/lib/postgresql/16/staging --instance=mydb
721+
INFO: Validating parents for backup S6OBQO
722+
INFO: Validating backup S6OBFN
723+
INFO: Backup S6OBFN data files are valid
724+
INFO: Validating backup S6OBLG
725+
INFO: Backup S6OBLG data files are valid
726+
INFO: Validating backup S6OBQO
727+
INFO: Backup S6OBQO data files are valid
728+
INFO: Backup S6OBQO WAL segments are valid
729+
INFO: Backup S6OBQO is valid.
730+
INFO: Restoring the database from backup at 2024-01-03 07:06:24+00
731+
INFO: Start restoring backup files. PGDATA size: 61MB
732+
INFO: Backup files are restored. Transfered bytes: 61MB, time elapsed: 1s
733+
INFO: Restore incremental ratio (less is better): 100% (61MB/61MB)
734+
INFO: Syncing restored files to disk
735+
INFO: Restored backup files are synced, time elapsed: 0
736+
INFO: Restore of backup S6OBQO completed.
737+
</step>
717738
</procedure>
718739
</refsect2>
719740
</refsect1>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp