Postgres DB Backup & Restore

-

How to restore postgres db in terminal


DB BACKUP:



pg_dump -U user_role db_name > archive_name.sql



DB RESTORE:


psql -U user_role db_name < /directory/archive.sql or .dump or .tar













































































Comments











Post a Comment



















Popular posts from this blog









Uninstall ODOO module using terminal






-















  How to Uninstall Module from commend line:         step-1 :          Goto Terminal>Type sudo su postgres   step-2:           Type "psql database_name"   step-3:                 update ir_module_module set state='to remove' where name='module_name' and state='installed';     








Read more










How to Delete Menuitem-Odoo






-















  How to Delete Menu item       Delete base menuitem is simple. We just need to use delete tag and we need to add the menu item id.    Syntax                  <delete model="ir.ui.menu" id="Menuitem_id" />     Example                         <delete model="ir.ui.menu" id="base.module_mi" />   








Read more










Invalid XML for View Architecture - Openerp7






-















           Few bugs From openerp7:                Invalid  XML for View Architecture     For   this Add version = “7.0” attribute in particular Tree or form   view  then it wont cause any error.     e.g)   <tree string =”LEAD” version=”7.0”>     And   Tree or form or search that tag must have string    and version    attribute         ValueError: unsupported  format character '!' (0x21) at index 1391   If    it is in width attribute means u can use like this.    style="width:55%%"  two    Percentage Symbol       








Read more