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 ?
