Sample Header Ad - 728x90

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