# Bug OP-11592 - Centos7 fails with "undefined symbol: PQconninfo" due to outdated postgresql-libs shared library

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-11592

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 12.4.1 |
| Observed in versions |  |
| Sprint | 12.4.1 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee | Oliver Günther |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

_Please write down the steps to reproduce. Try to write down all necessary preconditions (what permissions do you have, are other users involved?). Example:_

1.  Install recent OpenProject package on centos7
2.  Choose existing database installation in wizard

### What is the buggy behavior?

_Please describe the bug with as most details as possible. Example:_

*   When trying to connect to the database, this error happens:

`/opt/openproject/vendor/bundle/ruby/3.1.0/bin/rake db:migrate db:seed packager:postinstall: symbol lookup error: /opt/openproject/vendor/bundle/ruby/3.1.0/gems/pg-1.4.3/lib/pg_ext.so: undefined symbol: PQconninfo`

###   

### Known workaround

  

The installed postgres-libs is too old for OpenProject. You need to install a newer version:

  

  
1\. Add the package source for PostgreSQL (the exact URL might differ, double check https://www.postgresql.org/download/linux/redhat/)  
  
yum install -y [https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86\_64/pgdg-redhat-repo-latest.noarch.rpm](https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm)  
  
2\. Install postgresql13-libs  
  
`yum install postgresql13-libs`
