Re: Re: upgrade from version 4.28 to 8.8

Hi Giacomo,

Is the db file open in any external SQLLite DB viewer? Or any other pgAdmin
instance is running? You need stop the usage first.

On Fri, Jul 5, 2024 at 12:32 PM Bonafé, Giacomo <
giacomo(dot)bonafe(at)six-group(dot)com> wrote:

> Ok i have kept pgadmin.db and the replaced in the directory of my user
>
>
>
> From The error log:
>
>
>
> os.rename(SQLITE_PATH, backup_file_name)
>
> PermissionError: [WinError 32] The process cannot access the file because
> it is being used by another process:
> 'C:\\Users\\<user>\\AppData\\Roaming\\pgadmin\\pgadmin4.db' ->
> 'C:\\Users\\<user>\\AppData\\Roaming\\pgadmin\\pgadmin4.db.20240704155404'
>
>
>
> In the pgadmin directory above the pgadmin4.db is saved by the tool with
> name
>
>
>
> pgadmin4.db.prev.bak
>
>
>
> and a new file pgadmin4 is created
>
>
>
>
> Sensitivity: C2 Internal
> From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* Donnerstag, 4. Juli 2024 14:06
> *To:* Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com>
> *Cc:* pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject:* [External Sender] Re: upgrade from version 4.28 to 8.8
>
>
>
> Hi Giacomo,
>
>
>
> Keep the backup of the pgadmin.db file and directly upgrade pgAdmin. It
> should work.
>
> If you're facing any issues, share the error details.
>
>
>
> On Thu, Jul 4, 2024 at 4:42 PM Bonafé, Giacomo <
> giacomo(dot)bonafe(at)six-group(dot)com> wrote:
>
> Hello,
>
>
>
> is there a way to upgrade from version 4.28 to version 8.8 ?
>
> I have attempted saving the pgadmin.db file before deleting 4.28 and
> installed 8.8 and then copied the saved pgadmin.db but this does not work
>
>
>
> Is there a solution to this problem ?
>
>
>
> Thanks and regards
>
> Giacomo Bonafe
>
>
>
>
>
> Sensitivity: C2 Internal
>
> The content of this e-mail is intended only for the confidential use of
> the person addressed.
> If you are not the intended recipient, please notify the sender and delete
> this e-mail immediately.
> Thank you.
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
>
> "Don't Complain about Heat, Plant a TREE"
>
> The content of this e-mail is intended only for the confidential use of
> the person addressed.
> If you are not the intended recipient, please notify the sender and delete
> this e-mail immediately.
> Thank you.
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"