Re: Moving pgadmin4.db to a new server

From: Jan Birk <jan(dot)g(dot)birk(at)gmail(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Moving pgadmin4.db to a new server
Date: 2019-10-20 07:21:03
Message-ID: abba9c1eb4c8e625c22efc4362730772c362fc0e.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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
> migrations till the current version.

We did copy and then started. That's explain why the schema *seems* to be ok :-)

We haven't moved the production site yet. But every thing in out test looks ok
expect the passwords.

Not knowing python (just grep) it seems that the SALT is auto generated in
config-database??

../migrations/versions/xxxxxx_.py
..

114 current_salt = getattr(
115 config, 'SECURITY_PASSWORD_SALT',
base64.urlsafe_b64encode(
116 os.urandom(32)
117 ).decode()
118
)
..

Could it be a workaround to re-initialize (re-install) pgadmin having
current_salt equals the old one ???

Best

Jan

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Tony Shelver 2019-10-20 12:20:36 pgAdmin4.13: failed to launch server
Previous Message Aditya Toshniwal 2019-10-20 06:15:37 Re: Moving pgadmin4.db to a new server