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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Replication: slave server has 3x size of production server?
Дата
Msg-id 22dad45b-7d11-807e-c258-1e9872561f3b@aklaver.com
обсуждение исходный текст
Ответ на RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Ответы RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Список pgsql-general
On 2/22/20 2:51 PM, Edson Richter wrote:

> 
> Yes, it is working. Last X'log file is present on all thee servers.
> Also, comparting last transaction number on master and slave shows that 
> all are in sync.
> Last, but not least, select max(id) from a busy table shows same id 
> (when queried almost simultaneously using a simple test routine).

Well something is keeping those WAL file around. You probably should 
analyze your complete setup to see what else is touching those servers.

> 
>     > 
>     > 
>     > The files are about 7 months old.
> 
>     Are there newer files that would indicate that the streaming is working?
> 
> 
> Yes, streaming is working properly (as stated above).
> 
> Thanks,
> 
> 
> Edson Richter
> 
> 
>> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: How to fix 0xC0000005 exception in Postgres 9.0
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: How to fix 0xC0000005 exception in Postgres 9.0