| From: | Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> |
|---|---|
| To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Replication: slave server has 3x size of production server? |
| Date: | 2020-02-25 09:55:44 |
| Message-ID: | 20200225105544.7bda4012@firost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 22 Feb 2020 19:23:05 +0000
Edson Richter <edsonrichter(at)hotmail(dot)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(at)192(dot)168(dot)0(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stanislav Motyčka | 2020-02-25 10:17:47 | a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] |
| Previous Message | Nick Renders | 2020-02-25 09:35:38 | Re: Postgres 12.1 : UPPER() in WHERE clause restarts server |