Re: got stuck in pglogical upgrade on FreeBSD
От | Adrian Klaver |
---|---|
Тема | Re: got stuck in pglogical upgrade on FreeBSD |
Дата | |
Msg-id | cd74109e-b301-22f0-32c0-75e4db59bb4f@aklaver.com обсуждение исходный текст |
Ответ на | Re: got stuck in pglogical upgrade on FreeBSD (Rahul Chordiya <rahulchordiya@gmail.com>) |
Ответы |
Re: got stuck in pglogical upgrade on FreeBSD
(Rahul Chordiya <rahulchordiya@gmail.com>)
|
Список | 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
В списке pgsql-general по дате отправления: