Re: got stuck in pglogical upgrade on FreeBSD

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