Yes and yes. Also tried to completely clear slave data directory and setup fresh subscribe & subscription.
On Fri, 21 Jun, 2019, 9:35 PM Adrian Klaver, <adrian.kla...@aklaver.com> wrote: > On 6/21/19 8:45 AM, Rahul Chordiya wrote: > > 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. > > On both clusters right? > > > > > I tried to set log servirity to debug but I don't think it is set > properly. > > Did you issue a reload to the server? > > > > > > > On Fri, 21 Jun, 2019, 7:45 PM Adrian Klaver, <adrian.kla...@aklaver.com > > <mailto: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 <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
