在pgAdmin 4中停止作业的SQL命令 [英] SQL command to stop job in pgAdmin 4

问题描述

我在开发人员PC上安装了Postgres 9.6，还原似乎失败了。即使重新安装（完全删除Postgres和PgAdmin，包括数据库和已安装的新版本）之后，这些框也会弹出（即使这些表不再存在）。如何删除这些计划的工作？是否有SQL语句来阻止这些操作？

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?

推荐答案

找到的解决方案：此问题与 pgadmin.db 有关。只需删除文件，错误就消失了（但您还必须重新输入所有密码等）。问题在于，卸载postgres / pgadmin时不会删除此文件。可以在

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

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

这篇关于在pgAdmin 4中停止作业的SQL命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！