Re: Invoking user of the function with SECURITY DEFINER

2018-11-25 Thread Madan Kumar
Got it.. In my case i was getting session_user in declare section and trying to validate later which always resulted in the function owner. DECLARE user text := SESSION_USER; So using it within the BEGIN; ...; END; clause worked for me. Thanks. Warm Regards, Madan Kumar K <https://about

Invoking user of the function with SECURITY DEFINER

2018-11-22 Thread Madan Kumar
ecuting it. Is there a way to find that out? I tried CURRENT_USER and SESSION_USER but they return the function owner since they execute in that context. So is there any way to figure out the user who is invoking the function? Warm Regards, Madan Kumar K <https://about.me/madankumark> *"

Re: How to change standby node to sync from the new master without rebooting the PostgreSQL service?

2018-10-30 Thread Madan Kumar
It's not feasible since my deployments are in cloud. We make use of floating IP for DB clients, but usage of same for within cluster communication will be slight overhead. Warm Regards, Madan Kumar K <https://about.me/madankumark> *"There is no Elevator to Success. You have to

Re: How to change standby node to sync from the new master without rebooting the PostgreSQL service?

2018-10-30 Thread Madan Kumar
eiver process. The only way i figured out is to kill the wal receiver process. Postmaster will take care of restarting the wal receiver process. But here my worry is, will there be any side effect if i kill wal receiver process (even using TERM signal)? Warm Regards, Madan Kumar K <https://

How to change standby node to sync from the new master without rebooting the PostgreSQL service?

2018-10-30 Thread Madan Kumar
Hi, Whenever there is a change in master, PostgreSQL service on standby nodes must be restarted (after changing the master IP in the recovery.conf) to ensure it is syncing with the new master. Is there a way to point to new master without reboot of PostgreSQL on the standby? Warm Regards, Madan