# Postgresql 9.2 to 9.6

**URL:** <https://community.zammad.org/t/postgresql-9-2-to-9-6/8859>\
**Category:** Technical assistance\
**Created:** [March 14, 2022, 1:55pm UTC](https://community.zammad.org/t/postgresql-9-2-to-9-6/8859 "2022-03-14T13:55:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mehrshid](https://community.zammad.org/user_avatar/community.zammad.org/mehrshid/32/418_2.png) [@mehrshid](https://community.zammad.org/u/mehrshid)\
**Post date:** [March 14, 2022, 1:55pm UTC](https://community.zammad.org/t/postgresql-9-2-to-9-6/8859/1 "2022-03-14T13:55:17Z")

</div>

- Used Zammad version: 4.x
- Used Zammad installation type: (source, package, docker-compose, …)
- Operating system: Centos 7  
I upgraded PostgreSQL from 9.2 to 9.6  
Because of dependency of zammad to PostgreSQL , I removed the old PostgreSQL via following command  
rpm -e --nodeps “postgresql-server-9.2.18-1.el7.x86\_64”  
rpm -e --nodeps “postgresql-libs-9.2.18-1.el7.x86\_64”  
rpm -e --nodeps “postgresql-9.2.18-1.el7.x86\_64”

Already postgresql9.6 installed and running  
But 500: We’re sorry, but something went wrong happened.  
What i see in Production;log is

I, [2022-03-14T09:20:40.346646 #23097-70151622171040] INFO – : Scheduler started.  
E, [2022-03-14T09:20:40.385134 #23097-70151622171040] ERROR – : Can’t reconnect to database #\<ActiveRecord::NoDatabaseError: FATAL: role “zammad” does not exist

Note : before start i got a full backup via  
pg\_dumpall \> backup.sql

---

<div class="post-metadata">

**Author:** ![mehrshid](https://community.zammad.org/user_avatar/community.zammad.org/mehrshid/32/418_2.png) [@mehrshid](https://community.zammad.org/u/mehrshid)\
**Post date:** [March 16, 2022, 11:27am UTC](https://community.zammad.org/t/postgresql-9-2-to-9-6/8859/2 "2022-03-16T11:27:04Z")

</div>

I tried another method to upgrade PostgreSQL and worked for me!

---

<div class="post-metadata">

**Author:** ![system](https://community.zammad.org/uploads/default/original/1X/5c5afaea2d23f811dbec33cd4edb02fa29d3262f.png) [@system](https://community.zammad.org/u/system)\
**Post date:** [July 14, 2022, 11:27am UTC](https://community.zammad.org/t/postgresql-9-2-to-9-6/8859/3 "2022-07-14T11:27:57Z")

</div>

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.
