# Upgrading Postgresql

**URL:** <https://forums.suse.com/t/upgrading-postgresql/32685>\
**Category:** SLES Configure-Administer\
**Created:** [July 17, 2018, 12:24am UTC](https://forums.suse.com/t/upgrading-postgresql/32685 "2018-07-17T00:24:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkesting](https://avatars.discourse-cdn.com/v4/letter/b/838e76/32.png) [@bkesting](https://forums.suse.com/u/bkesting)\
**Post date:** [July 17, 2018, 12:24am UTC](https://forums.suse.com/t/upgrading-postgresql/32685/1 "2018-07-17T00:24:07Z")

</div>

I currently am running Postgresql 8.3 on my SLES 11 SP4 system. I am preparing to update my system to SLES 12 SP2 (it’s a temporary upgrade…will update to SP3 later).

Reading through the documentation of the SLES upgrade, it looks like a Postgresql update is required and that it is not automatic in nature. I see through YaST there is version 9.1 and version 9.4 available. Do I need to go to 9.1 first, and then 9.4 before I can upgrade to SLES 12 SP2? I downloaded and installed 9.4 (via YaST), but could not get the database to initialize, so I rolled back (via snapshot) to my working 8.3 installation.

My steps were:

1. Downloaded ver. 9.4
2. Stopped current (8.3) database
3. Made backup copy of /var/lib/pgsql/data director (data.old)
4. Made new data directory (mkdir -p data)

I tried a simple start of the database to initialize the new install, but could not get it to initialize

Any advice would be appreciated. Thanks.

---

<div class="post-metadata">

**Author:** ![bkesting](https://avatars.discourse-cdn.com/v4/letter/b/838e76/32.png) [@bkesting](https://forums.suse.com/u/bkesting)\
**Post date:** [July 17, 2018, 1:47am UTC](https://forums.suse.com/t/upgrading-postgresql/32685/2 "2018-07-17T01:47:46Z")

</div>

Never mind…

My Groupwise Mobility software includes a script that automatically updates to version 9.4.

Thanks.

---

<div class="post-metadata">

**Author:** ![smflood](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/smflood/32/10576_2.png) [@smflood](https://forums.suse.com/u/smflood)\
**Post date:** [July 17, 2018, 1:16pm UTC](https://forums.suse.com/t/upgrading-postgresql/32685/3 "2018-07-17T13:16:45Z")

</div>

On 16/07/18 22:34, bkesting wrote:  
[color=blue]

> I currently am running Postgresql 8.3 on my SLES 11 SP4 system. I am  
> preparing to update my system to SLES 12 SP2 (it’s a temporary  
> upgrade…will update to SP3 later).
> 
> Reading through the documentation of the SLES upgrade, it looks like a  
> Postgresql update is required and that it is not automatic in nature. I  
> see through YaST there is version 9.1 and version 9.4 available. Do I  
> need to go to 9.1 first, and then 9.4 before I can upgrade to SLES 12  
> SP2? I downloaded and installed 9.4 (via YaST), but could not get the  
> database to initialize, so I rolled back (via snapshot) to my working  
> 8.3 installation.
> 
> My steps were:
> 
> 1. Downloaded ver. 9.4
> 2. Stopped current (8.3) database
> 3. Made backup copy of /var/lib/pgsql/data director (data.old)
> 4. Made new data directory (mkdir -p data)
> 
> I tried a simple start of the database to initialize the new install,  
> but could not get it to initialize
> 
> Any advice would be appreciated. Thanks.[/color]

I know this is resolved for you with GroupWise Mobility Service but for  
anyone else wanting to upgrade PostgreSQL (not as part of GMS) you can  
use pg\_upgrade[1] to upgrade from 8.3 directly to 9.4.

This is documented in the SLES12 SP3 Release Notes at  
[https://www.suse.com/releasenotes/x86\_64/SUSE-SLES/12-SP3/#fate-319049](https://www.suse.com/releasenotes/x86_64/SUSE-SLES/12-SP3/#fate-319049) .

HTH.

## [1] [https://www.postgresql.org/docs/9.4/static/pgupgrade.html](https://www.postgresql.org/docs/9.4/static/pgupgrade.html)

Simon  
SUSE Knowledge Partner

* * *

## If you find this post helpful and are logged into the web interface, please show your appreciation and click on the star below. Thanks.

---

<div class="post-metadata">

**Author:** ![bkesting](https://avatars.discourse-cdn.com/v4/letter/b/838e76/32.png) [@bkesting](https://forums.suse.com/u/bkesting)\
**Post date:** [July 17, 2018, 8:05pm UTC](https://forums.suse.com/t/upgrading-postgresql/32685/4 "2018-07-17T20:05:40Z")

</div>

[QUOTE=smflood;53524]On 16/07/18 22:34, bkesting wrote:  
[color=blue]

> I currently am running Postgresql 8.3 on my SLES 11 SP4 system. I am  
> preparing to update my system to SLES 12 SP2 (it’s a temporary  
> upgrade…will update to SP3 later).
> 
> Reading through the documentation of the SLES upgrade, it looks like a  
> Postgresql update is required and that it is not automatic in nature. I  
> see through YaST there is version 9.1 and version 9.4 available. Do I  
> need to go to 9.1 first, and then 9.4 before I can upgrade to SLES 12  
> SP2? I downloaded and installed 9.4 (via YaST), but could not get the  
> database to initialize, so I rolled back (via snapshot) to my working  
> 8.3 installation.
> 
> My steps were:
> 
> 1. Downloaded ver. 9.4
> 2. Stopped current (8.3) database
> 3. Made backup copy of /var/lib/pgsql/data director (data.old)
> 4. Made new data directory (mkdir -p data)
> 
> I tried a simple start of the database to initialize the new install,  
> but could not get it to initialize
> 
> Any advice would be appreciated. Thanks.[/color]

I know this is resolved for you with GroupWise Mobility Service but for  
anyone else wanting to upgrade PostgreSQL (not as part of GMS) you can  
use pg\_upgrade[1] to upgrade from 8.3 directly to 9.4.

This is documented in the SLES12 SP3 Release Notes at  
[https://www.suse.com/releasenotes/x86\_64/SUSE-SLES/12-SP3/#fate-319049](https://www.suse.com/releasenotes/x86_64/SUSE-SLES/12-SP3/#fate-319049) .

HTH.

## [1] [https://www.postgresql.org/docs/9.4/static/pgupgrade.html](https://www.postgresql.org/docs/9.4/static/pgupgrade.html)

Simon  
SUSE Knowledge Partner

* * *

If you find this post helpful and are logged into the web interface,  
please show your appreciation and click on the star below. Thanks.  
------------------------------------------------------------------------[/QUOTE]

Good to know. Thanks!
