MIME-Version: 1.0
References: <CAHAc2jdj3EFVqc0WCHnQXL3hiJ_mfJH08WW=VznO0YzCjx-eKA@mail.gmail.com>
 <cc0ca54f-8e8f-43e4-ab7e-59790ea5b4fd@aklaver.com> <CAHAc2jfZqwGum2CxBHD85FzujohjRC+jKuQB+9dXkFGHdVch0A@mail.gmail.com>
 <19043fe9-076b-4d94-a81c-f4292551b8be@aklaver.com> <CAHAc2jdkEHnRfWCZ77+U60MKGnkciaDoCizDiVJz8zQG2B+mnw@mail.gmail.com>
 <CAHAc2jc9pjEWp+izx43QMsYz5pq_xcYo2TJXPChRmo+D2o_R-w@mail.gmail.com> <e718519d-a264-4c77-8edb-fac24551ee77@aklaver.com>
In-Reply-To: <e718519d-a264-4c77-8edb-fac24551ee77@aklaver.com>
From: Shaheed Haque <shaheedhaque@gmail.com>
Date: Tue, 28 Jan 2025 18:08:23 +0000
Message-ID: <CAHAc2jcACPpMv4Xzk-2xMVvAioREkvPLMFyg3Y3vAzRtV6j=GQ@mail.gmail.com>
Subject: Re: Content of pg_publication using a local connection versus network connection?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general list <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ce8b13062cc814d9"
Archived-At: <https://www.postgresql.org/message-id/CAHAc2jcACPpMv4Xzk-2xMVvAioREkvPLMFyg3Y3vAzRtV6j%3DGQ%40mail.gmail.com>
Precedence: bulk

--000000000000ce8b13062cc814d9
Content-Type: text/plain; charset="UTF-8"

Thanks for the confirmation.

On Tue, 28 Jan 2025 at 18:06, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

>
>
> On 1/28/25 10:02 AM, Shaheed Haque wrote:
> > Hi,
> >
> > Based on the nudge from Adrian, I think I am now trying to connect to
> > the correct/same database through both the original
> > login-to-EC2-host-then-use-psql-to-RDS and then
> > setup-SSHTunnel-then-connect-via-psycopg-over-tunnel.
> >
> > The connect-via-psycopg-over-tunnel bit currently fails. Obviously, that
> > is almost certainly a bug in my code, but I am aware that the Postgres'
> > HBA setup is capable of distinguishing local logins from remote logins,
> > so I wanted to check if Postgres' login security can similarly
> > distinguish between a (remote) psql login and a (remote) psycopg login?
>
> They both use libpq so I doubt it.
>
> >
> > Thanks, Shaheed
> >
> >
> >
> > On
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

--000000000000ce8b13062cc814d9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br></div><div>Thanks for the confirmation.</div><div=
></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">On Tue, 28 Jan 2025 at 18:06, Adrian Klaver &=
lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><b=
r>
<br>
On 1/28/25 10:02 AM, Shaheed Haque wrote:<br>
&gt; Hi,<br>
&gt; <br>
&gt; Based on the nudge from Adrian, I think I am now trying to connect to =
<br>
&gt; the correct/same database through both the original <br>
&gt; login-to-EC2-host-then-use-psql-to-RDS and then <br>
&gt; setup-SSHTunnel-then-connect-via-psycopg-over-tunnel.<br>
&gt; <br>
&gt; The connect-via-psycopg-over-tunnel bit currently fails. Obviously, th=
at <br>
&gt; is almost certainly a bug in my code, but I am aware that the Postgres=
&#39; <br>
&gt; HBA setup is capable of distinguishing local logins from remote logins=
, <br>
&gt; so I wanted to check if Postgres&#39; login security can similarly <br=
>
&gt; distinguish between a (remote) psql login and a (remote) psycopg login=
?<br>
<br>
They both use libpq so I doubt it.<br>
<br>
&gt; <br>
&gt; Thanks, Shaheed<br>
&gt; <br>
&gt; <br>
&gt; <br>
&gt; On<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div>

--000000000000ce8b13062cc814d9--