The schema upgrade is very simple and safe but make sure the current database schema is in version 4.0.
Assumptions:
- tigasedb is a database name
- tigase_user is a database user name
- admin_db_user is database admin user name
First things first - make a database backup:
pg_dump -U tigase_user -W tigasedb > tigasedb_dump.sql
If you need to restore database for any reason execute following commands:
dropdb -U admin_db_user -W tigasedb createdb -U admin_db_user -W -O tigase_user tigasedb psql -U tigase_user -W tigasedb < tigasedb_dump.sql
Now we can run schema upgrade script
psql -q -U tigase_user -W tigasedb -f database/postgresql-schema-upgrade-to-5-1.sql