[ckan-dev] Backup problems using paster db dump with spatial extension (FIXED)

[David]

Hi, Adriá.

Finally everything works great.

Here is my process:
https://ckan.readthedocs.org/en/1377-javascript-tutorial/maintaining/upgrading/index.html

1.1 ok
1.2 ok,

If 1.2 fails, change permissions as in:
https://lists.okfn.org/pipermail/ckan-dev/2014-October/008220.html
sudo -u postgres psql -d *ckan_default* -c "ALTER TABLE spatial_ref_sys 
OWNER TO ckan_default;"
sudo -u postgres psql -d *ckan_default* -c "ALTER TABLE geometry_columns 
OWNER TO ckan_default;"

ckan_default is the name of my database (I use the name as indicates in 
package install)

Now the backup:
paster db dump --config=/etc/ckan/default/production.ini 
my_ckan_database.pg_dump

To restore the next 2 steps:
paster db clean -c /etc/ckan/default/production.ini
paster db load -c /etc/ckan/default/production.ini my_ckan_database.pg_dump

At the end I get the next warning:
psql:my_ckan_database.pg_dump:18495: WARNING:  no privileges could be 
revoked for "public" REVOKE
psql:my_ckan_database.pg_dump:18496: WARNING:  no privileges could be 
revoked for "public" REVOKE
psql:my_ckan_database.pg_dump:18497: WARNING:  no privileges were 
granted for "public" GRANT

psql:my_ckan_database.pg_dump:18498: WARNING:  no privileges were 
granted for "public" GRANT
Loaded CKAN database: my_ckan_database.pg_dump

Upgrading DB
2014-10-17 14:19:25,497 INFO  [ckan.model] CKAN database version remains 
as: 71
Rebuilding search index
2014-10-17 14:19:25,542 INFO  [ckan.lib.search] Rebuilding search index...
2014-10-17 14:19:25,545 INFO  [ckan.lib.search] Rebuilding the whole 
index...
2014-10-17 14:19:25,802 INFO  [ckan.lib.search] Finished rebuilding 
search index
.
Done
(default)root at server:/usr/lib/ckan/default/src/ckan#

but everything works great. It restores all my files; pdf, geojson, 
excel, ....


Thanks all.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141017/b7b7caeb/attachment-0003.html>