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
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To No-one
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 4
Private No

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
Comment by Grzegorz Krukar (gkrukar) - Friday, 26 April 2019, 20:27 GMT
Works after downgrading python-psycopg2 to 2.7 via pip

Do now work with current arch repository version of psycopg2 and pgadmin4
Comment by loqs (loqs) - Friday, 26 April 2019, 21:17 GMT
https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=commit;h=c21ea3c3423142410b7b8f43e0e6a6515516d865
pgadmin4 is flagged out of date the issue should be resolved when the package is updated to the 4.5 release.

Loading...