| From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: WAL Archiving and base backup |
| Date: | 2022-01-16 19:39:05 |
| Message-ID: | 347e4646-42d8-ab87-565d-be773c998e7f@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/16/22 13:12, Issa Gorissen wrote:
>
> Just to avoid any misunderstanding. I am perfectly happy using the
> backup/restore with pg_dump and we use it for at least a decade with
> success for our need of backups.
I am using pgbackrest. I used to use pg_rman, being well acquainted with
rman backup tool belonging to another database system, but pg_rman was
removing WAL archives before they were delivered to replica. I have
replication slots from the OLTP database to the DW database with
partitions, hash and bloom indexes and massive amount of processors, for
parallel query. I need the replication to work. In addition to that,
pgbackrest can employ parallelism while pg_rman cannot do that. I find
pgbackrest by far the best Postgres backup system.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carla Iriberri | 2022-01-17 16:05:52 | could not accept SSL connection: Success |
| Previous Message | R Batchen | 2022-01-16 18:14:39 | Re: How to debug incomplete message on postgres 12.3 docker |