Copy between database using pg_dump and SSH
-1
votes
1
answer
907
views
I want to copy a tabel from one server to another using pg_dump and SSH.
Here is the script that I run from the source database :
pg_dump -h 127.0.0.1 -Fc --dbname=postgresql://postgres:passwd@127.0.0.1:5432/db_reference --table db_reference.education | ssh -C username@10.100.8.43 "psql -h 10.100.8.43 -U postgres -p 5432 x_db_test"
There is error:
host key verification failed
Questions :
1. Is the command correct?
2. How to remove the error?
Thanks
Asked by padjee
(337 rep)
Nov 22, 2022, 08:56 AM
Last activity: Jan 29, 2023, 09:53 PM
Last activity: Jan 29, 2023, 09:53 PM