Thread: Postgres Sequence issue

Postgres Sequence issue

From
Ananth Thomas
Date:

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