英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论