From: Stephen Frost <sfrost@snowman.net>
To: pham lan <phamlankt@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: questions about point in time recovery of the primary postgres Server
Date: Fri, 24 Jul 2020 09:30:53 -0400
Message-ID: <20200724133053.GV12375@tamriel.snowman.net> (raw)
In-Reply-To: <CAELvXOBVVBPeSj=gn93C3zs9rc69CMMaQDz7xb+iJMtYNG-FVw@mail.gmail.com>
References: <CAELvXOBVVBPeSj=gn93C3zs9rc69CMMaQDz7xb+iJMtYNG-FVw@mail.gmail.com>
Greetings,
* pham lan (phamlankt@gmail.com) wrote:
> I am pretty new to Postgres and I have been reading about streaming
> replication and point in time recovery which is very interesting to me.
> What is not clear to me is: let's say I have a cluster of 1 primary and 2
> slaves Postgres 9.5 which have archive_mode on. Streaming replication is
> working fine. If for instance, i drop by mistake one table, and i need to
> do a restore to a point before the time the table was dropped, will I need
> to do the recovery only on the primary postgres server? How will the slaves
> behave during the recovery process of the primary?
The replicas will need to be rebuilt after the restore of the primary.
There's a few different ways to do that, but the fastest that I'm aware
of would be a pgbackrest delta restore of all the systems using an
appropriate backup set (which pgbackrest will figure out for you when
you tell it the time you want to restore to).
Thanks,
Stephen
Attachments:
[application/pgp-signature] signature.asc (818B, ../20200724133053.GV12375@tamriel.snowman.net/2-signature.asc)
download
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: sfrost@snowman.net, phamlankt@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: questions about point in time recovery of the primary postgres Server
In-Reply-To: <20200724133053.GV12375@tamriel.snowman.net>
* 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