Re: Adding new server in pgadmin from command line

Hi Asmita,

No. pgAdmin does not provide any command line utility for user management.

Thanks,
Yogesh Mahajan
EnterpriseDB

On Wed, May 4, 2022 at 4:16 PM Asmita Thapliyal <asmita(dot)thapliyal(at)gmail(dot)com>
wrote:

> 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
>>>
>>