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.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
