0 like 0 dislike
177 views
asked in PostgreSQL Database Forum by (1k points)  
Pg_restore command. Restore from another server.

IP 1 and IP2

Db backup Dir in IP2
PLEASE HELP ME TO RESTORE FROM IP2.RESTORE IN IP 1

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (1k points)  

Rama:

Use pg_restore  -h option to mention the ip

IP1/bin/Pg_restore -h IP2 -d Databasename -U username -f /ip1location/dump.sql

Before that check the IP1 & IP2 connection establishment happened or not ?

Confirm the destination db name & port name 

Related questions

0 like 0 dislike
1 answer
Welcome to Discussion Forum where you can ask questions and receive answers from other members of the community.
...