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

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