Discussion:
Backup
(too old to reply)
Sabry Sadiq
2012-11-30 00:59:45 UTC
Permalink
Hi All,

Has anyone been successful in offloading the database backup from the production database to the standby database?

Kind Regards,
Sabry




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 ***@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.
Sabry Sadiq
2012-11-30 01:11:33 UTC
Permalink
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

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:***@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:***@gmail.com]
Sent: Friday, 30 November 2012 12:11 PM
To: Sabry Sadiq
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Backup

Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Lonni J Friedman
2012-11-30 01:12:59 UTC
Permalink
There aren't any, assuming that all of the servers are using the same
postgresql.conf. I'm referring to running pg_basebackup.
Post by Sabry Sadiq
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-----
Sent: Friday, 30 November 2012 12:11 PM
To: Sabry Sadiq
Subject: Re: [ADMIN] Backup
Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Sabry Sadiq
2012-11-30 01:13:55 UTC
Permalink
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:***@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:***@gmail.com]
Sent: Friday, 30 November 2012 12:13 PM
To: Sabry Sadiq
Cc: pgsql-***@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.
Post by Sabry Sadiq
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-----
Sent: Friday, 30 November 2012 12:11 PM
To: Sabry Sadiq
Subject: Re: [ADMIN] Backup
Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Lonni J Friedman
2012-11-30 01:15:02 UTC
Permalink
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?
Post by Sabry Sadiq
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
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-----
Sent: Friday, 30 November 2012 12:13 PM
To: Sabry Sadiq
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.
Post by Sabry Sadiq
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-----
Sent: Friday, 30 November 2012 12:11 PM
To: Sabry Sadiq
Subject: Re: [ADMIN] Backup
Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Sabry Sadiq
2012-11-30 01:16:08 UTC
Permalink
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:***@whispir.com
1300 WHISPIR / 1300 944 774
www.whispir.com


-----Original Message-----
From: Lonni J Friedman [mailto:***@gmail.com]
Sent: Friday, 30 November 2012 12:15 PM
To: Sabry Sadiq
Cc: pgsql-***@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?
Post by Sabry Sadiq
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
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-----
Sent: Friday, 30 November 2012 12:13 PM
To: Sabry Sadiq
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.
Post by Sabry Sadiq
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-----
Sent: Friday, 30 November 2012 12:11 PM
To: Sabry Sadiq
Subject: Re: [ADMIN] Backup
Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Lonni J Friedman
2012-11-30 01:17:13 UTC
Permalink
*how* are the backups being generated?
Post by Sabry Sadiq
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
1300 WHISPIR / 1300 944 774
www.whispir.com
-----Original Message-----
Sent: Friday, 30 November 2012 12:15 PM
To: Sabry Sadiq
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?
Post by Sabry Sadiq
Does it work well with version 9.1.3?
Sabry Sadiq
Systems Administrator
Whispir
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Sabry Sadiq
2012-11-30 01:17:37 UTC
Permalink
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:***@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:***@gmail.com]
Sent: Friday, 30 November 2012 12:17 PM
To: Sabry Sadiq
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Backup

*how* are the backups being generated?
Post by Sabry Sadiq
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
1300 WHISPIR / 1300 944 774
www.whispir.com
-----Original Message-----
Sent: Friday, 30 November 2012 12:15 PM
To: Sabry Sadiq
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?
Post by Sabry Sadiq
Does it work well with version 9.1.3?
Sabry Sadiq
Systems Administrator
Whispir
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Lonni J Friedman
2012-11-30 21:25:21 UTC
Permalink
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.
Post by Sabry Sadiq
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
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-----
Sent: Friday, 30 November 2012 12:17 PM
To: Sabry Sadiq
Subject: Re: [ADMIN] Backup
*how* are the backups being generated?
Post by Sabry Sadiq
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
1300 WHISPIR / 1300 944 774
www.whispir.com
-----Original Message-----
Sent: Friday, 30 November 2012 12:15 PM
To: Sabry Sadiq
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?
Post by Sabry Sadiq
Does it work well with version 9.1.3?
Sabry Sadiq
Systems Administrator
Whispir
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Lonni J Friedman
2012-11-30 01:10:45 UTC
Permalink
Yes. Works fine in 9.2.x.
Post by Sabry Sadiq
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner
2012-11-30 01:28:31 UTC
Permalink
Post by Sabry Sadiq
Does it work well with version 9.1.3?
It might work better in 9.1.6:

http://www.postgresql.org/support/versioning/

And it would probably pay to keep up-to-date as new minor releases
become available.

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