Re: got stuck in pglogical upgrade on FreeBSD - Mailing list pgsql-general

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.klaver@aklaver.com
> <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com