From: | "Lazaro Garcia" <lazaro3487(at)gmail(dot)com> |
---|---|
To: | 'Κοκμάδης Δημήτριος' <dkokmadis(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Big sized materialized views break replication |
Date: | 2017-02-21 09:06:41 |
Message-ID: | 001501d28c21$d2ad0710$78071530$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
If recovery.conf has this configuration parameter:
primary_slot_name = repmgr_slot_1
The replication use replication slots otherwise when wal_keep_segments is reached, the redo logs are rotated.
With replication slot you only have the required wal files but with wal_keep_segments you only has the amount especified in it.
If you do not use replication slots there is no need of creating slots, see SELECT * from pg_replication_slots; on the master.
When a slot is used, wal_keep_segments has no effects and could be 0.
Regards.
De: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] En nombre de ???µ?d?? ??µ?t????
Enviado el: martes, 21 de febrero de 2017 08:23 a. m.
Para: pgsql-admin(at)postgresql(dot)org
Asunto: Re: [ADMIN] Big sized materialized views break replication
Hello,
Is it possible to use replication with slots and without them in the same setup or it could cause a problem?
Regards,
Dimitris
From | Date | Subject | |
---|---|---|---|
Next Message | Lazaro Garcia | 2017-02-21 13:02:52 | Re: Best system for a data warehouse application |
Previous Message | Κοκμάδης Δημήτριος | 2017-02-21 07:22:54 | Re: Big sized materialized views break replication |