On 6/21/19 6:42 AM, Rahul Chordiya wrote: > Hi, > > I'm trying to replicate data using pglogical > https://2ndquadrant.com/en/resources/pglogical/pglogical-docs/ > <https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/> > > In my testing on local network machine and amazon linux test machine I > have successfully setup the replication, > > Now while trying for my DB which is running on FreeBSD I did setup > everything installed pglogical and pglogical_output, the provider and > master are setup properly but the replication is not working. > > mydb=# SELECT subscription_name, status FROM > pglogical.show_subscription_status(); > subscription_name | status > -------------------------+-------------- > mydb_subscription | initializing > (1 row) > > status is not moving to replicating since last 24 hours db size is 30MB > of this database. > > nothing found in log, please tell me how to get detailed log and help me > solve this. > > FYI: OS: FreeBSD 11.0 > Master PG: 9.4 > Slave PD: 11.3
Are both databases clusters on the same machine, different machines, different networks?
Can you connect in both directions manually using psql?