How to remove demo data from an already live and running application?

Question

I need to remove Your company and other demo data from an existing application without affecting the useful records.
The other company data should remain intact only demo data should be removed.

Keyur · Accepted Answer

Hi Sohail,

You should create new database without demo data instead removing demo data from existing database.

Andreas Fuchs · Answer

@avarcas.com Thanks for your answer helped me allot

Avarcas.com · Answer

You can use the following:

*Enter your VPS (if remote) or open terminal if in local:*
ssh -l root 99.99.99.99
*
*
*Use the postgres user:
*
➜  ~ su postgres
*Select database
*
➜ ~ psql abc_db_name
*And fire this operations in terminal:
*
delete from stock_pack_operation; delete from stock_picking; delete from stock_move; delete from account_invoice; delete from account_partial_reconcile; delete from account_move; delete from sale_order;  delete from account_payment;

iWesabe Technologies · Answer

I agree with  Keyur [1] .
**You never use demo database for business !!!
** Deleting demo data through postgres is *Not a proper way.*
Demo data will be restored if you install/upgrade a module.
Find the installed apps in existing database, create new one and install those.
Export all data in CSV/Xls and restore in new database.

[1] https://www.odoo.com/forum/help-1/user/17522

関連投稿	返信	ビュー
After Load Data Demo demo_data	1 6月 25	1751
creation of company 解決済 company	1 10月 24	13196
Not able to create new company in live database in version 15 company	0 10月 22	2962
Is possible update value in exist demo data ? 解決済 demo_data	2 3月 22	13339
Function tag and getitem tag demo_data	2 1月 18	9293

この質問にフラグが付けられました

You never use demo database for business !!!

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！