Greetings,
* Christopher Pereira (krip...@imatronix.cl) wrote:
> On 24-May-20 15:48, Stephen Frost wrote:
> >That really shouldn't be possible. I'm very curious as to exactly what
> >happened that resulted in your primary/replica being 'out of sync', as
> >you say.
>
> Actually this was more a h
On 24-May-20 15:48, Stephen Frost wrote:
That really shouldn't be possible. I'm very curious as to exactly what
happened that resulted in your primary/replica being 'out of sync', as
you say.
Hi Stephen,
Actually this was more a hypothetical question to find a solution in
case some day one
Greetings,
* Christopher Pereira (krip...@imatronix.cl) wrote:
> Ok, we want to use pgbackrest to *rebuild a standby that has fallen behind*
> (where pg_rewind won't work). After reading the docs, we believe we should
> use this setup:
>
> a) Primary host: primary cluster
>
> b) Repository host:
We've contemplated adding support for something like this to pgbackrest,
since all the pieces are there, but there hasn't been a lot of demand
for it and it kind of goes against the idea of having a proper backup
solution, really.. It'd also create quite a bit of load on the primary
to checksum
On 21-May-20 08:43, Stephen Frost wrote:
* Christopher Pereira (krip...@imatronix.cl) wrote:
[...]
Is there some way to rebuild the standby cluster by doing a differential
backup of the primary cluster directly?
We've contemplated adding support for something like this to pgbackrest,
since a
Greetings,
* Christopher Pereira (krip...@imatronix.cl) wrote:
> On 21-May-20 08:43, Stephen Frost wrote:
> >* Christopher Pereira (krip...@imatronix.cl) wrote:
> >>Is there some way to rebuild the standby cluster by doing a differential
> >>backup of the primary cluster directly?
> >We've contemp
Greetings,
* Christopher Pereira (krip...@imatronix.cl) wrote:
> >>In case of big databases, can we do incremental backups with pg_basebackup?
> >pg_basebackup doesn't support incremental backups, though there's been
> >discussion of adding some kind of support for it, check -hackers if
> >you're
In case of big databases, can we do incremental backups with pg_basebackup?
pg_basebackup doesn't support incremental backups, though there's been
discussion of adding some kind of support for it, check -hackers if
you're curious.
Is there any alternative?
There's a few different alternativ
Greetings,
* Christopher Pereira (krip...@imatronix.cl) wrote:
> Our stream replication slave server got out of sync so we need to base
> backup again.
If you do WAL archiving instead of depending on the WAL to exist on the
primary then a replica can catch up using WAL. Having a WAL archive
also
On Fri, Nov 29, 2019 at 04:57:11PM -0300, Christopher Pereira wrote:
> Our stream replication slave server got out of sync so we need to base
> backup again.
>
> In case of big databases, can we do incremental backups with pg_basebackup?
I know of two ways to define such backups, one being actual
Our stream replication slave server got out of sync so we need to base
backup again.
In case of big databases, can we do incremental backups with pg_basebackup?
Is there any alternative?
Here was a proposal: https://wiki.postgresql.org/wiki/Incremental_backup
11 matches
Mail list logo
