Re: got stuck in pglogical upgrade on FreeBSD

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>