Community mailing list archives

community@mail.odoo.com

Re: SEEKING: Method to script backups of Odoo v9 - also include filestore (anything else??)

by
SISalp
- 12/30/2015 19:16:19
2015-12-30 20:22 GMT+01:00 Ray Carnes <ray.carnes@bistasolutions.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:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe