Yes, Both machine in same network and I'm able to connect using psql from one machine to another.
Log only show that it is starting pglogical manager on database. I tried to set log servirity to debug but I don't think it is set properly. On Fri, 21 Jun, 2019, 7:45 PM Adrian Klaver, <adrian.kla...@aklaver.com> wrote: > 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? > > Have you looked in logs for both clusters? > > > > > > > > > -- > > Thanks & Regards > > > > Rahul Chordiya > > Tech-Geek && DevOps && Full Stack Developer > > > > Mobile: +91 998 153 4313 <tel:919981534313> > > > > * > > 🌳** > > > > *Please do not print this email unless absolutely necessary. Go GREEN, > > Go PAPERLESS * > > > > **🌳* > > * > > * > > * > > * > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
