Search Postgresql Archives

Re: got stuck in pglogical upgrade on FreeBSD

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux