| From: | Nikhil Mohite <nikhil(dot)mohite(at)enterprisedb(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | [pgAdmin][RM-6460]: Need a mechanism to detect a corrupt/broken config DB file. |
| Date: | 2021-06-03 06:39:05 |
| Message-ID: | CAOBg0AOa4EfDwph4Ba2=GV4SSnLJ8vxtqdb=zt8koQNAwuNy9w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Hi Hackers,
Please find the attached patch for RM-6460
<https://redmine.postgresql.org/issues/6460>: Need a mechanism to detect a
corrupt/broken config DB file.
1. Added checks if all tables added in the model are present in SQLite DB
or not.
2. If migrations fail it will backup older file and try migrations with the
newly created file.
(User will get notification on UI for the location of the backup file and
newly created.)
3. If the user deleted any table from SQLite DB pgAdmin will not run on the
next restart and it will add the missing table list in the logs.
--
*Thanks & Regards,*
*Nikhil Mohite*
*Software Engineer.*
*EDB Postgres* <https://www.enterprisedb.com/>
*Mob.No: +91-7798364578.*
| Attachment | Content-Type | Size |
|---|---|---|
| RM_6460.patch | application/octet-stream | 9.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2021-06-03 08:17:41 | Re: [pgAdmin][RM-6460]: Need a mechanism to detect a corrupt/broken config DB file. |
| Previous Message | Rahul Shirsat | 2021-06-02 07:46:56 | [patch][pgAdmin] RM1591 [Web Based] Grant Wizard should also add under package node |