| From: | nigel(dot)andersen(at)gmx(dot)com |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Upgrading 9.1.17 to which version? |
| Date: | 2019-05-16 09:36:56 |
| Message-ID: | trinity-3e5c707b-a548-4117-a723-6d15d65ebbb3-1557999416043@3c-app-mailcom-bs03 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>I've managed to secure a decent new server for a new install of PostgreSQL which runs CentOS 7.6 (Minimal). CentOS 7.6's standard PostgreSQL package seems to be 9.2.24 which is obviously no longer supported so probably doesn't get us much further ahead in the short term. As part of this upgrade we'd also like to implement support for pg_trgm which apparently needs >=9.6.</div>
<div> </div>
<div>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. Not sure if that's a common problem?</div>
<div> </div>
<div>My (admittedly loose) logic tells me that upgrading from 9.1.x to 9.6.x is probably a safer option than making the leap up to 10.x or 11.x but I wonder whether that might be an easier/more reliable option from an install and point of view and certainly preferable in the long term. Any advice on where to go?</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div>Nigel</div>
<div> </div>
<div> </div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Winanjaya Amijoyo | 2019-05-16 09:57:05 | How to search using daterange (using gist) |
| Previous Message | David Rowley | 2019-05-16 09:25:28 | Re: Returning empty on insert |