Обсуждение: qestion

hi,

i connect to my postgres only by socket tcp/ip , and i have to know what
client is connected to postgres in plpgsql function. I have many useres
in pg_hba.conf which can connect to server from all local network.
Then i need know from which client is connection. Is same way to check it
? or rewrite postmaster ?

... oh , is possible to change pg_hba.conf in plpgsql function, ie, when i
create new user (throught plpgsql func.) i need to add ip address, which
will be used by this new user.

can someone help me ???

thx

On Wed, 14 May 2003, ivan wrote:

> i connect to my postgres only by socket tcp/ip , and i have to know what
> client is connected to postgres in plpgsql function. I have many useres
> in pg_hba.conf which can connect to server from all local network.
> Then i need know from which client is connection. Is same way to check it
> ? or rewrite postmaster ?

Do you need the ip address or only what user is connected? The latter can
be got at with CURRENT_USER or USER.

> ... oh , is possible to change pg_hba.conf in plpgsql function, ie, when i
> create new user (throught plpgsql func.) i need to add ip address, which
> will be used by this new user.

Probably not.  You'd probably have to write a function in something else
and call it from the plpgsql function.  However, there's still an issue of
how to handle rollbacks since you can't easily roll back the changes.  It
might be better to have something that's connected and LISTENing and then
do a NOTIFY when you add users and have the outside thing figure out what
entries belong in pg_hba.conf.

On Thu, 15 May 2003, ivan wrote:

> On Thu, 15 May 2003, Stephan Szabo wrote:
>
> >
> > On Wed, 14 May 2003, ivan wrote:
> >
> > > i connect to my postgres only by socket tcp/ip , and i have to know what
> > > client is connected to postgres in plpgsql function. I have many useres
> > > in pg_hba.conf which can connect to server from all local network.
> > > Then i need know from which client is connection. Is same way to check it
> > > ? or rewrite postmaster ?
> >
> > Do you need the ip address or only what user is connected? The latter can
> > be got at with CURRENT_USER or USER.
>
>     Yes i know about CURRENTUSER , but i need ip address to intentify
> clients.

I don't think there's a builtin function that will give that to you, but
you may be able to write a C function that'll do that but I'm not sure
what'd be involved.

> > > ... oh , is possible to change pg_hba.conf in plpgsql function, ie, when i
> > > create new user (throught plpgsql func.) i need to add ip address, which
> > > will be used by this new user.
> >
> > Probably not.  You'd probably have to write a function in something else
> > and call it from the plpgsql function.  However, there's still an issue of
> > how to handle rollbacks since you can't easily roll back the changes.  It
> > might be better to have something that's connected and LISTENing and then
> > do a NOTIFY when you add users and have the outside thing figure out what
> > entries belong in pg_hba.conf.
> >
>
> but can i change pg_hba.conf with result , without restarting ?

You might need to HUP the postmaster, but you shouldn't need to shutdown
and restart.

On Thu, 15 May 2003, Stephan Szabo wrote:

>
> On Wed, 14 May 2003, ivan wrote:
>
> > i connect to my postgres only by socket tcp/ip , and i have to know what
> > client is connected to postgres in plpgsql function. I have many useres
> > in pg_hba.conf which can connect to server from all local network.
> > Then i need know from which client is connection. Is same way to check it
> > ? or rewrite postmaster ?
>
> Do you need the ip address or only what user is connected? The latter can
> be got at with CURRENT_USER or USER.

    Yes i know about CURRENTUSER , but i need ip address to intentify
clients.
>
> > ... oh , is possible to change pg_hba.conf in plpgsql function, ie, when i
> > create new user (throught plpgsql func.) i need to add ip address, which
> > will be used by this new user.
>
> Probably not.  You'd probably have to write a function in something else
> and call it from the plpgsql function.  However, there's still an issue of
> how to handle rollbacks since you can't easily roll back the changes.  It
> might be better to have something that's connected and LISTENing and then
> do a NOTIFY when you add users and have the outside thing figure out what
> entries belong in pg_hba.conf.
>

but can i change pg_hba.conf with result , without restarting ?