Excecute the following command on phpPgAdmin on the SQL Tab. SELECT table_name, pg_size_pretty(table_size) AS table_size, pg_size_pretty(indexes_size) AS indexes_size, pg_size_pretty(total_size) AS total_size […]
#Upload the backup .sql file to the server #Execute the following command. root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql
Keep track of the custom changes that can be lost when rebuilding: ADD DB Column c_order.po_refernce_no ADD DB Column c_order.tracking_number Display Logic […]
UPDATE c_order SET po_refernce_no = (SELECT po_refernce_no FROM "Import" WHERE c_order_id = c_order.c_order_id), tracking_number = (SELECT tracking_number FROM "Import" WHERE c_order_id = […]