# Updating askbot from 0.47 to 0.50 / Data Migration PostgreSQL

We were using askbot for about three years now. As we want to update the underlying OS we also want to update the askbot instance as well, since it has some flaws (able to comment without login -> login -> 404) we wonder how we could just dump the database and load the dump on the newer instance before "migrating".

What would, generally, the best way to do such an update without loosing data be?

Update: I've chosen to give 0.50 a try over the git version, which I was not able to get to work. As a clean installation it is working on my recent debian 7, but still the problem remains, how to get the data of the old instance into the new. I've choosen to pg_dump the contents of the "old" askbotdb and create a new one on the new system. The dump is then imported using psql and the user permissions are set as it should be and I'm able to connect to the imported database with the credentials in askbot's settings.py.

(env.0.7.50)askbot@debian:/data/askbot50\$ python manage.py schemamigration askbot --initial
WARNING!!! You are using a 'locmem' (local memory) caching backend,
which is OK for a low volume site running on a single-process server.
For a multi-process configuration it is neccessary to have a production
cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently
see outdated content on your site.

+ Added model askbot ...