From: Evan Rempel <erempel@uvic.ca>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL Backup Strategies
Date: Thu, 22 Feb 2018 09:37:52 -0800
Message-ID: <41636e73-e478-f625-d210-5545ac0965c8@uvic.ca> (raw)
In-Reply-To: <CAEp6HQVHATX7yjYtdbVcOf0_03ZAxmEVKo=E1WG+y5rkok76jA@mail.gmail.com>
References: <CAEp6HQVHATX7yjYtdbVcOf0_03ZAxmEVKo=E1WG+y5rkok76jA@mail.gmail.com>
The concepts are the same regardless of what tools you use. These concepts are documented very well in the on-line PostgreSQL documentation at www.posgresql.org
Depending on what your final destination is for your backups (i.e. what product you use to manage your backups) you may wish to alter the backup tool you use.
At our site we use Tivoli Storage Manager (Spectrum Protect) to perform backups of a variety of things (Linux, Windows, Oracle, MySQL, Exchange) so we wanted to integrate our PostgreSQL backups with this product.
The result of this was that tools like pg_basebackup were not a good fit for us.
If you are using Tivoli Storage Manager for backups I can provide some guidance with regards to that integration.
Evan.
On 02/21/2018 07:01 PM, Luis Marin wrote:
> Dear Friends,
>
> Please, somebody knows a good source of information about PostgreSQL 9 backup strategies for production systems, if you have read a good book with this subject, could you share the author and name of the book ?
>
> Thanks
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erempel@uvic.ca, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL Backup Strategies
In-Reply-To: <41636e73-e478-f625-d210-5545ac0965c8@uvic.ca>
* 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