Community mailing list archives
Re: SEEKING: Method to script backups of Odoo v9 - also include filestore (anything else??)by
On 2015-12-31 09:37, Houssine BAKKALI wrote:<blockquote cite="mid:CANNbhR_ECuOES5V9zG-q9oR8berw1+p7Z5MNFpnmWSsOwtFyGA@mail.gmail.com" type="cite">
"the new database should not interface external applications (pop/imap, smtp, shop-connector etc...), if a replacement it should"good catch as we tend to forget this too often!
<blockquote cite="mid:CANNbhR_ECuOES5V9zG-q9oR8berw1+p7Z5MNFpnmWSsOwtFyGA@mail.gmail.com" type="cite">
you can also have a look a the orchestor clouder (but it maybe something too big for this simple need) or odoo-infrastructure from ingadhoc
2015-12-31 1:18 GMT+01:00 Dominique Chabord <firstname.lastname@example.org>:
2015-12-30 20:22 GMT+01:00 Ray Carnes <email@example.com>: > Hi everyone. > > > > Is scripting a backup of Odoo v9 as simple as pg_dump and copying the > relevant filestore folder? > > > > 1. pg_dump -E UTF-8 -F p -b -f $filename $database in my scripts I use -O and -U options -E UTF-8 -F p -b options should be useless > 2. tar -zcvf filestore_$filename.gz $database > > 3. move both to the new server, restore dump and folder and update database > ? if target database already exists, dropdb after closing all connections restoration with psql and tar -xzf for the filestore change owner:group on filestore according to the new server depending on your context, you may have to synchronize/adapt some options in the server config file and also the modules that users can upload from the apps. A key point is to determine whether the copied database is a copy or a replacement of the main database. If a copy, the new database should not interface external applications (pop/imap, smtp, shop-connector etc...), if a replacement it should > > > > Does anyone know (have experience or a verified method for doing this) ? > > > > I want to start testing how I can quickly move a database from one server to > another. > > > > Ray Carnes > Senior Odoo Consultant | 909.864.4576 | Skype: bista_ray > Time zone: US Pacific | Office: Greater Los Angeles > Bista Solutions, Inc. | Empowering Business Success > > > > _______________________________________________ > Mailing-List: https://www.odoo.com/groups/community-59 > Post to: mailto:firstname.lastname@example.org > Unsubscribe: https://www.odoo.com/groups?unsubscribe