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@xxxxxxxxxxx
<mailto: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 <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
