Re: got stuck in pglogical upgrade on FreeBSD

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(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
>