1

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 and cleanup the queue? Both jobs are running endless (3000000s+ already).

enter image description here

1
  • I tried this didn't work :/ . What else did you do? just uninstall, delete folder and reinstall ?
    – Rob
    Dec 30, 2016 at 19:39

2 Answers 2

4

The file

C:\Users...\AppData\Roaming\pgAdmin\pgadmin4.db

is an sqlite-database.

Open it (e.g. with https://sqlitebrowser.org/) and delete all rows in the process table. Then restart pgAdmin - the boxes should be gone.

1
  • I get an error: no such table: main.user_old
    – Kamrul
    Oct 6, 2021 at 6:28
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\\AppData\Roaming\pgAdmin

2
  • This doesnt make sense, Any new solution for this? I cant be deleting the file each time a restore fail. Feb 22, 2017 at 14:56
  • Well, it is a bug and it is Open Source. You could fix it or use command-line for this task instead. At least the above suggestion solves the problem if it occurs. Feb 22, 2017 at 18:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.