martes, 22 de diciembre de 2015

Excluding multiple tables

Follow the next instructions for dumping backup excluding some tables.

1) Open the Linux terminal

2) Write next command

sudo pg_dump -Fc -h [IP Server] [DB Name] -U [DB User] -v -W -T 'Table1' -T 'Table2' .... -T 'TableN' > adempierefile.backup

In iDempiere, ad_changelog and ad_issue are biggest tables.

sudo pg_dump -Fc -h adempiere.com.ni adempiere-dbserver -U adempiere-dbuser -v -W -T 'ad_changelog' -T 'ad_issue' > /home/user/Documents/adempierefile20151222_1700.backup

sudo pg_dump -Fc -h 192.168.15.30 adempiere-dbserver -U adempiere-dbuser -v -W -T 'ad_changelog' -T 'ad_issue' > /home/user/Documents/adempierefile20151222_1700.backup

No hay comentarios:

Publicar un comentario