| From: | Mateusz Henicz <mateuszhenicz(at)gmail(dot)com> |
|---|---|
| To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
| Cc: | Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: missing client_hostname |
| Date: | 2023-11-01 18:16:00 |
| Message-ID: | CAN6i3YPPXi7q9MU=PGZs0NsKwDaFEB0CEvbJ=PB2B67SeGSHdw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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(at)burggraben(dot)net> wrote:
>
>> ## Atul Kumar (akumar14871(at)gmail(dot)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
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2023-11-01 19:00:54 | Re: missing client_hostname |
| Previous Message | Ron | 2023-11-01 18:09:10 | pg_dump/pg_restore --jobs practical limit? |