On Sat, Dec 30, 2023 at 11:50 AM Joe Conway wrote:
> In the meantime, in case it helps, see
>
>https://github.com/pgaudit/set_user
>
> Specifically set_session_auth(text):
> -
> When set_session_auth(text) is called, the effective session and current
> user is switched to the role
Hi,
What do you think of adding a NO RESET option to the SET ROLE command?
Right now Postgres can enforce data security with roles and RLS, but
role-per-end-user doesn't really scale: Db connections are per-role, so a
connection pooler can't share connections across users. We can work around
th
Whoa that's perfect! Thank you so much.
On Thu, Dec 24, 2020 at 4:59 PM Ian Lawrence Barwick
wrote:
> 2020年12月23日(水) 22:05 Eric Hanson :
> >
> > I'm trying to store connection to postgres_fdw in the database I want
> to be able to store the full breadth of c
On Wed, Dec 23, 2020 at 5:39 AM Ashutosh Bapat
wrote:
> https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-PARAMKEYWORDS
> lists the parameters that postgres_fdw accepts. "dbname" can be more
> than just dbname. See
> https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-CONNSTRING
I'm trying to store connection to postgres_fdw in the database I want to
be able to store the full breadth of connection styles and all the
different types of connections that libpq supports. But having some
troubles.
Postgres_fdw wants options passed into CREATE SERVER, all broken out into
sepa
On Tue, Apr 16, 2019 at 4:47 AM Eric Hanson wrote:
> We would probably be wise to learn from what has gone (so I hear) terribly
> wrong with the Node / NPM packaging system (and I'm sure many before it),
> namely versioning. What happens when two extensions require different
>
On Tue, Apr 16, 2019 at 4:24 AM Eric Hanson wrote:
>
>
> On Tue, Apr 16, 2019 at 12:47 AM Noah Misch wrote:
>
>> On Mon, Mar 18, 2019 at 09:38:19PM -0500, Eric Hanson wrote:
>> > I have heard talk of a way to write extensions so that they dynamically
>>
On Tue, Apr 16, 2019 at 12:47 AM Noah Misch wrote:
> On Mon, Mar 18, 2019 at 09:38:19PM -0500, Eric Hanson wrote:
> > I have heard talk of a way to write extensions so that they dynamically
> > reference the schema of their dependencies, but sure don't know how that
&g
These seem like much better ideas than mine. :-) Thanks.
Did anything ever come of these ideas? Do you have a sense of the level of
community support around these ideas?
Thanks,
Eric
On Wed, Mar 27, 2019 at 11:23 AM Chapman Flack
wrote:
> On 3/27/19 2:40 AM, Eric Hanson wrote:
>
&g
Hi,
I'm trying to use the PostgreSQL roles system as the user base for a web
application. The common wisdom seems to be Don't Do This, because it
requires a connection per-user which doesn't scale. However, thinking it
through, I'm wondering it there might be a workaround using "sandbox
transact
On Mon, Mar 18, 2019 at 11:56 PM Chapman Flack
wrote:
> On 03/18/19 22:38, Eric Hanson wrote:
> > rows are really second class citizens: They aren't tracked with
> > pg_catalog.pg_depend, they aren't deleted when the extension is dropped,
> > etc.
>
> This.
Hi folks,
After months and years of really trying to make EXTENSIONs meet the
requirements of my machinations, I have come to the conclusion that either
a) I am missing something or b) they are architecturally flawed. Or
possibly both.
Admittedly, I might be trying to push extensions beyond what
12 matches
Mail list logo