Re: [OPEN-ILS-GENERAL] PostGreSQL upgrade to 9.4

2017-10-15 Thread Jason Stephenson
On 10/14/2017 01:50 PM, Glen Modell wrote: > Hello, this is Glen from Ann Arbor.  We are not yet on Evergreen, but we > have a test server which is now on 2.12.4, OpenSRF 2.5.2, and PostGreSQL > 9.3.  We just attempted to move it to PostGreSQL 9.4 in preparation for > an upgrade to Evergreen 3.0. 

Re: [OPEN-ILS-GENERAL] PostGreSQL upgrade to 9.4

2017-10-15 Thread Blake Henderson
Glen, It might be a good idea to dump the database to a series of sql commands using pg_dump. Then replace the database engine with 9.5 and then restore the database from that backup. Here are some commands to help give you the idea: Shut the database down Make a raw tar backup of the