Re: Adding new server in pgadmin from command line

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(dot)mahajan(at)enterprisedb(dot)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(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
>>
>