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
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>
*"
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
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://
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