Re: PITR Recovery Question

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: "'Samuel Stearns'" <SStearns(at)internode(dot)com(dot)au>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PITR Recovery Question
Date: 2010-06-08 05:29:17
Message-ID: 000201cb06cb$8b068860$a1139920$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Hi Sam,

Thank your sharing this script.

> Here's a script to make your backup and rsync it to a remote destination:

> #!/bin/bash
> echo "checkpoint"
> echo "CHECKPOINT;" | /local/pkg/bin/psql template1
> echo "start backup"
> echo "SELECT pg_start_backup('cisoradr:/cis/pgsql/katana7/backup');" |
/local/pkg/bin/psql template1
> echo "rsync"
> /local/pkg/bin/rsync --delete -azxH /local/app/postgres/data
pgsql(at)cisoradr-ext:/cis/pgsql/katana7/backup/.
> echo "Stop backup"
> echo "SELECT pg_stop_backup();" | /local/pkg/bin/psql template1

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fernando Machado 2010-06-08 12:14:44 Convite para se conectar no LinkedIn
Previous Message Gnanakumar 2010-06-08 05:29:09 Re: PITR Recovery Question

Browse pgsql-hackers by date

  From Date Subject
Next Message Koichi Suzuki 2010-06-08 06:06:33 How to generate specific WAL records again for PostgreSQL 9.0?
Previous Message Gnanakumar 2010-06-08 05:29:09 Re: PITR Recovery Question