SQL command to stop job in pgAdmin 4

Beachwalker picture Beachwalker · Nov 18, 2016 · Viewed 9.6k times · Source

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

Beachwalker picture Beachwalker · Nov 18, 2016

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