Google Cloud Platform, snapshots and WAL

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Google Cloud Platform, snapshots and WAL
Date: 2017-03-20 13:31:29
Message-ID: bb0690ea-d9e3-f0ca-2a56-f24ae9cdb6a5@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

I have my PostgreSQL 9.5 server running on a VM instance on Google
Compute Engine (Google Cloud Platform) on Debian Jessie (8.3), and I
have another dedicated VM instance that, every night at 3.00, takes a
snapshot of the whole disk, without stopping the PG instance itself.
Snapshots are stored and kept by Google in an incremental way, and we
keep the last 2 weeks of history.
The question is: Keeping all two weeks worth of pg_xlog files, I don't
think I still need a periodic pg_basebackup to perform PITR, do I?

Thanks in advance,
Moreno.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-03-20 14:18:07 Re: Postgres goes to auto recovery mode after system restart(check this draft)
Previous Message Michael Paquier 2017-03-20 12:52:42 Re: testcase failing on git master / how to progress