Skip to main content

PostgreSQL: Scheduler to take db backup every two hours



Hi, Today we are going to write a scheduler to take PostgreSQL db dump every two hours in ubuntu OS.

1. Create a folder called backup in your home directory where we are going to store all the dump files.

2. Because it's cron script so can provide password at runtime, we are going to store required details in ~/.pgpass file in following format

hostname:port:database:username:password


localhost:5432:mydb:user1:test123

don't forget to change it's permission to 0600 (chmod 0600 ~/.pgpass)

Note: You can change localhost with Server IP if you have

3. Create a file to write script for db backup. Let's create it in home directory itself and call it db_backup.sh

Add following command to the file.

pg_dump -d mydb -h localhost -p 5432 -U user1 -w  | gzip > /home/ubuntu/backup/$(date +%Y-%m-%d-%H:%m:%s).psql.gz

It will save the dump file with date and time as name. e.g 2017-09-16-07:09:1505546517.psql.gz

Don't forget to make db_backup.sh file executable (chmod +x db_backup.sh)

4. Now it's the time to set scheduler:



crontab -e

It will open scheduler file. Add following line at the end of file

1 */2 * * * /home/ubuntu/db_backup.sh

To know how these parameters work please visit https://crontab.guru/every-2-hours

That's it.

Now backup will be taken every two hours and backup file will be stored in ~/backup folder.


Thanks!!!! Enjoy Programming!! :)


Comments

Popular posts from this blog

Odoo: Qweb Templates Cache Issue

Hi Everyone, Today I was working on a hotel booking template in Odoo and changes made in the Qweb template(.xml) were not reflecting on updating module with odoo service restart. Tried few times without any success :(. Finally, I decided to delete the old template from Odoo backend and then update module again and it worked like a charm!! :) Steps to delete template from backend: Settings --> User Interface --> Views --> Search by template name Delete the used template. Although it's a small post, but I'm sure it will meet the purpose and help someone in the future. Thanks!!! Enjoy Programming!! :) Reference Links: =================================== https://www.odoo.com/forum/help-1/question/odoo-cache-and-updating-qweb-templates-84492

Odoo12/13: Add an extra action in the tree view action button

This post will help you to add an action window in Odoo. Odoo13: <act_window id="action_make_bank_payment"              name="Do Bank Payment"              res_model="account.ob.payment"              binding_model="account.move"              view_mode="form"              target="new"              binding_views="list,form"              domain="[('type','=', 'in_invoice')]"              groups="account.group_account_user" /> Odoo12: <act_window id="action_make_bank_payment"              name="Do Bank Payment"              res_model="account.ob.payment"             view_mode="tree,form"              domain="[('type','=', 'in_invoice')]"              groups="account.group_account_user" /> Thanks!!! Enjoy Programming!! :) Reference: https://www.odoo.com/es_

Odoo/OpenERP: one2one relational field example

one2one relational field is deprecated in OpenERP version>5 but you can achieve the same using many2one relational field. You can achieve it in following two ways : 1) using many2one field in both the objects ( http://tutorialopenerp.wordpress.com/2014/04/23/one2one/ ) 2)  using inheritance by deligation You can easily find the first solution with little search over internet so let's start with 2nd solution. Scenario :  I want to create a one2one relation between two objects of openerp hr.employee and hr.employee.medical.details What I should do  i. Add _inherits section in hr_employee class ii. Add field medical_detail_id in hr_employee class class hr_employee(osv.osv):     _name = 'hr.employee'     _inherits = {' hr.employee.medical.details ': "medical_detail_id"}     _inherit = 'hr.employee'         _columns = {              'emp_code':fields.char('Employee Code', si