Re: Adding new server in pgadmin from command line

Hi Asmita,

Here
<https://www.pgadmin.org/docs/pgadmin4/6.8/import_export_servers.html#importing-servers>
are the steps to add servers using command line. Inserting data entries
directly may lead to unexpected behaviour.

Thanks,
Yogesh Mahajan
EnterpriseDB

On Tue, May 3, 2022 at 2:39 PM Asmita Thapliyal <asmita(dot)thapliyal(at)gmail(dot)com>
wrote:

> Hello Team,
>
> I would like to perform server addition activity in pgadmin from the
> command line.
> I tried to add newserver in pgadmin following below procedure.
>
> Create a migration file with the following command:
>
> (venv) $ FLASK_APP=pgAdmin4.py flask db revision
>
> This will create a file in: $PGADMIN4_SRC/web/migrations/versions/ . Add
> any changes to the 'upgrade' function. Increment the SCHEMA_VERSION in
> $PGADMIN4_SRC/web/pgadmin/model/init.py file.
> Below is the upgrade function command I am using.
>
> db.engine.execute("""
> INSERT INTO server (
> id, user_id, servergroup_id, name, host, port, maintenance_db,
> username, password, ssl_mode
> ) VALUES ( 1, 1, 1, "stagdb", "<hostname>", 5454, "mpsdb", "mproot",
> "<password>", "prefer" )
> """ )
> and restart pgadmin.
>
> But during pgdmin restart I get a db migration exception without any error
> details. Is this the correct procedure I am following? can we add servers
> in pgadmin from the command line instead of UI?
>
> Regards,
> Asmita
>