Feedback-ID: i76984098:Fastmail
Message-ID: <cc0ca54f-8e8f-43e4-ab7e-59790ea5b4fd@aklaver.com>
Date: Mon, 27 Jan 2025 12:51:35 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Content of pg_publication using a local connection versus network
 connection?
To: Shaheed Haque <shaheedhaque@gmail.com>,
 pgsql-general list <pgsql-general@lists.postgresql.org>
References: <CAHAc2jdj3EFVqc0WCHnQXL3hiJ_mfJH08WW=VznO0YzCjx-eKA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAHAc2jdj3EFVqc0WCHnQXL3hiJ_mfJH08WW=VznO0YzCjx-eKA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/cc0ca54f-8e8f-43e4-ab7e-59790ea5b4fd%40aklaver.com>
Precedence: bulk

On 1/27/25 12:41, Shaheed Haque wrote:
> Hi,
> 
> I'm a novice-ish when it comes to Postgres, but I've studied the docs 
> and not been able to understand why I can see the rows in pg_publication 
> via a local psql session, but not when I am connected via the network.
> 
> Since the network login is (a) successful and (b) can read the content 
> of other non-system tables, I guessed that my problem is row-level 
> security (RLS)....except that from the docs, I was unable to see how the 
> login type could affect RLS. What am I missing?
> 
> Here is some context...please do ask if something else needs to be 
> clarified!
> 
> - System Postgres 16, AWS RDS version.
> - The pg_publication tabe looks like this:
> 
> foo=>  \dpS pg_publication
>                                        Access privileges
>    Schema   |      Name      | Type  |     Access privileges     | 
> Column privileges | Policies
> ------------+----------------+-------+---------------------------+-------------------+----------
> pg_catalog | pg_publication | table | rdsadmin=arwdDxt/rdsadmin+| 
>                    |
>             |                |       | =r/rdsadmin               | 
>                    |
> 
> 
> - When I am logged in as this user via psql, I  can see:

This user is rdsadmin or something else?

> 
> foo=> select * from pg_publication;
>   oid  |      pubname      | pubowner | puballtables | pubinsert | 
> pubupdate | pubdelete | pubtruncate | pubviaroot
> -------+-------------------+----------+--------------+-----------+-----------+-----------+-------------+------------
> 98923 | vm_db_publication |    16478 | t            | t         | t 
>          | t         | t           | f
> 
> 
> - When I connect via psycog, I can read other tables, but pg_publication 
> aways seems to return no rows.

1) What is your connection string?
    In particular what user are you connecting as?

2) Are you sure you are connecting to same database?


> 
> Any assistance would be appreciated.
> 
> Thanks, Shaheed
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com