Re: Moving pgadmin4.db to a new server

2019-10-21 Thread Jan Birk
Hi Aditya Maybe I am not clear on the objective: We have to migrate the PGadmin away from server1 running OEL 7 to a new server2 running Ubuntu 18.04 In that process we must keep the users (+100) settings and password. We are - however - able to keep the settings by just moving the db file from s

Re: Moving pgadmin4.db to a new server

2019-10-21 Thread Aditya Toshniwal
Hi Jan, Try this, 1) Remove all the existing session data. For that, shut down the server, go to sessions directory just beside the db file and remove all the files in it. 2) Go to browser and clean all the cache. 3) Start pgAdmin4 and open a new window. Let us know if this works. On Sun, Oct 20,

Re: Moving pgadmin4.db to a new server

2019-10-20 Thread Jan Birk
Hi and thanks for your efforts and time søn, 20 10 2019 kl. 11:45 +0530, skrev Aditya Toshniwal: > How did you copy the .db file ? > Did you copy first and then started pgAdmin or started first and then copied. > When pgAdmin4 starts, it checks the schema version of .db file and applies the > migr

Re: Moving pgadmin4.db to a new server

2019-10-19 Thread Aditya Toshniwal
Hi Jan, How did you copy the .db file ? Did you copy first and then started pgAdmin or started first and then copied. When pgAdmin4 starts, it checks the schema version of .db file and applies the migrations till the current version. On Sun, Oct 20, 2019, 11:40 Avin Kavish wrote: > https://sqli

Re: Moving pgadmin4.db to a new server

2019-10-19 Thread Avin Kavish
https://sqlitebrowser.org/ should allow you to open the db files and inspect the schema On Sun, Oct 20, 2019 at 11:28 AM Jan Birk wrote: > Hi Murtuza, > > Thanks. The server definitions seems to be ok only by moving the db files. > However we can't really be sure. > > Is there - in the docs - a

Re: Moving pgadmin4.db to a new server

2019-10-19 Thread Jan Birk
Hi Murtuza, Thanks. The server definitions seems to be ok only by moving the db files. However we can't really be sure. Is there - in the docs - a schema description for each version ? We have +100 users and we will not be popular if we can't migrate to another server but will have have to ask

Re: Moving pgadmin4.db to a new server

2019-10-19 Thread Murtuza Zabuawala
Hi, Yes it is throwing error due to password salt, It would be better if you follow steps from https://www.pgadmin.org/docs/pgadmin4/4.14/import_export_servers.html for migration. Please note that as of now there is no way of exporting pgAdmin4 settings. -- Murtuza On Fri, 18 Oct 2019, 21:55

Moving pgadmin4.db to a new server

2019-10-18 Thread Jan Birk
Hi, We are running pgadmin4 v 3.4 and are migration to a new server and a new version 4.12.. We have copied the old pgadmin4.db to the new server in order to keep the users settings and passwords. Settings is working but not the passwords. We get an "Failed to decrypt the saved password. Error