Forum OpenACS Development: OpenACS 5.9.0 with PostgresSQL 9.5.0

Collapse
1: OpenACS 5.9.0 with PostgresSQL 9.5.0
Posted by Gustaf Neumann on 01/13/16 09:54 PM
To whom it my concern: i've upgraded my local postgres installation of OpenACS 5.9.0 from PostgreSQL 9.4 to to PostgreSQL 9.5.0, which was released a few days ago, based on the default configuration from mac ports. Everything went smooth. Just dump/restore of OpenACS was sufficient: 

# Dump all databases from pg 9.4
PGBIN=/opt/local/lib/postgresql94/bin
sudo -u postgres $PGBIN/pg_dumpall > db.out
Then stop pg 9.4, start pg 9.5, then reload the dump: 
# Restore all databases and roles from dump into pg 9.5
PGBIN=/opt/local/lib/postgresql95/bin
sudo -u postgres $PGBIN//psql -f db.out postgres
voilà, start OpenACS, and everything works fine.
Collapse
2: Re: OpenACS 5.9.0 with PostgresSQL 9.5.0 (response to 1)
Posted by Cesareo Garci­a Rodicio on 01/16/16 07:03 PM
I've upgraded too and everything seems to be fine 😊 Easy and quick (medium traffic server)

(Using OpenACS 5.8.1d2 and installing postgresSQL from source with Naviserver 4.99.9)

Collapse
3: Re: OpenACS 5.9.0 with PostgresSQL 9.6beta1 (response to 1)
Posted by Gustaf Neumann on 05/13/16 12:42 PM
The same upgrade procedure works flawlessly with PostgreSQL 9.6beta1 (using the the stock version of pg of Mac Ports, installed with "port install postgresql96-server").
Collapse
4: Re: OpenACS 5.9.0 with PostgresSQL 9.6beta1 (response to 3)
Posted by Gustaf Neumann on 09/07/16 11:36 AM
Note, that the above statement is not an advertising to run beta-releases from PostgreSQL for the casual user. Since there is no binary compatibility even between minor beta releases, the whole db cluster has to be newly initialized and restored on all version updates during the beta phase.