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 > 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: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 <ssa...@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:netll...@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 <ssa...@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
