Re: Postgresql database help - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Postgresql database help
Date
Msg-id bebc9d9f-a9ad-400d-954e-47093f981404@aklaver.com
Whole thread Raw
List pgsql-general
On 1/18/24 05:10, ankit.singh@nest-is2.com wrote:
> I need help on another issue now.
> 
> I have two Linux servers with Postgresql version 14 on both servers. One 
> of the server databases has data from 1^st December to 23rd December and 
> in another server, database has data from 10 December to 31^st December.
> 
> Is there some process by which I can sync all data from both databases 
> in one database then it will show all data from 1^st December to 31^st 
> December in one database?

Short answer, no.

For a possible longer answer:

Is the data in the range 10 December to 23 December the same for both 
databases?

Do you have timestamp fields in each table that would show you when data 
was entered or updated?



-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Jim Vanns
Date:
Subject: Re: Tips on troubleshooting slow DELETE (suspect cascades)
Next
From: Adrian Klaver
Date:
Subject: Re: Tips on troubleshooting slow DELETE (suspect cascades)