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

From Adrian Klaver
Subject Re: Replication: slave server has 3x size of production server?
Date
Msg-id 22dad45b-7d11-807e-c258-1e9872561f3b@aklaver.com
Whole thread Raw
In response to RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Responses RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
List 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 by date:

Previous
From: Ron
Date:
Subject: Re: How to fix 0xC0000005 exception in Postgres 9.0
Next
From: Rob Sargent
Date:
Subject: Re: How to fix 0xC0000005 exception in Postgres 9.0