Re: missing client_hostname - Mailing list pgsql-general

From Atul Kumar
Subject Re: missing client_hostname
Date
Msg-id CA+ONtZ5yefF6qnhMG4cqPd7c-uRokUK=EwPNuWY3cUy6-9hFgQ@mail.gmail.com
Whole thread Raw
In response to Re: missing client_hostname  (Mateusz Henicz <mateuszhenicz@gmail.com>)
List pgsql-general
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 <mateuszhenicz@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 <akumar14871@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 <cmt@burggraben.net> wrote:
## Atul Kumar (akumar14871@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

pgsql-general by date:

Previous
From: Mateusz Henicz
Date:
Subject: Re: missing client_hostname
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: missing client_hostname