Re: Moving pgadmin4.db to a new server

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 <jan(dot)g(dot)birk(at)gmail(dot)com> 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 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 the users to start over with settings and
> passwords.
>
> We might be able to write a tool to do this if we can find the docs. Other
> users
> might find this useful to when they have to change servers.
>
> Best and thanks again for the product.
>
> /Jan
>
>
>
>
> søn, 20 10 2019 kl. 10:43 +0530, skrev 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 Jan Birk, <jan(dot)g(dot)birk(at)gmail(dot)com> wrote:
> > > 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: 'utf-8' codec can't
> decode
> > > byte 0x92 in position 0: invalid start byte"
> > >
> > > Maybe this is related to some salt in the passwords but I am not sure.
> > >
> > > How should we correctly migrate from one server to another ?
> > >
> > > Best and thanks for a very good application. It's just getting better
> and
> > > better.
> > >
> > > /Jan
> > >
> > > --
> > > Undervisningsministeriet
> > > (Danish Ministry of Education)
> > >
> > >
> > > Styrelsen for It og Læring
> > > Kontor for It-drift
> > >
> > > Vester Voldgade 123
> > > 1552 København V
> > > Tlf: +45 41741615
> > > Mail: Jan(dot)Birk(at)stil(dot)dk
>
>
>
>