🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
<h2 id="heading-step-1-create-db-backup">Step 1 - Create DB backup</h2>
<ol>
<li>In pgAdmin 4 LMB click on the needed DB name and choose <code>Backup...</code>
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1647940670044/2yfAeY_hA.png" alt="Backup..." /></li>
</ol>
2.Choose path and provide backup-file name
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1647940984144/9lEw7hyfp.png" alt="Path and backup-file name" />
3.Click <code>Backup</code>button and process will start
<h2 id="heading-step-2-restore-db-on-the-other-server">Step 2 - Restore DB on the other server</h2>
1.Move backup-file name to the other server
<ol>
<li>In pgAdmin 4 LMB click on the <code>Databases -&gt; Create -&gt; Database...</code>
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1647941384449/03hZa6DVJ.png" alt="image.png" /></li>
</ol>
3.Give a name to the DB and press <code>Save</code>
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1647941841691/m1jtgKFdi.png" alt="image.png" />
4.LMB click on the name of a new DB, choose <code>Restore</code>and then find backup-file name
❗ NB: you can drop the second Schema which were created automatically while DB was created
<blockquote>
Useful resources which I was using making this article:
</blockquote>
<a target="_blank" href="https://www.youtube.com/watch?v=vdd66leSDa4">youtube.com - PostgreSQL backup and restore a database with pgAdmin 4 by Martin Richter</a>

🎯 **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...](https://cdn.hashnode.com/res/hashnode/image/upload/v1647940670044/2yfAeY_hA.png)

2.Choose path and provide backup-file name
![Path and backup-file name](https://cdn.hashnode.com/res/hashnode/image/upload/v1647940984144/9lEw7hyfp.png)

3.Click ```Backup```button and process will start

## Step 2 - Restore DB on the other server

1.Move backup-file name to the other server

2. In pgAdmin 4 LMB click on the ```Databases -> Create -> Database...```
![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1647941384449/03hZa6DVJ.png)

3.Give a name to the DB and press ```Save```
![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1647941841691/m1jtgKFdi.png)

4.LMB click on the name of a new DB, choose ```
Restore
```and 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](https://www.youtube.com/watch?v=vdd66leSDa4)

🎯 Target: create plain dump of PostgreSQL Database and move it to another server

Interactive Data in Action

Interactive Data in Action

PostgreSQL_Backup and Restore database

within pgAdmin 4

Step 1 - Create DB backup

Step 2 - Restore DB on the other server