public inbox for [email protected]  

help / color / mirror / Atom feed
From: Shaheed Haque <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general list <[email protected]>
Subject: Re: Content of pg_publication using a local connection versus network connection?
Date: Tue, 28 Jan 2025 18:08:23 +0000
Message-ID: <CAHAc2jcACPpMv4Xzk-2xMVvAioREkvPLMFyg3Y3vAzRtV6j=GQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAHAc2jdj3EFVqc0WCHnQXL3hiJ_mfJH08WW=VznO0YzCjx-eKA@mail.gmail.com>
	<[email protected]>
	<CAHAc2jfZqwGum2CxBHD85FzujohjRC+jKuQB+9dXkFGHdVch0A@mail.gmail.com>
	<[email protected]>
	<CAHAc2jdkEHnRfWCZ77+U60MKGnkciaDoCizDiVJz8zQG2B+mnw@mail.gmail.com>
	<CAHAc2jc9pjEWp+izx43QMsYz5pq_xcYo2TJXPChRmo+D2o_R-w@mail.gmail.com>
	<[email protected]>

Thanks for the confirmation.

On Tue, 28 Jan 2025 at 18:06, Adrian Klaver <[email protected]>
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
> [email protected]
>


view thread (5+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Content of pg_publication using a local connection versus network connection?
  In-Reply-To: <CAHAc2jcACPpMv4Xzk-2xMVvAioREkvPLMFyg3Y3vAzRtV6j=GQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox