Eyal Solomon's questions

Having some issues with repetitive logs inside nodejs container,

this is my flow :

• Nodejs container fetching ssh key(private key)
• Loading it into ssh-agent (eval "$(ssh-agent -s)" && cp ${key} ~/.ssh/id_rsa)
• Cloning a git repository using ssh
• Running git pull intervals every 1m

Error :

Getting "Warning: Permanently added 'github.com,140.82.x.x' (ECDSA) to the list of known hosts" on each git pull command

What I tried so far :

• Remove stdout from node execSync command
• add this to ~/.ssh/config and restarting ssh-agent with eval:

Host *
  StrictHostKeyChecking no
  UserKnownHostsFile ~/.ssh/known_hosts
  LogLevel ERROR
  IdentityFile ~/.ssh/id_rsa

Faced a situation we need to consolidate few small postgres instances to a bigger one

Cant figure out how to replicate "old" db new data to "new" db when the replacement happens

Ill try to simple it :

old db instance name is X
new db instance is Y

X has 10 GB of data and its takes 15~ minutes to dump & restore
in the meanwhile X receives more data (1-2 MB)

** HOW do i make X replicate data to Y so this data wont get lost ? ** 

I have this small script for dump & restore

## remote db to remote db

PGPASSWORD=$source_pass pg_dump -h $source_host -d $source_db_name -U $source_user -p $source_port > test.sql

psql postgres://$dest_user:$dest_pass@$dest_host:$dest_port/postgres -c "CREATE DATABASE ${source_db_name}" \
-c "CREATE USER ${source_user} WITH PASSWORD '${source_pass}'" \
-c "ALTER USER "${source_user}" WITH CREATEDB" \
|| echo "database already exists"

psql postgres://$dest_user:$dest_pass@$dest_host:$dest_port/$source_db_name < test.sql \
 && echo "loaded Data succesfuly !" || echo "Couldnt load data"