I am running Ubuntu bionic with the additional repository:
pgadmin3 was updated to version 1.22.2-6.pgdg18.04+1 when I ran updates today. Now I cannot open the essential SQL editor any more. I see a black-and-white wireframe for a second or two, then the program terminates. The program is now useless for me.
The log file for pgAdmin 3 ends with:
...
QUERY : 16:32:19: Scalar query (:5432): SELECT version();
QUERY : 16:32:19: Query result: PostgreSQL 11.6 (Ubuntu 11.6-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit
QUERY : 16:32:19: Set query (:5432): SET DateStyle=ISO;
SET client_min_messages=notice;
SET bytea_output=escape;
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 16385
SCRIPT : 16:32:19: Application created
/var/log/syslog seems revealing:
Jan 8 16:32:19 A-N-W-030 pgadmin3[4674]: The window 0x56464b1d84d0 already has a drawing context. You cannot call gdk_window_begin_draw_frame() without calling gdk_window_end_draw_frame() first.
Jan 8 16:32:19 A-N-W-030 kernel: [ 3812.954406] pgadmin3[4674]: segfault at 4 ip 00007f40917a21a0 sp 00007ffcb697bc58 error 4 in libcairo.so.2.11510.0[7f4091782000+118000]
Jan 8 16:32:19 A-N-W-030 pgadmin3[4674]: gdk_drawing_context_get_cairo_context: assertion 'GDK_IS_DRAWING_CONTEXT (context)' failed
Any way to fix? Or get the previous version? I tried:
sudo apt-get install pgadmin3=1.22.2-5
But only get the error:
> E: Version '1.22.2-5' for 'pgadmin3' was not found
Regards
Erwin