SQL command to stop job in pgAdmin 4

10,250

Solution 1

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

Solution 2

another solution is to open the file pgadmin.db with SQLite Manager (A firefox extension) and remove all rows in the table process

Share:
10,250
Beachwalker
Author by

Beachwalker

There is nothing special about me. I am just doing the usual things like slaying dragons and saving the world in my daily business as anyone else does, too.

Updated on June 08, 2022

Comments

  • Beachwalker
    Beachwalker almost 2 years

    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