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 <ssa...@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:ssa...@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:netll...@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 <ssa...@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:ssa...@whispir.com >> 1300 WHISPIR / 1300 944 774 >> www.whispir.com >> >> >> -----Original Message----- >> From: Lonni J Friedman [mailto:netll...@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 <ssa...@whispir.com> wrote: >>> Does it work well with version 9.1.3? >>> >>> >>> >>> Sabry Sadiq >>> Systems Administrator >>> >>> Whispir -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin