From: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: PG 10 streaming replication with repmgr basic cfg Q
Date: Fri, 6 Oct 2017 11:03:34 -0700
Message-ID: <59D7C576.1000607@nrc-cnrc.gc.ca> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi List,
I am learning to cfg PG 10 streaming replication with repmgr ( master
-> slave rep cfg) so far for basic small transactions , switching
over to slave and promoting as new master is been smooth , now I am
trying a copy/insert > 15 mill entries in a table in master rep server
using " copy" from a file after less than 10 min the I filled aprox
20GB allocated to log, wal_files, here is from my pstgresql. conf and
repmgr , I cfg PG10 to use replication slots do I still need
archive_mode "on" ?
Is this normal to generate so many wal_files ?
and
How I should handle "COPY" large amount/batch data in a streaming
replication cfg ?
my postgresql.conf
max_wal_senders=10
wal_level='hot_standby'
hot_standby=on ( on standby server)
archive_mode=on
archive_command = 'cp %p /var/lib/pgsql/10/archive/%f'
wal_keep_segments =10
max_replication_slots = 2
***************************
repmgr.conf
use_replication_slots=1
********************************
SELECT * FROM pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | temporary |
active | active_pid | xmin | catalog_xmin | restart_lsn |
confirmed_flush_lsn
---------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
repmgr_slot_1 | | physical | | | f | f
| | | | 0/14000108 |
***************
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: PG 10 streaming replication with repmgr basic cfg Q
In-Reply-To: <59D7C576.1000607@nrc-cnrc.gc.ca>
* 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