0 like 0 dislike
111 views
asked in PostgreSQL Database Forum by (990 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 (990 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 PostgreSQL Database Discussion Forum where you can ask questions and receive answers from other members of the community. Can discuss here Oracle, Postgresql, mariadb , mySQL , AWS , Linux , MSSQL , MongoDB , Greenplum databases related queries ...etc.
...