Re: Replication: slave server has 3x size of production server?

Поиск
Список
Период
Сортировка
От Jehan-Guillaume de Rorthais
Тема Re: Replication: slave server has 3x size of production server?
Дата
Msg-id 20200225105544.7bda4012@firost
обсуждение исходный текст
Ответ на RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Nick Renders"
Дата:
Сообщение: Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Следующее
От: Stanislav Motyčka
Дата:
Сообщение: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]]