How to take backup in PostGreSQL PGAdmin III

Today we are going to learn How to take backup in PostGreSQL PGAdmin III. There are many scenario’s when we have to take backup of database from PGAdmin III panel. We can achieve it using the below steps:

  1. First opening the database hierarchy.
  2. After that right click the database that we have to take the backup, as shown on the below snapshot:
  3. After clicking the Backup button, it will show Backup database “Database_name” dialog box.
  4. Keeping the Format custom, Rolename Postgres(if have any other rolename than we can place).
  5. Pressing the Backup button as shown on the below snapshot it will start taking the backup to the define location:
1 Star2 Stars3 Stars4 Stars5 Stars (12 votes, average: 5.00 out of 5)

Leave a Reply

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