Re: Upgrading 9.1.17 to which version?

2019-05-17 Thread nigel . andersen
>Get a second machine, set it up to be as identical to the existing machine as >you can - aside from it not >being near death - and migrate "production" to it. >  >Then on the machine described above install v10 and whatever else you need for >staging/testing and then >once everything checks ou

Re: Upgrading 9.1.17 to which version?

2019-05-17 Thread nigel . andersen
>>I spent most of yesterday trying to get 9.6.13 installed from the PostgreSQL >>Yum repository and finally >>got it working with the initdb stuff stored on a >>non-default dedicated partition (RAID10 array) only to >>find that psql >>didn't work and was complaining about a missing libpq.so.5.

Upgrading 9.1.17 to which version?

2019-05-16 Thread nigel . andersen
Hi,   I've just inherited an ancient install of 9.1.17 after our tech guy left, on what turns out to be a rapidly dying server and being a total newb to PostgreSQL (and not much more advanced on Linux) I'm a little stuck on the way ahead.   I've managed to secure a decent new server for a new i