Prompt Title: Backup and Restore with pgAdmin

To backup a PostgreSQL database in SQL format using pgAdmin 4 and then restore it using the same tool, you can follow these steps:

Backup:

1. Open pgAdmin 4 and connect to the PostgreSQL database server.
2. Expand the server group, and then expand the server.
3. Expand the Databases node and locate the database you want to back up.
4. Right-click on the database and select "Backup..."
5. In the Backup dialog, choose a destination folder for the backup file by clicking on the "..." button next to the "Filename" field.
6. Enter a name for the backup file in the "Filename" field, ending with the ".sql" extension (e.g., "backup.sql").
7. Under the "Format" tab, select "Plain" as the backup format.
8. Click on the "Backup" button to start the backup process.
9. Wait for the backup to complete. Once finished, you will have a SQL backup file of your database.

Restore:

1. Open pgAdmin 4 and connect to the PostgreSQL database server.
2. Expand the server group, and then expand the server.
3. Expand the Databases node and locate the target database where you want to restore the backup.
4. Right-click on the database and select "Restore..."
5. In the Restore dialog, click on the "..." button next to the "Filename" field to select the backup file you want to restore.
6. Locate and select the SQL backup file you created earlier and click "Open."
7. Under the "Options" tab, ensure that the "Clean before restore" and "Only data" options are checked, if you want to perform a clean data-only restore.
8. Click on the "Restore" button to start the restore process.
9. Wait for the restore to complete. Once finished, the database will be restored to the state it was at the time of the backup.

Note: It's essential to ensure that you have appropriate permissions to perform backups and restores on the database server.