Beachwalker Beachwalker - 14 days ago 11
SQL Question

SQL command to stop job in pgAdmin 4

I have a Postgres 9.6 installation on a developer pc and a restore seems to have failed. Even after reinstalling (remove Postgres and PgAdmin completely, incl. database and installed new version) the boxes are popping up (even though these tables do not even exist anymore). How to remove these scheduled jobs? Is there an SQL statement to stop these?

enter image description here

Answer

Found solution: This problem is related to the pgadmin.db. Just remove the file and the error is gone (but you also have to reenter all passwords etc.). The problem is that this file is not removed when uninstalling postgres/pgadmin. It can be found in

C:\Users\YourUsername\AppData\Roaming\pgAdmin