Re: pgadmin 4 wont start on redhat 8

[Aditya Toshniwal]

Hi Andre,

Are you typing "Email address:" value or pasting ? Try typing manually.

On Thu, Jan 23, 2020 at 1:09 PM Andre Steyn  wrote:

> I get these messages each time i startup, i have removed and re-installed,
> but get the same issues
>
> [root@localhost ~]# systemctl status pgadmin4.service
> ● pgadmin4.service - pgAdmin4 Server Mode
>Loaded: loaded (/usr/lib/systemd/system/pgadmin4.service; enabled;
> vendor preset: disabled)
>Active: failed (Result: exit-code) since Thu 2020-01-23 08:25:36 SAST;
> 1h 14min ago
>  Docs: https://www.pgadmin.org/docs/
>  Main PID: 5237 (code=exited, status=1/FAILURE)
>
> Jan 23 08:25:36 localhost.localdomain python3[5237]:
> self.get_context().run_migrations(**kw)
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 362,
> in run_migrations
> Jan 23 08:25:36 localhost.localdomain python3[5237]:
> step.migration_fn(**kw)
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/migrations/versions/fdc58d9bd449_.py",
> line 43, in upgrade
> Jan 23 08:25:36 localhost.localdomain python3[5237]: email, password =
> user_info()
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/setup/user_info.py",
> line 55, in user_info
> Jan 23 08:25:36 localhost.localdomain python3[5237]: email =
> input("Email address: ")
> Jan 23 08:25:36 localhost.localdomain python3[5237]: EOFError: EOF when
> reading a line
> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service: Main
> process exited, code=exited, status=1/FAILURE
> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service: Failed
> with result 'exit-code'.
>
> --
>
> * can you please assist?*
>
>
> Regards
> --
>
> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
> 
>
>
>
> [image: cid:image001.jpg@01C922E1.F264D450]
>
>
>
> “*Intellectual growth should commence at birth and cease only at death*”
> - Albert Einstein
>
>
>


-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

pgAdmin 4 commit: Fixed an issue while editing char[] or character vary

[Akshay Joshi]

Fixed an issue while editing char[] or character varying[] column from 
View/Edit data throwing an error.Fixes #4410.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=f5d46bf9f1505f5570aa3e413933c105ce7b33a4
Author: Nick Barnes 

Modified Files
--
docs/en_US/release_notes_4_18.rst   | 1 +
web/pgadmin/tools/sqleditor/__init__.py | 2 +-
2 files changed, 2 insertions(+), 1 deletion(-)

Re: pgadmin 4 wont start on redhat 8

[Aditya Toshniwal]

Hi Andre,

Could you please share the contents of the pgadmin4.service file ?

On Thu, Jan 23, 2020 at 2:49 PM Andre Steyn  wrote:

> no does not give me that option, when i start the service, i get that
> error i mailed
>
> On Thu, Jan 23, 2020 at 11:04 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Andre,
>>
>> Are you typing "Email address:" value or pasting ? Try typing manually.
>>
>> On Thu, Jan 23, 2020 at 1:09 PM Andre Steyn  wrote:
>>
>>> I get these messages each time i startup, i have removed and
>>> re-installed, but get the same issues
>>>
>>> [root@localhost ~]# systemctl status pgadmin4.service
>>> ● pgadmin4.service - pgAdmin4 Server Mode
>>>Loaded: loaded (/usr/lib/systemd/system/pgadmin4.service; enabled;
>>> vendor preset: disabled)
>>>Active: failed (Result: exit-code) since Thu 2020-01-23 08:25:36
>>> SAST; 1h 14min ago
>>>  Docs: https://www.pgadmin.org/docs/
>>>  Main PID: 5237 (code=exited, status=1/FAILURE)
>>>
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:
>>> self.get_context().run_migrations(**kw)
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 362,
>>> in run_migrations
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:
>>> step.migration_fn(**kw)
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/pgadmin4-web/migrations/versions/fdc58d9bd449_.py",
>>> line 43, in upgrade
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: email, password
>>> = user_info()
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/setup/user_info.py",
>>> line 55, in user_info
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: email =
>>> input("Email address: ")
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: EOFError: EOF when
>>> reading a line
>>> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service: Main
>>> process exited, code=exited, status=1/FAILURE
>>> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service:
>>> Failed with result 'exit-code'.
>>>
>>> --
>>>
>>> * can you please assist?*
>>>
>>>
>>> Regards
>>> --
>>>
>>> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
>>> 
>>>
>>>
>>>
>>> [image: cid:image001.jpg@01C922E1.F264D450]
>>>
>>>
>>>
>>> “*Intellectual growth should commence at birth and cease only at death*”
>>> - Albert Einstein
>>>
>>>
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
>
>
>
> Regards
> --
>
> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
> 
>
>
>
> [image: cid:image001.jpg@01C922E1.F264D450]
>
>
>
> “*Intellectual growth should commence at birth and cease only at death*”
> - Albert Einstein
>
>
>


-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Re: Error when editing char(n)[] cells

[Akshay Joshi]

Thanks, patch applied.

On Tue, Jan 21, 2020 at 6:55 PM Nick Barnes  wrote:

> Hi,
>
> In the "View/Edit Data" grid, editing a char(n)[] or varchar(n)[] cell
> triggers a psycopg error: "argument formats can't be mixed". This seems
> to be the same issue reported in #4410
> .
>
> Looks like the cause is a format() template which is using "%s" instead of
> "{}", leaving a literal "%s" in the generated SQL. Patch attached.
>
> Cheers,
> Nick
>


-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*

Re: pgadmin 4 wont start on redhat 8

[Aditya Toshniwal]

Hi Andre,

There's a file for the service -
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/configuring_basic_system_settings/managing-services-with-systemd_configuring-basic-system-settings
Could you please let us know the installation steps you followed ?

On Thu, Jan 23, 2020 at 3:17 PM Andre Steyn  wrote:

> pgadmin4.service is the service running on redhat 8, not a file
>
>
> On Thu, Jan 23, 2020 at 11:26 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Andre,
>>
>> Could you please share the contents of the pgadmin4.service file ?
>>
>> On Thu, Jan 23, 2020 at 2:49 PM Andre Steyn  wrote:
>>
>>> no does not give me that option, when i start the service, i get that
>>> error i mailed
>>>
>>> On Thu, Jan 23, 2020 at 11:04 AM Aditya Toshniwal <
>>> aditya.toshni...@enterprisedb.com> wrote:
>>>
 Hi Andre,

 Are you typing "Email address:" value or pasting ? Try typing manually.

 On Thu, Jan 23, 2020 at 1:09 PM Andre Steyn  wrote:

> I get these messages each time i startup, i have removed and
> re-installed, but get the same issues
>
> [root@localhost ~]# systemctl status pgadmin4.service
> ● pgadmin4.service - pgAdmin4 Server Mode
>Loaded: loaded (/usr/lib/systemd/system/pgadmin4.service; enabled;
> vendor preset: disabled)
>Active: failed (Result: exit-code) since Thu 2020-01-23 08:25:36
> SAST; 1h 14min ago
>  Docs: https://www.pgadmin.org/docs/
>  Main PID: 5237 (code=exited, status=1/FAILURE)
>
> Jan 23 08:25:36 localhost.localdomain python3[5237]:
> self.get_context().run_migrations(**kw)
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 362,
> in run_migrations
> Jan 23 08:25:36 localhost.localdomain python3[5237]:
> step.migration_fn(**kw)
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/migrations/versions/fdc58d9bd449_.py",
> line 43, in upgrade
> Jan 23 08:25:36 localhost.localdomain python3[5237]: email,
> password = user_info()
> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/setup/user_info.py",
> line 55, in user_info
> Jan 23 08:25:36 localhost.localdomain python3[5237]: email =
> input("Email address: ")
> Jan 23 08:25:36 localhost.localdomain python3[5237]: EOFError: EOF
> when reading a line
> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service:
> Main process exited, code=exited, status=1/FAILURE
> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service:
> Failed with result 'exit-code'.
>
> --
>
> * can you please assist?*
>
>
> Regards
> --
>
> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
> 
>
>
>
> [image: cid:image001.jpg@01C922E1.F264D450]
>
>
>
> “*Intellectual growth should commence at birth and cease only at
> death*” - Albert Einstein
>
>
>


 --
 Thanks and Regards,
 Aditya Toshniwal
 pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
 "Don't Complain about Heat, Plant a TREE"

>>>
>>>
>>> --
>>>
>>>
>>>
>>> Regards
>>> --
>>>
>>> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
>>> 
>>>
>>>
>>>
>>> [image: cid:image001.jpg@01C922E1.F264D450]
>>>
>>>
>>>
>>> “*Intellectual growth should commence at birth and cease only at death*”
>>> - Albert Einstein
>>>
>>>
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
>
>
>
> Regards
> --
>
> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
> 
>
>
>
> [image: cid:image001.jpg@01C922E1.F264D450]
>
>
>
> “*Intellectual growth should commence at birth and cease only at death*”
> - Albert Einstein
>
>
>


-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Re: pgadmin 4 wont start on redhat 8

[Aditya Toshniwal]

[Kindly use reply all]

Hi Andre,

Seems like your initial setup is not run for pgAdmin. Try below:
1) Stop pgAdmin service if running.
2) On a terminal, run - /usr/bin/python3
/usr/lib/python3.6/site-packages/pgadmin4-web/setup.py
3) You should be prompted for email and password.
4) After it is complete, start the pgAdmin service.

On Thu, Jan 23, 2020 at 5:07 PM Andre Steyn  wrote:

> Ok, thank you, here is a cut and paste
>
> [root@localhost system]# more pgadmin4.service
> # It's not recommended to modify this file in-place, because it will be
> # overwritten during package upgrades.  If you want to customize, the
> # best way is to create a file "/etc/systemd/system/pgadmin4.service",
> # containing
> # .include /usr/lib/systemd/system/pgadmin4.service
> # ...make your changes here...
> # For more info about custom unit files, see
> #
> http://fedoraproject.org/wiki/Systemd#How_do_I_customize_a_unit_file.2F_add_a_custom_unit_file.3F
>
> [Unit]
> Description=pgAdmin4 Server Mode
> Documentation=https://www.pgadmin.org/docs/
> After=network.target
>
> [Service]
> Type=simple
> ExecStart=/usr/bin/python3
> /usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py
> ExecReload=/bin/kill -HUP $MAINPID
> KillMode=mixed
> KillSignal=SIGINT
>
> [Install]
> WantedBy=multi-user.target
>
>
> On Thu, Jan 23, 2020 at 12:32 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Andre,
>>
>> There's a file for the service -
>> https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/configuring_basic_system_settings/managing-services-with-systemd_configuring-basic-system-settings
>> Could you please let us know the installation steps you followed ?
>>
>> On Thu, Jan 23, 2020 at 3:17 PM Andre Steyn  wrote:
>>
>>> pgadmin4.service is the service running on redhat 8, not a file
>>>
>>>
>>> On Thu, Jan 23, 2020 at 11:26 AM Aditya Toshniwal <
>>> aditya.toshni...@enterprisedb.com> wrote:
>>>
 Hi Andre,

 Could you please share the contents of the pgadmin4.service file ?

 On Thu, Jan 23, 2020 at 2:49 PM Andre Steyn  wrote:

> no does not give me that option, when i start the service, i get that
> error i mailed
>
> On Thu, Jan 23, 2020 at 11:04 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Andre,
>>
>> Are you typing "Email address:" value or pasting ? Try typing
>> manually.
>>
>> On Thu, Jan 23, 2020 at 1:09 PM Andre Steyn 
>> wrote:
>>
>>> I get these messages each time i startup, i have removed and
>>> re-installed, but get the same issues
>>>
>>> [root@localhost ~]# systemctl status pgadmin4.service
>>> ● pgadmin4.service - pgAdmin4 Server Mode
>>>Loaded: loaded (/usr/lib/systemd/system/pgadmin4.service;
>>> enabled; vendor preset: disabled)
>>>Active: failed (Result: exit-code) since Thu 2020-01-23 08:25:36
>>> SAST; 1h 14min ago
>>>  Docs: https://www.pgadmin.org/docs/
>>>  Main PID: 5237 (code=exited, status=1/FAILURE)
>>>
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:
>>> self.get_context().run_migrations(**kw)
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 
>>> 362,
>>> in run_migrations
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:
>>> step.migration_fn(**kw)
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/pgadmin4-web/migrations/versions/fdc58d9bd449_.py",
>>> line 43, in upgrade
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: email,
>>> password = user_info()
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]:   File
>>> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/setup/user_info.py",
>>> line 55, in user_info
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: email =
>>> input("Email address: ")
>>> Jan 23 08:25:36 localhost.localdomain python3[5237]: EOFError: EOF
>>> when reading a line
>>> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service:
>>> Main process exited, code=exited, status=1/FAILURE
>>> Jan 23 08:25:36 localhost.localdomain systemd[1]: pgadmin4.service:
>>> Failed with result 'exit-code'.
>>>
>>> --
>>>
>>> * can you please assist?*
>>>
>>>
>>> Regards
>>> --
>>>
>>> *Andre Steyn *| NTR | Email:  mailto:tuddy...@gmail.com
>>> 
>>>
>>>
>>>
>>> [image: cid:image001.jpg@01C922E1.F264D450]
>>>
>>>
>>>
>>> “*Intellectual growth should commence at birth and cease only at
>>> death*” - Albert Einstein
>>>
>>>
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>> 

pgAdmin 4 commit: Added support for a multi-level partitioned table. Fi

[Akshay Joshi]

Added support for a multi-level partitioned table. Fixes #2554.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=198063f046f16aaee9f8654a79863f188abd85e1

Modified Files
--
docs/en_US/images/table_partition.png  | Bin 253015 -> 233286 bytes
docs/en_US/images/table_partition_tree.png | Bin 0 -> 35385 bytes
docs/en_US/release_notes_4_18.rst  |   1 +
docs/en_US/table_dialog.rst|  17 ++
.../schemas/tables/base_partition_table.py |   9 +-
.../schemas/tables/partitions/__init__.py  |  23 ++-
.../partitions/static/img/coll-partition.svg   |  36 +++-
.../partitions/static/img/partition_table.svg  |  23 +++
.../partitions/static/img/sub_partition_table.svg  |  29 
.../tables/partitions/static/js/partition.js   |   6 +-
.../templates/partitions/css/partition.css |  36 
.../schemas/tables/static/js/partition.utils.js| 190 +
.../databases/schemas/tables/static/js/table.js|   2 +-
.../templates/partitions/sql/pg/10_plus/nodes.sql  |   4 +-
.../partitions/sql/ppas/10_plus/nodes.sql  |   4 +-
.../tables/tests/test_base_partition_table.py  |   4 +-
.../schemas/tables/tests/test_table_add.py |  83 -
.../schemas/tables/tests/test_table_put.py |  16 ++
.../databases/schemas/tables/tests/utils.py| 163 ++
.../servers/databases/schemas/tables/utils.py  |  35 ++--
20 files changed, 605 insertions(+), 76 deletions(-)

pgAdmin 4 commit: Default tablespace should not be visible for the mult

[Akshay Joshi]

Default tablespace should not be visible for the multi-level partitioned table 
on PG 12

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4faf14b45ff4878b7fcb1c98235f22c7756a14a7

Modified Files
--
.../schemas/tables/templates/partitions/sql/pg/12_plus/properties.sql   | 2 +-
.../schemas/tables/templates/partitions/sql/ppas/12_plus/properties.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)