ray-odoo

delete from crm_lead;

delete from purchase_order_line;
delete from purchase_order;

delete from sale_order_line;
delete from sale_order;

delete from procurement_order;
delete from procurement_group;

ray-odoo

Phone
Hotel
Internet
Meals - Client
Meals - Employee
Shipping
Supplies
Travel Insurance
Airfare
Baggage

ray-odoo

TURN OFF:
update ir_mail_server set active = 'f'; 
update fetchmail_server set active = 'f';
update ir_cron set active = 'f' where function = 'schedule_backup';

TURN ON:
update ir_mail_server set active = 't'; 
update fetchmail_server set active = 't';
update ir_cron set active = 't' where function = 'schedule_backup';

ray-odoo

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database_name';

ray-odoo

OUT:

pg_dump production --no-owner --format=c --file=production.sql

FILESTORE:

tar -czvf /home/ubuntu/production.tar.gz production

IN:

ray-odoo

1.	Take a backup of the SAAS database.  (You must be logged into odoo.com as the Administrator of the database).

2.	Perform the following PSQL:
update ir_module_module set state = 'to remove' where name = 'saas_trial';

insert into base_config_settings(auth_signup_reset_password) values(true); 

update res_partner set signup_type='reset', signup_token='rsvabcdefghijykalklk', signup_expiration=to_timestamp('20200411','YYYYMMDD') where id=(select partner_id from res_users where id=1);

ALT: