Postgres Sequence issue

Поиск
Список
Период
Сортировка
От Ananth Thomas
Тема Postgres Sequence issue
Дата
Msg-id SYCPR01MB3645B08BE87A3057ECBF925E9AAE0@SYCPR01MB3645.ausprd01.prod.outlook.com
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения

Hi team,

 

Our postgres database (PostgreSQL 9.6.10 ) is hosted on Azure and we had to restore our postgres database on the local server. We had taken the backup through azure portal which I guess runs a copy command in back end.

After the backup the sequence table for some reason got rolled back to previous value, since we are not able to replicate the scenario , not sure if it happened as we took database backup.

Could you please help me with this scenario.

 

 

Thanks & Regards,

Ananth Thomas

Data Processing Specialist

Mobile: 0470634035

Greyhound Racing Victoria

46 - 50 Chetwynd Street, West Melbourne, 3003

 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #15530: unable restore index on function from earthdistancecontrib