Re: PostgreSQL Backup Strategies

From: Evan Rempel <erempel(at)uvic(dot)ca>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL Backup Strategies
Date: 2018-02-22 17:37:52
Message-ID: 41636e73-e478-f625-d210-5545ac0965c8@uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2018-02-22 17:48:43 Re: PostgreSQL Backup Strategies
Previous Message Stephen Frost 2018-02-22 11:59:40 Re: PostgreSQL Backup Strategies