| From: | Edu Gargiulo <egargiulo(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Incremental backup |
| Date: | 2021-10-28 16:23:46 |
| Message-ID: | CAD_UXMbLgR8Jbt2wQJj+K=jjDgf6AvprvdzDtOJ94r2OqnRh+A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 28, 2021 at 12:36 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 10/28/21 05:23, Edu Gargiulo wrote:
> > Hi all,
> >
> > Is there any way to make incremental backups in postgres-12?
>
> It would helpful to be more explicit about what you are trying to achieve.
>
> Do you want:
>
> 1) A continuous process or scheduled one?
>
Scheduled
2) Local or remote backups?
>
Local. Now I'm doing locally and copying backups to other servers.
3) The backup as a standby?
Now I'have a standby cluster via physical replication. Could do the backup
from standby server too.
4) Any other features requests you might have.
>
90% of the data in the databse is "static data" (compressed timescaledb
chunks), I want to append only that 10% of recently inserted or updated
data daily to yesterday backup, instead of do a full backup daily.
<adrian(dot)klaver(at)aklaver(dot)com>
Thanks in advance and sorry for my english
--
Eduardo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2021-10-28 16:25:33 | Re: Incremental backup |
| Previous Message | Adrian Klaver | 2021-10-28 15:36:32 | Re: Incremental backup |