pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedstreaming replication and wal 's usages
2+ messages / 2 participants
[nested] [flat]
* streaming replication and wal 's usages
@ 2018-03-09 19:55 ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
2018-03-12 08:57 ` Re: streaming replication and wal 's usages Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 2+ messages in thread
From: ghiureai @ 2018-03-09 19:55 UTC (permalink / raw)
To: pgsql-admin
HI List
I am running PG 10.2 with streaming replication, no archiving option
with 10 slots replication option , I had the slave down for 6 hours
which generated 56GB of wal files in pg_wal dir, after slave was brougt
online and catchup with master , the wal dir was still growing on slave
with more than 25GB where in archive_status where all the files where in
*.done files , eventually the /wal directory reached 100% but still no
wal files removed from archive_status
I am trying to understand what I am missing in this confg ( the master
and slave are cfg for pg_dump backups the switch-over is done with
pg_basebackup using repmgr4.2.last release )
the present db size 140GB OLTP type transactions , with an avg 10-12GB
new data growth per day.
Here is my cfg
wal_keep_segments = 300
max_replication_slots=10
wal_log_hints = on
checkpoint_timeout = 5min
max_wal_size = 1GB
min_wal_size = 80MB
archive_mode=off
hot_standby =on
Thank you
Isabella
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: streaming replication and wal 's usages
2018-03-09 19:55 streaming replication and wal 's usages ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2018-03-12 08:57 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2018-03-12 08:57 UTC (permalink / raw)
To: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>; pgsql-admin
ghiureai wrote:
> I am running PG 10.2 with streaming replication, no archiving option
> with 10 slots replication option , I had the slave down for 6 hours
> which generated 56GB of wal files in pg_wal dir, after slave was brougt
> online and catchup with master , the wal dir was still growing on slave
> with more than 25GB where in archive_status where all the files where in
> *.done files , eventually the /wal directory reached 100% but still no
> wal files removed from archive_status
>
> I am trying to understand what I am missing in this confg ( the master
> and slave are cfg for pg_dump backups the switch-over is done with
> pg_basebackup using repmgr4.2.last release )
>
> the present db size 140GB OLTP type transactions , with an avg 10-12GB
> new data growth per day.
>
> Here is my cfg
>
> wal_keep_segments = 300
> max_replication_slots=10
> wal_log_hints = on
> checkpoint_timeout = 5min
> max_wal_size = 1GB
> min_wal_size = 80MB
> archive_mode=off
>
> hot_standby =on
You are not using replication slots, right?
Check pg_replication_slots to see if you have abandoned replication slots;
that could cause old WAL to be retained.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-03-12 08:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-09 19:55 streaming replication and wal 's usages ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
2018-03-12 08:57 ` Laurenz Albe <laurenz.albe@cybertec.at>
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