packaged pg-activity not running on ubuntu 20.04 about pg_activity HOT 4 CLOSED

@b0n0r A workaround is to update humanize package, which is outdated in Debian Buster (and derived distributions):

python3 -m pip install -U humanize

from pg_activity.

That's a problem in the Debian packaging, nothing we can do on our side.

from pg_activity.

after updte humanize that error ocurred:
postgres@xxxxxxx:~$ pg_activity

Traceback (most recent call last):
File "/usr/bin/pg_activity", line 11, in
load_entry_point('pg-activity==3.0.1', 'console_scripts', 'pg_activity')()
File "/usr/lib/python3/dist-packages/pgactivity/cli.py", line 407, in main
ui.main(term, dataobj, host, args)
File "/usr/lib/python3/dist-packages/pgactivity/ui.py", line 205, in main
pg_procs.set_items(data.pg_get_activities(ui.duration_mode))
File "/usr/lib/python3/dist-packages/pgactivity/data.py", line 438, in pg_get_activities
"dbname_filter": self.filters.dbname,
File "/var/lib/postgresql/.local/lib/python3.6/site-packages/psycopg2/extras.py", line 146, in execute
return super().execute(query, vars)
psycopg2.errors.SyntaxError: syntax error at or near ""
LINE 16: convert_from(replace(a.query, '', '\')::bytea, coale...
^

from pg_activity.

psycopg2.errors.SyntaxError: syntax error at or near ""
LINE 16: convert_from(replace(a.query, '', '')::bytea, coale...

This particular problem got resolved in a later release (3.1.0) of pg_activity. Unfortunately, it's not available in Debian/Ubuntu (yet).

from pg_activity.