1 Topic by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Topic: Upgrade to PGSQL 10

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: CentOS 7.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes, 2.4.9
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Our current Iredmail server is running PGSQL 9.2 database server but I want to upgrade to PGSQL 10 server.
Do I have to run pg_upgrade script for all mailbox and vmail databases ?
How can the upgrade be done ?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Upgrade to PGSQL 10

You have to read PGSQL upgrade tutorial instead.

3 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Re: Upgrade to PGSQL 10

ZhangHuangbin wrote:

You have to read PGSQL upgrade tutorial instead.

I have gone through this document https://www.shernet.com/postgresql/upgr … -centos-7/
But as per document it's upgrading /var/lib/pgsql/data
So, do I need to do it for all mailbox and vmail databases ?

4 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Re: Upgrade to PGSQL 10

ZhangHuangbin wrote:

You have to read PGSQL upgrade tutorial instead.

I have gone through this document https://www.shernet.com/postgresql/upgr … -centos-7/
But as per document it's upgrading /var/lib/pgsql/data
So, do I need to do it for all mailbox and vmail databases ?

5 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

Re: Upgrade to PGSQL 10

I urgently need to upgrade from PGSQL 9.2 to PGSQL 10.0 stable, so just want to know will it impact on mail server ?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Upgrade to PGSQL 10

If PGSQL service itself runs well, i think it's fine.