Re: Postgresql database help

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Postgresql database help
Дата
Msg-id bebc9d9f-a9ad-400d-954e-47093f981404@aklaver.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jim Vanns
Дата:
Сообщение: Re: Tips on troubleshooting slow DELETE (suspect cascades)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Tips on troubleshooting slow DELETE (suspect cascades)