Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427

and then delete it. - Restart the pgAdmin4 Thanks,Khushboo On Sat, Nov 7, 2020 at 1:12 PM Nagaraj Raj wrote: any suggestions? On Friday, November 6, 2020, 12:22:44 PM PST, Nagaraj Raj wrote: I'm not able to start pgadmin4 server mode after after upgrade, it

Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427

any suggestions? On Friday, November 6, 2020, 12:22:44 PM PST, Nagaraj Raj wrote: I'm not able to start pgadmin4 server mode after after upgrade, it throwing the error "qlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: hostaddr"

qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427

I'm not able to start pgadmin4 server mode after after upgrade, it throwing the error "qlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: hostaddr" [root@dev-e2 ~]#  systemctl status pgadmin4 ● pgadmin4.service - pgAdmin4 Server Mode    Loaded: loaded (/usr/lib/sy

pgAdmin is not redirecting to /browser

Hello, for the first time, I was installed pgAdmin4 on RedHat server with apache httpd web server.  when I launch the application and run url https://localhost/pgadmin4, it loading login page and when I entered valid credentials it taking me to https://localhost or apache test page instead of

wsgi:error AttributeError: module 'pkg_resources' has no attribute 'resource_filename'

Hella, I'm trying to install pgAdmin on Redhat and end up with below error, Wed May 06 00:53:35.157756 2020] [wsgi:error] [pid 6973] mod_wsgi (pid=6973): Failed to exec Python script file '/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.wsgi'. [Wed May 06 00:53:35.157820 2020] [wsgi:erro

Re: pgAdmin is freezing

Yes, its same for all objects in the database. Thanks,Rj Sent from Yahoo Mail for iPhone On Sunday, April 19, 2020, 8:01 PM, Khushboo Vashi wrote: Hi, On Sat, Apr 18, 2020 at 1:41 AM Nagaraj Raj wrote: Hi, pgAdmin is freezing for other activities when dropping any table or index if

pgAdmin is freezing

Hi, pgAdmin is freezing for other activities when dropping any table or index if command is held because of any lock occurring. In this state unable to access any other objects like stats, SQL statements, descriptions or query tool for other objects. pgAdmin resume to start working fine after ei

Re: DB running out of memory issues after upgrade

288)""              Filter: (((data -> 'info'::text) ->> 'status'::text) = 'CLOSE'::text)" Thanks, On Tuesday, February 18, 2020, 09:59:37 AM PST, Tomas Vondra wrote: On Tue, Feb 18, 2020 at 05:46:28PM +, Nagaraj Raj wrote: >af

invalid literal for int() with base 10: 'None'

Throwing an error " invalid literal for int() with base 10: 'None'" while trying to connect DB in latest version pgAdmin  Version4.16 2020-01-07 10:00:29,870: ERROR flask.app: invalid literal for int() with base 10: 'None' Traceback (most recent call last): File "/Applications/pgAdmin 4.app/

Re: PostgreSQL - Query Tool Error

Hi, I have also faced the same kind of situation a couple of times, and It got solved it by doing necessary troubleshooting steps as below, 1. Stop the pgAdmin completely.2. Clear all caches&cookies of the web browser.3. Start the pgAdmin and lunch the query tool. And are you using the latest v

Re: SSL SYSCALL error: Undefined error: 0

quot;, line 371, in dashboard_stats for chart_row in res['rows']: TypeError: string indices must be integers 2019-09-27 14:53:19,152: ERROR flask.app: Failed to execute query (execute_dict) for the server #2- DB:ohl (Query-id: 8844676): Error Message:SSL SYSCALL error: Undefined err

Re: SSL SYSCALL error: Undefined error: 0

tgres runs out of memory while performing complex query. Did you checked DB server side logs? On Sat, 28 Sep 2019, 03:21 Nagaraj Raj, wrote: Hello, I have upgraded pgAdmin to latest version 4.13. Some times it's behaving abnormally and throwing below error, Error retrieving details for the

SSL SYSCALL error: Undefined error: 0

Hello, I have upgraded pgAdmin to latest version 4.13. Some times it's behaving abnormally and throwing below error, Error retrieving details for the node  SSL SYSCALL error: Undefined error: 0 Thanks,Naga 

Re: "can only concatenate str (not "NoneType") to str"

Thank you and appreciated for your response.  Best regards,NagarajuOn Tuesday, September 17, 2019, 08:19:09 PM PDT, Khushboo Vashi wrote: Hi, On Wed, Sep 18, 2019 at 4:58 AM Nagaraj Raj wrote: Hi, I'm currently using pgAdmin-4(Version 4.12). When I try to view object

"can only concatenate str (not "NoneType") to str"

Hi, I'm currently using pgAdmin-4(Version 4.12). When I try to view objects SQL statements, getting an INTERNAL SERVER ERROR with below expectation "can only concatenate str (not "NoneType") to str" Please find attached screenshot. Thank you! Regards,Naga

Re: pgadmin4 configuration with no passwords?

Hi Tom, Yes, you can use password less login through pgAdmin. In pg_hba.conf file add, host  all   all   trust. Thanks.Naga Sent from Yahoo Mail for iPhone On Thursday, May 9, 2019, 4:33 PM, Tom Browder wrote: I want to start playing with pgadmin4 on my local host (single user) with no pass