PostgreSQL_Backup and Restore database

PostgreSQL_Backup and Restore database

within pgAdmin 4

ยท

1 min read

๐ŸŽฏ Target: create plain dump of PostgreSQL Database and move it to another server

๐Ÿ› ๏ธ Tools and prerequisites: PostgreSQL DB and pgAdmin 4

Step 1 - Create DB backup

  1. In pgAdmin 4 LMB click on the needed DB name and choose Backup... Backup...

2.Choose path and provide backup-file name Path and backup-file name

3.Click Backupbutton and process will start

Step 2 - Restore DB on the other server

1.Move backup-file name to the other server

  1. In pgAdmin 4 LMB click on the Databases -> Create -> Database... image.png

3.Give a name to the DB and press Save image.png

4.LMB click on the name of a new DB, choose Restoreand then find backup-file name

โ— NB: you can drop the second Schema which were created automatically while DB was created

Useful resources which I was using making this article:

youtube.com - PostgreSQL backup and restore a database with pgAdmin 4 by Martin Richter

ย