Import and Export Dump Files to PostgreSQL
Create two database environments and connect to them using any desktop client (we use pgAdmin4 as an example. Learn more in our tutorial).
Dump export from PostgreSQL
- We put environments remotepostgres.vip.iNET.elastic.cloud and destination.vip.iNET.elastic.cloud to the respective server groups backupsource and destination at the pgAdmin4 application.
- Make a right-click on the required database to be backed up e.g. iNET.elastic and choose Backup.
- Specify your dump file name and the format of the output file. E.g. mybackup and Tar file format respectively.
- Click on the Dump options tab and select backup options for database objects.
- Finally, click the Backup button. The successful window should appear.
Your dump file will be stored in the user home directory or by the path to which you have specified at the host the pgAdmin4 is running on.
Dump import to PostgreSQL
- Create an empty database at the destination server.
- Set the name in the field Database either the same e.g. iNET.elastic or any arbitrary name.
- To perform dump import to PostgreSQL database make the right-click on the new database and choose Restore.
- Select the file format used during the database backup operation. As for our example, we used tar format. Specify the name of the backup file or use file open dialogue at the right of the Filename field to choose the necessary file.
- Set advanced restoring options if needed.
- Finally, click on the Restore button.
- Navigate back to the iNET.elastic database at the destination server group and make sure that the database was restored properly with its content at both servers Master and Slave.
That’s all! Hope this how-to was useful for you.