Smart Tech Diary

The Smart Tech Diary

We recommend Divi Theme For WordPress

  • HOME
  • ABOUT
  • Topics
    • Programming
    • Computing
    • Hacking
    • Electronics
    • Web Design
  • CONTACT
  • Subscribe
  • Hacking Disclaimer
  • Privacy
You are here: Home / Databases / How to backup postgresql database in windows

How to backup postgresql database in windows

2nd November 2015 by Abdalla Nizar Leave a Comment

How to backup PostgreSQL database in windows

I almost lost a 3.4 Million worth of client data  because I was not making proper PostgreSQL backups regularly! This was as a result of not knowing exactly how to do it. So I had to learn a simple way to do a backup of my PostgreSQL. And in this short tutorial I will show you how to backup  PostgreSQL database in windows using Pg Admin.

How to backup PostgreSQL Database in Windows using PgAdmin

  • Open PgAdmin and Login to your Server

postgreSQL database backup-login

  • Right click on the database you want to backup and select backup as shown below

postgreSQL database backup

  • Click on the browse button with the dots

postgreSQL database backup- browse

  • Select a location where to dump the database backup and give a name to your backup file. Click save

postgreSQL database backup-database name and location

  • Under the Format drop down choose Tar as shown below. Leave everything else as default.

How to backup PostgreSQL database in Windows using PgAdmin

  • Click on backup button to backup your PostgreSQL database. When the process completes click on done.

How to backup PostgreSQL database in Windows using PgAdmin

  • Database Backup File

How to backup PostgreSQL database in Windows using PgAdmin

 

Now you are safe. In the next tutorial I will show you how to restore the PostgreSQL backup you have just made.

 

 

 

Share this:

  • Reddit
  • Email
  • Print
  • WhatsApp
  • Skype

Related

Filed Under: Databases Tagged With: PgAdmin, PostgreSQL, PostgreSQL Database Backup

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

WordPress-Security-For-Non-Geeks

Subscribe to Download The E-Book

* indicates required

Recent Posts

  • Why I will never use nulled WordPress themes again
  • New WordPress 4.8 has been released, Don’t Be Late
  • WikiLeaks reveals Grasshopper Malware, the CIA’s Windows hacking tool
  • The Ultimate WordPress Security Guide 2017 | How To Secure Your WordPress Website
  • How to purchase data bundle for Airtel postpaid lines

Categories

  • Computing
  • Databases
  • Digital Marketing
  • Electronics
  • Hacking
  • Kenya How Tos
  • Programming
  • Web Design
  • Wordepress Security
  • WordPress

Copyright © 2023 · The Smart Tech Diary