<div dir="ltr">Christian, in your case the backup preserver the old schema. Although since the difference in the new schema is a single column being added, you can use the "geonode syncdb --no-initial-data" before loading back the backup. The syncdb will create the new schema and the backup should load leaving the new column blank. The --no-initial-data will make sure that syncdb only creates the schema without loading any fixture.<div><br></div><div>Hope this helps.</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-07 14:48 GMT+02:00 Christian Willmes <span dir="ltr"><<a href="mailto:christian.willmes@googlemail.com" target="_blank">christian.willmes@googlemail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
following up on this thread: <a href="https://github.com/GeoNode/geonode/issues/2046" rel="noreferrer" target="_blank">https://github.com/GeoNode/geonode/issues/2046</a><br>
<br>
I did the sugested steps, but the upload problem persits. No wonder, because in which step should the 'layers_uploadsession' session be created?<br>
<br>
The erreor inthe apache log looks like:<br>
[Tue Jul 07 07:39:11.377817 2015] [:error] [pid 22673:tid 139958275774208] column "context" of relation "layers_uploadsession" does not exist<br>
[Tue Jul 07 07:39:11.377877 2015] [:error] [pid 22673:tid 139958275774208] LINE 1: ...e", "user_id", "processed", "error", "traceback", "context")...<br>
[Tue Jul 07 07:39:11.377884 2015] [:error] [pid 22673:tid 139958275774208] ^<br>
[Tue Jul 07 07:39:11.377898 2015] [:error] [pid 22673:tid 139958275774208] Traceback (most recent call last):<br>
[Tue Jul 07 07:39:11.377904 2015] [:error] [pid 22673:tid 139958275774208] File "/usr/local/lib/python2.7/dist-packages/geonode/layers/views.py"<br>
[....]<br>
<br>
<br>
I did exactly the following (from <a href="http://docs.geonode.org/en/master/tutorials/admin/backup/index.html" rel="noreferrer" target="_blank">http://docs.geonode.org/en/master/tutorials/admin/backup/index.html</a>):<br>
<br>
sudo -u postgres -i pg_dump -c -Fc geonode > geonodedb.backup<br>
<br>
<br>
sudo service apache2 stop<br>
sudo /etc/init.d/tomcat7 stop<br>
<br>
sudo service postgresql start<br>
sudo -u postgres -i "psql -c 'drop database geonode;'"<br>
sudo -u postgres -i "psql -c 'create database geonode;'"<br>
sudo -u postgres -s "pg_restore -Fc -d geonode /path/to/geonodedb.backup"<br>
<br>
sudo service apache2 start<br>
sudo /etc/init.d/tomcat7 start<br>
<br>
----<br>
<br>
How can I solve this problem?<br>
<br>
Best regards,<br>
Christian<br>
<br>
_______________________________________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org" target="_blank">geonode-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Simone </div>
</div>