Upgrading Postgresql

SUSE Linux Enterprise Server SLES Configure-Administer
1

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.

2

Never mind…

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

Thanks.

3

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 .

HTH.

[1] 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.

4

[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 .

HTH.

[1] 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!