Hi Ken I used the commands in fabfile.py and it worked (despite an error about the 'public' scheme; error ignored). Thanks!
2014-03-24 14:24 GMT+01:00 Ken Bolton <[email protected]>: > Hi Federico, > > Follow the Fabric task commands precisely to get a good dump/restore > process: > https://github.com/stephenmcd/mezzanine/blob/master/mezzanine/project_template/fabfile.py#L290-L303 > . > > Make sure also that you created the DB properly – that is, with the > correct locale – and that this locale matches the locale of your > environment. The relevant part of the fabfile is highlighted here: > https://github.com/stephenmcd/mezzanine/blob/master/mezzanine/project_template/fabfile.py#L340-L350 > . > > hth. > > best, > ken > > > On Mon, Mar 24, 2014 at 4:29 AM, Federico Bruni <[email protected]>wrote: > >> I've made the dump of the local database and I've tried to restore it on >> the server, but I'm getting the error below. >> BTW, how can I force the output to be in english? I've tried LANG=C but >> didn't work. Should I change the locale on the server? >> >> Any help appreciated. >> >> $ pg_restore -d database db.dump >> [skipping many lines] >> >> _restore: [archiviatore (db)] Errore nella voce TOC 2142; 2606 26962 FK >> CONSTRAINT to_blogpost_id_refs_id_6404941b fede >> pg_restore: [archiviatore (db)] could not execute query: ERRORE: il >> vincolo "to_blogpost_id_refs_id_6404941b" per la relazione >> "blog_blogpost_related_posts" esiste già >> Command was: ALTER TABLE ONLY blog_blogpost_related_posts >> ADD CONSTRAINT to_blogpost_id_refs_id_6404941b FOREIGN KEY >> (to_blogpost_id)... >> pg_restore: [archiviatore (db)] Errore nella voce TOC 2172; 2606 26967 FK >> CONSTRAINT twitter_tweet_query_id_fkey fede >> pg_restore: [archiviatore (db)] could not execute query: ERRORE: il >> vincolo "twitter_tweet_query_id_fkey" per la relazione "twitter_tweet" >> esiste già >> Command was: ALTER TABLE ONLY twitter_tweet >> ADD CONSTRAINT twitter_tweet_query_id_fkey FOREIGN KEY (query_id) >> REFERENCES twitter_quer... >> pg_restore: [archiviatore (db)] Errore nella voce TOC 2133; 2606 26972 FK >> CONSTRAINT user_id_refs_id_40c41112 fede >> pg_restore: [archiviatore (db)] could not execute query: ERRORE: il >> vincolo "user_id_refs_id_40c41112" per la relazione "auth_user_groups" >> esiste già >> Command was: ALTER TABLE ONLY auth_user_groups >> ADD CONSTRAINT user_id_refs_id_40c41112 FOREIGN KEY (user_id) >> REFERENCES auth_user(id)... >> pg_restore: [archiviatore (db)] Errore nella voce TOC 2135; 2606 26977 FK >> CONSTRAINT user_id_refs_id_4dc23c39 fede >> pg_restore: [archiviatore (db)] could not execute query: ERRORE: il >> vincolo "user_id_refs_id_4dc23c39" per la relazione >> "auth_user_user_permissions" esiste già >> Command was: ALTER TABLE ONLY auth_user_user_permissions >> ADD CONSTRAINT user_id_refs_id_4dc23c39 FOREIGN KEY (user_id) >> REFERENCES aut... >> ATTENZIONE: errore ignorato durante il ripristino: 219 >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Mezzanine Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Mezzanine Users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/mezzanine-users/4NwCIITBzBs/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
