[mezzanine-users] postgres content/data syncing between development production
How can I sync the actual data in the database between development and production for postgres? new pages, products, description, Prices, Sales etc will be first checked in development. This has to be deployed to the production without overwriting/updating production relevant content ex: Past orders, User accounts, Stock Inventory, Sales, Discount codes etc.. -- 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 mezzanine-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [mezzanine-users] postgres content/data syncing between development production
Hi Vikraw, Sorry if I added to the confusion. Mezzanine does not move content for you. The commands I pointed out can be interpreted and extrapolated into normal command-line commands to do database backup and restore. Moving the backups is an exercise left up to the reader. hth. ken On Tue, Jun 9, 2015 at 10:07 AM, vikraw vik...@gmail.com wrote: So, what i understand is that both backup and restore tasks are run on the Depoyment/remote machine. when i do - fab deploy backup is taken (last.db) before any other tasks. restore is never called for task deploy South schema migrations are added to the directories in apps. these are uploaded to github and applied to remote machine. then a migrate command is run. But i am still confused how does the local database changes (adding new products) are applied to remote database? Is this also taken care by South (data migration..).. Because for me whenever i add a new page Or a product it never appears on the remote machine unless I copy my local database to remote manually Not sure what is not working for me.. Is it South migrations or another issues. -- 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 mezzanine-users+unsubscr...@googlegroups.com. 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 mezzanine-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [mezzanine-users] postgres content/data syncing between development production
So, what i understand is that both backup and restore tasks are run on the Depoyment/remote machine. when i do - fab deploy backup is taken (last.db) before any other tasks. restore is never called for task deploy South schema migrations are added to the directories in apps. these are uploaded to github and applied to remote machine. then a migrate command is run. But i am still confused how does the local database changes (adding new products) are applied to remote database? Is this also taken care by South (data migration..).. Because for me whenever i add a new page Or a product it never appears on the remote machine unless I copy my local database to remote manually Not sure what is not working for me.. Is it South migrations or another issues. -- 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 mezzanine-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [mezzanine-users] postgres content/data syncing between development production
On 9/06/2015 11:47 PM, Ken Bolton wrote: Hi Vikraw, Sorry if I added to the confusion. Mezzanine does not move content for you. The commands I pointed out can be interpreted and extrapolated into normal command-line commands to do database backup and restore. Moving the backups is an exercise left up to the reader. Hi Vikraw, If you want to dump the database straight from postgresql on your local development server, you can run pg_dump or pg_dumpall there, (and then psql on the deployed server), but it's mostly designed to do an entire database or *all* databases. The other alternative would be to use python manage.py dumpdata on your dev server and the loaddata equivalent on the deployed server - check the help for dumpdata to see how to dump just the tables for one app, or even one table itself. (e.g. you'll want to dump and load shop.products but probably not shop.orders) I found this site quite useful for a few different dumpdata/loaddata options: https://coderwall.com/p/mvsoyg/django-dumpdata-and-loaddata Seeya. Danny. hth. ken On Tue, Jun 9, 2015 at 10:07 AM, vikraw vik...@gmail.com mailto:vik...@gmail.com wrote: So, what i understand is that both backup and restore tasks are run on the Depoyment/remote machine. when i do - fab deploy backup is taken (last.db) before any other tasks. restore is never called for task deploy South schema migrations are added to the directories in apps. these are uploaded to github and applied to remote machine. then a migrate command is run. But i am still confused how does the local database changes (adding new products) are applied to remote database? Is this also taken care by South (data migration..).. Because for me whenever i add a new page Or a product it never appears on the remote machine unless I copy my local database to remote manually Not sure what is not working for me.. Is it South migrations or another issues. -- 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 mezzanine-users+unsubscr...@googlegroups.com mailto:mezzanine-users+unsubscr...@googlegroups.com. 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 mezzanine-users+unsubscr...@googlegroups.com mailto:mezzanine-users+unsubscr...@googlegroups.com. 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 mezzanine-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
