Re: Backup

I can generate a backup using pg_dump on a slave with 9.2.1.  No clue
if it works with 9.1.x (or older) versions though.

On Thu, Nov 29, 2012 at 5:17 PM, Sabry Sadiq <ssadiq@whispir.com> wrote:
> Pg_dump
>
>
>
> 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
havereceived 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
communicationyou should not copy, disclose or distribute this communication without the authority of Whispir. Any views
expressedin this Communication are those of the individual sender, except where the sender specifically states them to
bethe views of Whispir. Except as required at law, Whispir does not represent, warrant and/or guarantee that the
integrityof 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:17 PM
> To: Sabry Sadiq
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Backup
>
> *how* are the backups being generated?
>
> On Thu, Nov 29, 2012 at 5:16 PM, Sabry Sadiq <ssadiq@whispir.com> wrote:
>> 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