1

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

Re: Upgrade to PGSQL 10

You have to read PGSQL upgrade tutorial instead.

3

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

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

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

Re: Upgrade to PGSQL 10

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