FS#62481 - pgadmin4 - unable to connect to local postgresql database
Attached to Project:
Arch Linux
Opened by Grzegorz Krukar (gkrukar) - Friday, 26 April 2019, 20:17 GMT
Last edited by Levente Polyak (anthraxx) - Wednesday, 22 May 2019, 13:43 GMT
Opened by Grzegorz Krukar (gkrukar) - Friday, 26 April 2019, 20:17 GMT
Last edited by Levente Polyak (anthraxx) - Wednesday, 22 May 2019, 13:43 GMT
|
Details
Description:
Using current versions postgresql 11.2-3 pgadmin4 4.4-1 1. Create -> Server 2. Set name, host, username, password 3. Unable to see created server connection https://stackoverflow.com/questions/558 … onnections pgadmin log AttributeError: 'psycopg2.extensions.Column' object has no attribute '_asdict' 127.0.0.1 - - [26/Apr/2019 21:56:47] "GET /browser/server_group/children/1 HTTP/1.1" 500 - 2019-04-26 21:56:47,670: ERROR flask.app: 'psycopg2.extensions.Column' object has no attribute '_asdict' Traceback (most recent call last): File "/usr/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "/usr/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/usr/lib/python3.7/site-packages/flask/views.py", line 88, in view return self.dispatch_request(*args, **kwargs) File "/usr/lib/pgadmin4/web/pgadmin/browser/utils.py", line 259, in dispatch_request return method(*args, **kwargs) File "/usr/lib/pgadmin4/web/pgadmin/browser/utils.py", line 309, in children children.extend(module.get_nodes(*args, **kwargs)) File "/usr/lib/pgadmin4/web/pgadmin/browser/server_groups/servers/__init__.py", line 127, in get_nodes in_recovery, wal_paused = recovery_state(conn, manager.version) File "/usr/lib/pgadmin4/web/pgadmin/browser/server_groups/servers/__init__.py", line 52, in recovery_state status, result = connection.execute_dict(recovery_check_sql) File "/usr/lib/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py", line 1202, in execute_dict desc.to_dict() for desc in cur.ordered_description() File "/usr/lib/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py", line 1202, in <listcomp> desc.to_dict() for desc in cur.ordered_description() File "/usr/lib/pgadmin4/web/pgadmin/utils/driver/psycopg2/cursor.py", line 94, in to_dict ores = OrderedDict(self.orig_col._asdict()) AttributeError: 'psycopg2.extensions.Column' object has no attribute '_asdict' 127.0.0.1 - - [26/Apr/2019 21:56:47] "GET /browser/server_group/children/1 HTTP/1.1" 500 - |
This task depends upon
Closed by Levente Polyak (anthraxx)
Wednesday, 22 May 2019, 13:43 GMT
Reason for closing: Fixed
Additional comments about closing: pgadmin4-4.6-1
Wednesday, 22 May 2019, 13:43 GMT
Reason for closing: Fixed
Additional comments about closing: pgadmin4-4.6-1
Do now work with current arch repository version of psycopg2 and pgadmin4
pgadmin4 is flagged out of date the issue should be resolved when the package is updated to the 4.5 release.