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