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:
- Downloaded ver. 9.4
- Stopped current (8.3) database
- Made backup copy of /var/lib/pgsql/data director (data.old)
- 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.