Thanks Yogesh! It works. Do we also have a command line for user management? Mainly I am looking for changing the roles associated with users.
Regards, Asmita On Tue, May 3, 2022 at 3:38 PM Yogesh Mahajan < yogesh.maha...@enterprisedb.com> wrote: > 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.thapli...@gmail.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 >> >