Yes, I have already tried that as log_hostname was already enabled by me. By the way, just to inform you that the log_hostname is used for logging the hostname instead of ip addresses in error log files only, Please correct me if I am wrong.
Could you help me in telling my query that Iasked in my trial mail: "Do you think that just because I use ip_address instead of hostname while using pg_basebackup on standby side could be the reason for not showing client_hostname in pg_stat_replication ?" I used below command in standby node: /usr/bin/pg_basebackup -h <master ip> -p 5432 -U replication -D /path/of/data/directory/ -Fp -R -Xs -P -c fast Regards. On Wed, Nov 1, 2023 at 11:46 PM Mateusz Henicz <mateuszhen...@gmail.com> wrote: > Did you reconnect your replica after enabling log_hostname? If not, then > do it and check again. > > śr., 1 lis 2023, 19:03 użytkownik Atul Kumar <akumar14...@gmail.com> > napisał: > >> I have already enabled log_hostname, still *client_hostname is not >> showing up.* >> >> Do you think that just because I use ip instead of hostname while using >> pg_basebackup could be the reason for it ? >> >> >> >> >> Regards, >> Atul >> >> On Wed, Nov 1, 2023 at 11:23 PM Christoph Moench-Tegeder < >> c...@burggraben.net> wrote: >> >>> ## Atul Kumar (akumar14...@gmail.com): >>> >>> > It was successfully configured but when I query pg_stat_replication I >>> don't >>> > get the hostname in output: >>> >>> I Recommend The Fine Manual: >>> >>> https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-REPLICATION-VIEW >>> "... and only when log_hostname is enabled". >>> >>> Regards, >>> Christoph >>> >>> -- >>> Spare Space >>> >>
