Problem deploying Postgresql
With clustercontrol latest version, i try to deploy a postgresql database side by side with a mariadb database. It says that an already postgresql node exists, which is false and it can not create the cluster. Why is that>?
[15:59:00]:Stopping installed cluster nodes after failed cluster creation.
[15:59:00]:<em style='color: #d35400;'>172.10.1.10</em>:5432: Failed to install software.
[15:59:00]:<em style='color: #d35400;'>172.10.1.10</em>: Package <strong style='color: #110679;'>postgresql[0-9]*</strong> is not installed.
[15:59:00]:<em style='color: #d35400;'>172.10.1.10</em>: Output
.
[15:59:00]:<em style='color: #d35400;'>172.10.1.10</em>: Command was <strong style='color: orange;'>rpm -qa --qf "%{VERSION} %{NAME}
" | grep postgresql[0-9]*</strong>.
[15:59:00]:<em style='color: #d35400;'>172.10.1.10</em>: Execution failed with return code 1.
[15:58:57]:<em style='color: #d35400;'>172.10.1.10</em>: Query installed version of <strong style='color: #110679;'>postgresql[0-9]*</strong>.
[15:58:57]:<em style='color: #d35400;'>172.10.1.10</em>:5432: There already is a postgresql node on this host. Lets detect its version.
[15:58:57]:Detected almalinux (stone smilodon 8.7).
[15:58:57]:Installing software.
[15:58:57]:Checking OS system tools.
[15:58:57]:<em style='color: #d35400;'>172.10.1.10</em>: Checking ssh/sudo with credentials <strong style='color: #59a449;'>ssh_cred_job_6656</strong>.
[15:58:57]:Checking SSH connectivity and sudo.
[15:58:57]:Checking that nodes are not in any other cluster.
[15:58:57]:Verifying nodes.
[15:58:57]:Found top level master node <em style='color: #d35400;'>172.10.1.10</em>:5432.
[15:58:56]:Checking/generating (expire 3650 days) server and CA certificate.
[15:58:56]:Checking job arguments.
[15:58:55]:<em style='color: #d35400;'>172.10.1.10</em>:5432: Checking if host already exists in another cluster.
[15:58:55]:<em style='color: #d35400;'>172.10.1.10</em>: Checking ssh/sudo with credentials <strong style='color: #59a449;'>ssh_cred_job_6656</strong>.
[15:58:55]:Verifying job parameters.
[15:58:55]:Cluster will be created on 1 data node(s).
[15:58:55]:CMON version <strong style='color: #59a449;'>1.9.6.6307</strong>.
Job spec:
{
"command": "create_cluster",
"job_data": {
"cluster_name": "Test PostgreSQL",
"cluster_type": "postgresql_single",
"company_id": null,
"db_password": "<password>",
"db_user": "root",
"disable_firewall": true,
"disable_selinux": true,
"generate_token": true,
"install_software": true,
"port": "5432",
"ssh_keyfile": "/root/.ssh/id_rsa",
"ssh_port": "22",
"ssh_user": "root",
"sudo_password": "",
"user_id": 5,
"vendor": "default",
"version": "14",
"nodes": [
{
"hostname": "172.10.1.10",
"hostname_data": "172.10.1.10",
"hostname_internal": "",
"port": "5432"
}
],
"with_tags": []
}
}
-
Official comment
Hi,
Can you please open a ticket with us and include the output of 'ps aux' executed on 172.10.1.10? Please also check if there is a PostgreSQL data directory. We need to take a look why ClusterControl assumes there is a PostgreSQL installed on that node.
Comment actions -
Hello.
I think i found the issue. I have a docker container that runs postgresql. When i try to deploy postgresql (not docker based) via clustercontrol, it finds the postgresql service that it is running, although this service is being run from a docker container. That's why the deployment fails.
I don't know if there is a workaround to deploy postgresql to the VM host via clustercontrol while the same VM has a docker container that runs postgresql too.
Please sign in to leave a comment.
Comments
2 comments