This will create a feature request which anybody can view and comment on.
Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.
What you would like to accomplish:
There could be situations when pg_subscription is needed to be read if someone has activated multiple subscriptions in a database, however this action is prohibited due to the column ”subconninfo”.
How this might work:
It’s documented here in our public documentation[1] and in the PostgreSQL documentation[2] that this action is restricted for normal users due to the column “subconninfo” which could contain plain-text passwords.
However, there might be instances where someone would like only to verify the content of the table without access to the column ”subconninfo”.
There is already a third party extension, namely aiven_extras, which is not available in GCP, but it’s doing the designated job of listing all the subscriptions configured. More details about this approach can be found here[3][4].
This action can be done by removing the column in question at the inspection time, ensuring that the column will not be visible to the customers, or by implementing a similar approach as the aiven_extras.
Therefore, it would be a great addition of a similar functionality as the one presented above in order for users to verify the pg_catalog.pg_subscription table.
Description
Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.
What you would like to accomplish:
There could be situations when pg_subscription is needed to be read if someone has activated multiple subscriptions in a database, however this action is prohibited due to the column ”subconninfo”.
How this might work:
It’s documented here in our public documentation[1] and in the PostgreSQL documentation[2] that this action is restricted for normal users due to the column “subconninfo” which could contain plain-text passwords.
However, there might be instances where someone would like only to verify the content of the table without access to the column ”subconninfo”.
There is already a third party extension, namely aiven_extras, which is not available in GCP, but it’s doing the designated job of listing all the subscriptions configured. More details about this approach can be found here[3][4].
This action can be done by removing the column in question at the inspection time, ensuring that the column will not be visible to the customers, or by implementing a similar approach as the aiven_extras.
Therefore, it would be a great addition of a similar functionality as the one presented above in order for users to verify the pg_catalog.pg_subscription table.
[1]:
[2]:
[3]:
[4]:
If applicable, reasons why alternative solutions are not sufficient:
Due to the SUPERUSER Privileges, currently there is no workaround.
Other information (workarounds you have tried, documentation consulted, etc):
As mentioned above, there is already a third party extension that could accomplish that, however it is not available in GCP.