Postgres Sequence issue

From: Ananth Thomas <athomas(at)grv(dot)org(dot)au>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgres Sequence issue
Date: 2018-12-03 05:21:27
Message-ID: SYCPR01MB3645B08BE87A3057ECBF925E9AAE0@SYCPR01MB3645.ausprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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<http://www.grv.org.au/>
46 - 50 Chetwynd Street, West Melbourne, 3003

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2018-12-03 12:00:32 Re: BUG #15530: unable restore index on function from earthdistance contrib
Previous Message Tom Lane 2018-12-01 16:42:59 Re: BUG #15534: Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores