TASK [postgres : Install postgresql] -"No package matching 'postgresql96-server.x86_64' found available, installed or updated

TASK [postgres : Install postgresql] ************************************************************************************************************************************************** task path: /opt/bahmni-installer/bahmni-playbooks/roles/postgres/tasks/main.yml:15 fatal: [localhost]: FAILED! => {“changed”: false, “failed”: true, “msg”: “No package matching ‘postgresql96-server.x86_64’ found available, installed or updated”, “rc”: 126, “results”: [“No package matching ‘postgresql96-server.x86_64’ found available, installed or updated”]} to retry, use: --limit @/opt/bahmni-installer/bahmni-playbooks/all.retry

PLAY RECAP **************************************************************************************************************************************************************************** localhost : ok=14 changed=0 unreachable=0 failed=1

Traceback (most recent call last): File “/usr/bin/bahmni”, line 9, in load_entry_point(‘bahmni==0.1’, ‘console_scripts’, ‘bahmni’)() File “/usr/lib64/python2.7/site-packages/click/core.py”, line 764, in call return self.main(*args, **kwargs) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 717, in main rv = self.invoke(ctx) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File “/usr/lib64/python2.7/site-packages/click/core.py”, line 555, in invoke return callback(*args, **kwargs) File “/usr/lib64/python2.7/site-packages/click/decorators.py”, line 17, in new_func return f(get_current_context(), *args, **kwargs) File “build/bdist.linux-x86_64/egg/bahmni.py”, line 90, in install File “/usr/lib64/python2.7/subprocess.py”, line 542, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command ‘ansible-playbook -i /etc/bahmni-installer/local all.yml -vv --extra-vars ‘@/etc/bahmni-installer/rpm_versions.yml’ --extra-vars ‘@/etc/bahmni-backrest.conf’ --extra-vars ‘@/etc/bahmni-installer/setup.yml’ -t bahmni-lab’ returned non-zero exit status 2 [root@cjesolbuildvm opt]#

Download from https://repo.nrg.wustl.edu/postgres/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm

cd /opt

yum remove pgdg-redhat-repo

yum install pgdg-redhat96-9.6-3.noarch.rpm

yum install postgresql96 postgresql96-server postgresql96-contrib postgresql96-libs -y

1 Like

Postgres 9.6 support is removed from the rpm repos from 16th March 2022. See the screenshot below.

So, neither “pgdg-redhat-repo-latest.noarch.rpm” nor “pgdg-redhat-repo-42.0-24.noarch.rpm” will help us out to proceed with Postgres 9.6 installation.

We can update the code & use : “pgdg-redhat-repo-42.0-23.noarch.rpm” instead of pgdg-redhat-repo-latest.noarch.rpm

pgdg-redhat-repo-42.0-23.noarch.rpm version of rpm still support for Postgres 9.6.

you can refer this solution

@akhilantotharayil "pgdg-redhat-repo-latest.noarch.rpm" This repo has been updated on 16th March 2022. which has removed 9.6 support.

In screenshot, if you check “pgdg-redhat-repo-latest.noarch.rpm” this already getting installed & after that we are seeing this error.

Let me know, If I am wrong somewhere.

Please Manual download file and replace with /opt/pgdg-redhat-repo-latest.noarch.rpm

Then

yum remove -y pgdg*

yum remove -y postgress*

now fire the install

bahmni -i local install

BAH-1496 has been logged in JIRA for fixing this in Ansible bahmni installer.

1 Like

BAH-1496 has been completed successfully.

We can use the usual installation process (Ansible scripts) to complete the setup.

@dhananjayad Can you try installing it now?

1 Like

Yes, I was able to Install Thank you @mradul.jain

1 Like

@gsluthra was this updated in 0.93? I ran into the same issue mentioned above? I’m on Centos 7.6

@dmukungi This is fixed now. We have updated the document as well. https://bahmni.atlassian.net/wiki/spaces/BAH/pages/33128505/Install+Bahmni+on+CentOS

Please go to “Installing Bahmni version 0.93 (Recommended)” & follow the steps.

1 Like

Issue Still persists as pgdg-redhat-repo-42.0-23.noarch.rpm have been removed from yum repo.

The team is working on a fix for this. Please see: [BAH-2261] - Bahmni - JIRA

This has been fixed.

image

Still the issue persists. Tried a fresh bahmni installation today on my local machine, Bahmni installation failed at this step.

@gsluthra could you please check this…

Seems related to postges rpms not being available in default locations.

Meanwhile, can you try the docker install options as mentioned on this page. This will give you the latest version of Bahmni. See: https://bahmni.atlassian.net/wiki/spaces/BAH/pages/3117744129/Getting+Started+Quickly+with+Bahmni+on+Docker#Running-Bahmni-Standard

The issue around postgres installation step has been resolved and the Install steps are updated in the Wiki page. . Refer to this Talk thread for more information around the fix.

1 Like