pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
To: pgsql-admin@postgresql.org, Luis Marin <luismarinaray@gmail.com>
Subject: RE: PostgreSQL Backup Strategies
Date: Wed, 21 Feb 2018 22:08:19 -0500 (PET)
Message-ID: <aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com> (raw)
In-Reply-To: <CAEp6HQVHATX7yjYtdbVcOf0_03ZAxmEVKo=E1WG+y5rkok76jA@mail.gmail.com>
References: <CAEp6HQVHATX7yjYtdbVcOf0_03ZAxmEVKo=E1WG+y5rkok76jA@mail.gmail.com>

Sorry I have no book to recommend, but my recommendation will always pass through pg_basebackup, which will perform a full backup of you running database without needing to stop anything, and will also(with adequate args) add all transactiins committed zuring the backup to the backup itself.

I do myself use pg_basebackup and a simple shellscript to do automated backups of a production system.

I've also heard about pgbarman, but have no knowledge on it.

Regards,

Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.

Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+51) 954183248
Website: www.ocs.pe

Sent from my Sony Xperia™ smartphone

---- 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

view thread (6+ messages)  latest in thread

Message-ID: <aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com>
Permalink:  ../aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com/
Also on:    postgresql.org/message-id/aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: aaguayo@opensysperu.com, luismarinaray@gmail.com
  Subject: Re: PostgreSQL Backup Strategies
  In-Reply-To: <aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com>
  References: <CAEp6HQVHATX7yjYtdbVcOf0_03ZAxmEVKo=E1WG+y5rkok76jA@mail.gmail.com> <aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com>

* 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