| From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| To: | Pierre Ochsenbein <pierre(dot)ochsenbein(at)acceleris(dot)ch> |
| Cc: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>, Johannes Truschnigg <johannes(at)truschnigg(dot)info>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Streaming replication on two diff networks |
| Date: | 2018-06-05 14:30:44 |
| Message-ID: | CAGDYbUN4Piej7vOxyeDJuV016aZmyPxg3VS=3V+iNZpXWGuPbg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Pierre,
It looks you are not passing the public-key of replica to your master
server you need to pass or generate public-key between master-slave vice
versa.
Hope this helps..
On Tue, Jun 5, 2018 at 7:46 PM, Pierre Ochsenbein <
pierre(dot)ochsenbein(at)acceleris(dot)ch> wrote:
> Everything is good for the ssh connectivity from the slave to the master
> but not from the master to the slave.
>
>
> On the master :
>
> -bash-4.2$ ssh postgres(at)10(dot)0(dot)2(dot)67 (slaveIP)
>
> *Permission denied *(publickey,gssapi-keyex,gssapi-with-mic).
>
> -bash-4.2$
>
>
> -bash-4.2$ ssh-copy-id -i id_rsa.pub postgres(at)10(dot)0(dot)2(dot)67
> /bin/ssh-copy-id: INFO: Source of key(s) to be installed: "id_rsa.pub"
> /bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to
> filter out any that are already installed
> /bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are
> prompted now it is to install the new keys
> *Permission denied *(publickey,gssapi-keyex,gssapi-with-mic).
> -bash-4.2$
>
>
> --------
>
>
> On the slave :
>
> -bash-4.2$ ssh postgres(at)10(dot)1(dot)24(dot)13 (masterIP)
>
> postgres(at)10(dot)1(dot)24(dot)13's password:
>
> Last failed login: Tue Jun 5 10:10:19 EDT 2018 from slave on ssh:notty
>
> There were 44 failed login attempts since the last successful login.
>
> Last login: Tue Jun 5 09:48:42 2018 from slave
>
> -bash-4.2$ exit
>
> logout
>
>
>
> ------------------------------
> *De :* Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
> *Envoyé :* mardi 5 juin 2018 16:02
> *À :* Johannes Truschnigg
> *Cc :* Pierre Ochsenbein; pgsql-admin(at)lists(dot)postgresql(dot)org
> *Objet :* Re: PostgreSQL Streaming replication on two diff networks
>
> >No; not if there's not even basic IP connectivity between the
> participating
> hosts. Pierre will have to make sure he gets the routing between the two
> sites
> fixed (which is probably going to need some kind of VPN solution).<
>
> You are correct. But, I am assuming all routing, vpn's, iptables etc are
> configured since it is a known network to the user. He will still need
> entrie in pg_hba.conf.
>
> JT
>
> On Tue, Jun 5, 2018 at 6:43 AM, Johannes Truschnigg <
> johannes(at)truschnigg(dot)info> wrote:
>
>> On Tue, Jun 05, 2018 at 06:39:42AM -0700, Jorge Torralba wrote:
>> > It's all about the pg_hba.conf :)
>>
>> No; not if there's not even basic IP connectivity between the
>> participating
>> hosts. Pierre will have to make sure he gets the routing between the two
>> sites
>> fixed (which is probably going to need some kind of VPN solution).
>>
>> --
>> with best regards:
>> - Johannes Truschnigg ( johannes(at)truschnigg(dot)info )
>>
>> www: https://johannes.truschnigg.info/
>> phone: +43 650 2 133337
>> xmpp: johannes(at)truschnigg(dot)info
>>
>> Please do not bother me with HTML-email or attachments. Thank you.
>>
>
>
>
> --
> Thanks,
>
> Jorge Torralba
> ----------------------------
>
> Note: This communication may contain privileged or other confidential
> information. If you are not the intended recipient, please do not print,
> copy, retransmit, disseminate or otherwise use the information. Please
> indicate to the sender that you have received this email in error and
> delete the copy you received. Thank You.
>
> [image: Acceleris]
>
> Acceleris AG | cloudifying IT
> Pierre Ochsenbein | Technical Consultant
> Schosshaldenstrasse 85 | CH-3006 Bern
> <https://maps.google.com/?q=Schosshaldenstrasse+85+%7C+CH-3006+Bern&entry=gmail&source=g>
> T : +41 31 911 33 22 | F : +41 31 911 62 63
> pierre(dot)ochsenbein(at)acceleris(dot)ch | www.acceleris.ch
>
> Acceleris Offices are in :
> Bern | Zurich | Renens | Bucharest
>
> [image: Acceleris]
>
>
> Disclaimer
>
> This message possibly contains confidential data or items of information.
> It is intended solely for the rightful recipient. If you should have
> received the message wrongfully, it is not permitted to disclose the e-mail
> message or its contents to third parties, to copy or use it. We would
> respectfully request you to destroy the message with the exclusion of any
> reproduction and to notify this to the originator by e-mail. Thank you very
> much.
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Ochsenbein | 2018-06-05 15:18:40 | pgpool-II with PostgreSQL Streaming replication |
| Previous Message | Pierre Ochsenbein | 2018-06-05 14:16:05 | RE: PostgreSQL Streaming replication on two diff networks |