错误删除/移除服务器组:“test”在pgAdmin中

huangapple go评论65阅读模式
英文:

error dropping/removing server group: "test" in pgAdmin

问题

我刚刚在家里的电脑上安装了PostgreSQL,以尝试创建一个数据库。我按照安装程序的提示一路点击“是”,但没有选择安装堆栈生成器,因为我不想安装任何附加组件,只打算快速创建一个数据库。但不知何故,安装完成后,我在“服务器”服务器组中没有看到任何内容,而我在教程中跟随的人在那里已经有一个数据库。我也无法添加任何内容,所以我决定在pgAdmin中创建一个新的服务器组(这是我唯一被允许点击的选项),所以我将其命名为“test”。在尝试之后,我仍然无法添加内容,所以我尝试删除它,但现在我收到了这个错误(版本15.2-1-windows)(pgAdmin 4)

我尝试右键单击它,然后点击“删除服务器组”,希望它会被删除,但它没有被删除。

英文:

So I just installed postgresSQL on my home computer to try and make a database, I followed the installed by clicking basically yes on everything but unselected stack builder since I don't wanna install any addons and just plan to make a quick database. But whenever it installed for some reason I didn't have anything already in the Server Group "Servers" whilst the person in the tutorial I followed had a database in there https://www.youtube.com/watch?v=0n41UTkOBb0. I also couldn't add anything in it so I decided to make a new Server Group in pgAdmin (the only option I was allowed to click) and so I named it "test" after trying there I also couldn't add stuff so I tried to delete it, however now I got this error (version 15.2-1-windows) (pgAdmin 4)

(sqlite3.OperationalError) no such column: server.hostaddr [SQL: SELECT server.id AS server_id, server.user_id AS server_user_id, server.servergroup_id AS server_servergroup_id, server.name AS server_name, server.host AS server_host, server.hostaddr AS server_hostaddr, server.port AS server_port, server.maintenance_db AS server_maintenance_db, server.username AS server_username, server.password AS server_password, server.save_password AS server_save_password, server.role AS server_role, server.ssl_mode AS server_ssl_mode, server.comment AS server_comment, server.discovery_id AS server_discovery_id, server.db_res AS server_db_res, server.passfile AS server_passfile, server.passexec_cmd AS server_passexec_cmd, server.passexec_expiration AS server_passexec_expiration, server.sslcert AS server_sslcert, server.sslkey AS server_sslkey, server.sslrootcert AS server_sslrootcert, server.sslcrl AS server_sslcrl, server.sslcompression AS server_sslcompression, server.bgcolor AS server_bgcolor, server.fgcolor AS server_fgcolor, server.service AS server_service, server.connect_timeout AS server_connect_timeout, server.use_ssh_tunnel AS server_use_ssh_tunnel, server.tunnel_host AS server_tunnel_host, server.tunnel_port AS server_tunnel_port, server.tunnel_username AS server_tunnel_username, server.tunnel_authentication AS server_tunnel_authentication, server.tunnel_identity_file AS server_tunnel_identity_file, server.tunnel_password AS server_tunnel_password, server.shared AS server_shared, server.kerberos_conn AS server_kerberos_conn, server.cloud_status AS server_cloud_status, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name FROM server LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = server.servergroup_id WHERE server.servergroup_id = ? AND server.shared = 1] [parameters: (2,)] (Background on this error at: https://sqlalche.me/e/14/e3q8)

I tried to right click it and clicked Remove Server Group and expected it to get removed but it didn't

答案1

得分: 3

我遇到了相同的问题,在pgAdmin 4中无法删除的两个服务器组。我找到的唯一解决方法是删除pgAdmin的数据。

警告:这将删除所有保存服务器的配置。

转到帮助 -> 关于pgAdmin4,在服务器配置窗口中查找变量DATA_DIR。进入那里并删除文件pgadmin.db

再次强调,如果你关心pgAdmin的配置,你可能需要深入了解后果。我并不在乎,所以我只是删除了。

英文:

I had the same problem, two Server Groups that I couldn't delete in pgAdmin 4.
The only solution I found was to delete the pgAdmin's data.

WARNING: this will delete all the configurations of saved servers.

Go to Help -> About pgAdmin4, look for the variable DATA_DIR in the server configuration window. Go there and delete the file pgadmin.db.

Again, if you care about your pgAdmin configuration, you might want to dig deeper on the consequences. I didn't care and I just deleted.

huangapple
  • 本文由 发表于 2023年3月7日 14:22:48
  • 转载请务必保留本文链接:https://go.coder-hub.com/75658605.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定