i have remote PostgreSQL Database in cloud, and local PostgreSQL Database, i did install bucardo to make ASynchronization between the two Databases, and then added the local and remote database information to bucardo successfully:

bucardo add db localDB dbhost=$  PGHOST dbport=$  PGPORT dbname=$  PGDATABASE dbuser=$  PGSUPERUSER dbpass=$  PGSUPERPASS   bucardo add db remoteDB dbhost=$  PGHOST dbport=$  PGPORT dbname=$  PGDATABASE dbuser=$  PGSUPERUSER dbpass=$  PGSUPERPASS 

then added the tables of the local database to bucardo successfully:

sudo bucardo add all tables db=localDB 

result

559 tables added successfuly 

but when trying to add tables in remote server its gives me nothing, its hang and stop working:

sudo bucardo add all tables db=remoteDB 

_

my question is: how to let bucardo sucessfuly connect to remote server? the local postgres server version:

PostgreSQL 9.5.11 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit 

and the remote server version:

PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit