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