Postgres Pro
Downloads
Home   >   mailing lists

Postgres Sequence issue - Mailing list pgsql-bugs

From Ananth Thomas
Subject Postgres Sequence issue
Date
Msg-id SYCPR01MB3645B08BE87A3057ECBF925E9AAE0@SYCPR01MB3645.ausprd01.prod.outlook.com
Whole thread Raw
List pgsql-bugs
Tree view

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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores
Next
From: Sergei Kornilov
Date:
Subject: Re: BUG #15530: unable restore index on function from earthdistancecontrib