Re: Replication: slave server has 3x size of production server? - Mailing list pgsql-general

From Jehan-Guillaume de Rorthais
Subject Re: Replication: slave server has 3x size of production server?
Date
Msg-id 20200225105544.7bda4012@firost
Whole thread Raw
In response to RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
On Sat, 22 Feb 2020 19:23:05 +0000
Edson Richter <edsonrichter@hotmail.com> wrote:
[...]
> Actually, standby server is sending wals to a backup (barman) server:
> 
> archive_mode = always           # enables archiving; off, on, or always
> (change requires restart) archive_command = 'rsync -e "ssh -2 -C -p 2022" -az
> %p barman@192.168.0.2:/dados/barman/dbcluster/incoming/%f'
> 
> 
> The files are about 7 months old.

Did you check the return code of your archive_command? 

Did you check the log produced by your archive_command and postmaster?

How many files with ".ready" extension in "$PGDATA/pg_xlog/archive_status/"?

Can you confirm there's no missing WAL between the older one and
the newer one in "$PGDATA/pg_xlog" in alphanum order?



pgsql-general by date:

Previous
From: "Nick Renders"
Date:
Subject: Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Next
From: Stanislav Motyčka
Date:
Subject: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]