| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Brian Wipf <brian(at)clickspace(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Base Backups from PITR Standby |
| Date: | 2007-11-02 17:49:42 |
| Message-ID: | 86513861-CA4F-4ACA-8A69-F3DEED9DD667@myemma.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Oct 30, 2007, at 3:42 PM, Simon Riggs wrote:
> On Tue, 2007-10-30 at 08:25 -0600, Brian Wipf wrote:
>
>> I'm trying to take a base backup from the standby server in archive
>> recovery mode. I don't believe it's possible to connect to it to
>> issue
>> pg_start_backup/pg_stop_backup.
>>
>> http://www.postgresql.org/docs/current/interactive/warm-
>> standby.html#BACKUP-INCREMENTAL-UPDATED
>
> It's safest to shutdown the standby first, take a backup then crank it
> up again.
Yeah, I was doing this in a completely wrong way at first and have
since found that doing just stopping the standby and making the
backup is easiest.
Erik Jones
Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Muhlestein | 2007-11-02 18:02:46 | Cybercluster |
| Previous Message | andy | 2007-11-02 17:26:03 | Re: Populating large DB from Perl script |