Postgres Pro
Downloads
Home   >   mailing lists

Adding new server in pgadmin from command line - Mailing list pgadmin-support

From Asmita Thapliyal
Subject Adding new server in pgadmin from command line
Date
Msg-id CAMgBNbHhkw6afzJswHyK+GQrpG-i0_rshK705H9cCvsing7MiA@mail.gmail.com
Whole thread Raw
Responses Re: Adding new server in pgadmin from command line  (Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>)
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Asmita Thapliyal
Date:
Subject: Re: OAUTH2 Problem with AzureAD
Next
From: Garrett Simpson
Date:
Subject: Estimated release date for official pgadmin4 repos for Ubuntu 22.04 Jammy Jellyfish?