Message-ID: <59D7C576.1000607@nrc-cnrc.gc.ca>
Date: Fri, 6 Oct 2017 11:03:34 -0700
From: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130110 Thunderbird/17.0.2
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: PG 10 streaming  replication with repmgr basic cfg Q
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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