pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sabry Sadiq <ssadiq@whispir.com>
To: Lonni J Friedman <netllama@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Backup
Date: Fri, 30 Nov 2012 01:16:08 +0000
Message-ID: <5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net> (raw)
In-Reply-To: <CAP=oouF7Gsxr5P9DuJuXhZNRuN8pUeBJ5+xKgekRTq1R4Ug5dQ@mail.gmail.com>
References: <5641DCFFECC8DC41AE09790420B7B6680DAAD485@TOKYO.whispir.net>
	<CAP=oouGpsd5SbWrgcFa4JbLxhMXa_=uisiPe6NW8VVY-jJO-Rw@mail.gmail.com>
	<5641DCFFECC8DC41AE09790420B7B6680DAAD4E0@TOKYO.whispir.net>
	<CAP=oouEqn97oQvnkt6wHrcHa4E+kdkY6qpYN02rQH56OqTcwQA@mail.gmail.com>
	<5641DCFFECC8DC41AE09790420B7B6680DAAD509@TOKYO.whispir.net>
	<CAP=oouF7Gsxr5P9DuJuXhZNRuN8pUeBJ5+xKgekRTq1R4Ug5dQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Currently backups are performed on the master database and I want to offload that load to the standby



Sabry Sadiq
Systems Administrator

Whispir
Level 30 360 Collins Street
Melbourne / Victoria 3000 / Australia
GPO Box 130 / Victoria 3001 / Australia
T +61 3 8630 9900 / M +61 428 571 636
F +61 3 8630 9990 / E mailto:ssadiq@whispir.com
1300 WHISPIR / 1300 944 774
www.whispir.com


-----Original Message-----
From: Lonni J Friedman [mailto:netllama@gmail.com]
Sent: Friday, 30 November 2012 12:15 PM
To: Sabry Sadiq
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup

I don't know, I've never tried.  If I had to guess, I'd say no, as that version doesn't support cascading replication.

You never stated, how are you currently performing backups?

On Thu, Nov 29, 2012 at 5:13 PM, Sabry Sadiq <ssadiq@whispir.com> wrote:
> Does it work well with version 9.1.3?
>
>
>
> Sabry Sadiq
> Systems Administrator
>
> Whispir
> Level 30 360 Collins Street
> Melbourne / Victoria 3000 / Australia
> GPO Box 130 / Victoria 3001 / Australia T +61 3 8630 9900 / M +61 428
> 571 636 F +61 3 8630 9990 / E mailto:ssadiq@whispir.com
> 1300 WHISPIR / 1300 944 774
> www.whispir.com
>
>
>
>
> This communication contains information which is confidential and the copyright of Whispir or a third party.  If you have received this email in error please notify us by return email or telephone Whispir on 1300 WHISPIR (1300 9447747) or +613 8630 9900 and  delete the document and delete all copies immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of Whispir. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of Whispir. Except as required at law, Whispir does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
>
>
> -----Original Message-----
> From: Lonni J Friedman [mailto:netllama@gmail.com]
> Sent: Friday, 30 November 2012 12:13 PM
> To: Sabry Sadiq
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Backup
>
> There aren't any, assuming that all of the servers are using the same postgresql.conf.  I'm referring to running pg_basebackup.
>
> On Thu, Nov 29, 2012 at 5:11 PM, Sabry Sadiq <ssadiq@whispir.com> wrote:
>> HI Lonni,
>>
>> I am new to postgres.. How do I go about doing it? What are the gotchas?
>>
>> Kind Regards,
>> Sabry
>>
>>
>>
>>
>> Sabry Sadiq
>> Systems Administrator
>> -----Original Message-----
>> From: Lonni J Friedman [mailto:netllama@gmail.com]
>> Sent: Friday, 30 November 2012 12:11 PM
>> To: Sabry Sadiq
>> Cc: pgsql-admin@postgresql.org
>> Subject: Re: [ADMIN] Backup
>>
>> Yes.  Works fine in 9.2.x.
>>
>> On Thu, Nov 29, 2012 at 4:59 PM, Sabry Sadiq <ssadiq@whispir.com> wrote:
>>> Hi All,
>>>
>>>
>>>
>>> Has anyone been successful in offloading the database backup from
>>> the production database to the standby database?
>>>
>>>
>>>
>>> Kind Regards,
>>>
>>> Sabry

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


view thread (52+ messages)  latest in thread

Message-ID: <5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net>
Permalink:  ../5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net/
Also on:    postgresql.org/message-id/5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: ssadiq@whispir.com, netllama@gmail.com
  Subject: Re: Backup
  In-Reply-To: <5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net>
  References: <5641DCFFECC8DC41AE09790420B7B6680DAAD485@TOKYO.whispir.net> <CAP=oouGpsd5SbWrgcFa4JbLxhMXa_=uisiPe6NW8VVY-jJO-Rw@mail.gmail.com> <5641DCFFECC8DC41AE09790420B7B6680DAAD4E0@TOKYO.whispir.net> <CAP=oouEqn97oQvnkt6wHrcHa4E+kdkY6qpYN02rQH56OqTcwQA@mail.gmail.com> <5641DCFFECC8DC41AE09790420B7B6680DAAD509@TOKYO.whispir.net> <CAP=oouF7Gsxr5P9DuJuXhZNRuN8pUeBJ5+xKgekRTq1R4Ug5dQ@mail.gmail.com> <5641DCFFECC8DC41AE09790420B7B6680DAAD545@TOKYO.whispir.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox