Re: Postgresql database help

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: ankit(dot)singh(at)nest-is2(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql database help
Date: 2024-01-18 16:41:01
Message-ID: bebc9d9f-a9ad-400d-954e-47093f981404@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/18/24 05:10, ankit(dot)singh(at)nest-is2(dot)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(dot)klaver(at)aklaver(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-01-18 16:46:46 Re: Tips on troubleshooting slow DELETE (suspect cascades)
Previous Message Jim Vanns 2024-01-18 16:37:59 Re: Tips on troubleshooting slow DELETE (suspect cascades)