Thread: Adding new server in pgadmin from command line
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.
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" )
""" )
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
Hi Asmita,Here are the steps to add servers using command line. Inserting data entries directly may lead to unexpected behaviour.Thanks,Yogesh MahajanEnterpriseDBOn Tue, May 3, 2022 at 2:39 PM Asmita Thapliyal <asmita.thapliyal@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
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,AsmitaOn Tue, May 3, 2022 at 3:38 PM Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:Hi Asmita,Here are the steps to add servers using command line. Inserting data entries directly may lead to unexpected behaviour.Thanks,Yogesh MahajanEnterpriseDBOn Tue, May 3, 2022 at 2:39 PM Asmita Thapliyal <asmita.thapliyal@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