pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rui DeSousa <rui.desousa@icloud.com>
To: flumbador@virgilio.it
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: backup postgresql with snapshot AWS
Date: Tue, 23 Jan 2018 10:04:19 -0500
Message-ID: <D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com> (raw)
In-Reply-To: <725266372.1794661.1516705371389@mail.virgilio.it>
References: <166191299.1443519.1516368751643@mail.virgilio.it>
	<58e57feb-1a0a-bb44-55a6-5c94d294de9e@pgmasters.net>
	<2ce36d42-c90a-ed10-173d-7b8445c1cec9@denninger.net>
	<A6F69AB0-A8A3-4102-B11A-24868D7FD031@icloud.com>
	<ae8b9394-aabe-2dfa-70e1-b349100f90ee@matrix.gatewaynet.com>
	<863cffbe-0c4b-bcda-189d-3026bc949c95@denninger.net>
	<5F7F898C-23FD-4543-8623-BF9FFDE648B7@icloud.com>
	<725266372.1794661.1516705371389@mail.virgilio.it>

Yes the single EBS volume will work.  As long as a filesystem only spans a single EBS volume and in your case they all share the same single EBS volume.

If each had there own volume; that too would work using multiple snapshots as one coherent backup.

i.e. 

pg_start_backup()

take snapshot: /pgsql/pdbabe/data     
take snapshot: /pgsql/pdbabe/tsdata    
take snapshot: /pgsql/pdbabe/tsindex  
take snapshot: /pgsql/pdbabe/tstemp    
take snapshot: /pgsql/pdbabe/xlog  

Pg_stop_backup()

And of course the associated WALs and future WALs.






view thread (13+ messages)

Message-ID: <D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com>
Permalink:  ../D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com/
Also on:    postgresql.org/message-id/D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.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: rui.desousa@icloud.com, flumbador@virgilio.it
  Subject: Re: backup postgresql with snapshot AWS
  In-Reply-To: <D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com>
  References: <166191299.1443519.1516368751643@mail.virgilio.it> <58e57feb-1a0a-bb44-55a6-5c94d294de9e@pgmasters.net> <2ce36d42-c90a-ed10-173d-7b8445c1cec9@denninger.net> <A6F69AB0-A8A3-4102-B11A-24868D7FD031@icloud.com> <ae8b9394-aabe-2dfa-70e1-b349100f90ee@matrix.gatewaynet.com> <863cffbe-0c4b-bcda-189d-3026bc949c95@denninger.net> <5F7F898C-23FD-4543-8623-BF9FFDE648B7@icloud.com> <725266372.1794661.1516705371389@mail.virgilio.it> <D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.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