Dump & Restore postgres


To dump a PostgreSQL database located at a specific IP address and restore it to a new database, you can follow these steps:


1. Dumping the database:

  - Open a terminal or command prompt on your local machine.

  - Use the `pg_dump` command-line tool to create a dump of the remote database. Replace `<remote_host>` with the IP address of the remote server and `<database_name>` with the name of the database you want to dump.

 



date:Nov. 28, 2023