Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: Help to make a PITR


    I following the tutorial:

    He ask to do the next steps:

    1) Add on the postgresql.conf:
    archive_command = 'cp -i %p /diretorio/%f </dev/null'

    2) Start the postgresql and type the command:
    SELECT pg_start_backup('rotulo');

    3) Stop the incremental backup with the command:
    SELECT pg_stop_backup();

    He really create the files for backup, like this:

    total 65600
    -rw------- 1 postgres wheel 16777216 Dec 27 18:00 000000010000004E000000A9
    -rw------- 1 postgres wheel 16777216 Dec 27 18:00 000000010000004E000000AA
    -rw------- 1 postgres wheel 16777216 Dec 27 18:02 000000010000004E000000AB
    -rw------- 1 postgres wheel 16777216 Dec 27 18:11 000000010000004E000000AC
    But, after all of this, i dont understand how can i restore the backup from those files, anybody can help me?

  2. #2
    Join Date
    Aug 2005


    please read the documentation carefully, especially the section 22.3.2. Making a Base Backup and 22.3.3. Recovering with an On-line Backup.

    You have to realize that you first need a online backup, to be able to make a point in time recovery. for a successful pitr, you need a online backup (or base backup) and all the archived wal's (or pg_xlogs) to the last possible point; this also includes the very last incomplete wal-file in $pgdata/pg_xlog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts