Re: missing client_hostname

2023-11-01 Thread Christoph Moench-Tegeder
Hi, please don't top-post. ## Atul Kumar (akumar14...@gmail.com): > I have already enabled log_hostname, still *client_hostname is not showing > up.* It's always helpful to mention relevant non-default settings along with the question. Was log_hostname really active at backup start time? (Chec

Re: missing client_hostname

2023-11-01 Thread Atul Kumar
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

Re: missing client_hostname

2023-11-01 Thread Mateusz Henicz
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 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 hostna

Re: missing client_hostname

2023-11-01 Thread Atul Kumar
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 wrote: > ## Atul Kumar (

Re: missing client_hostname

2023-11-01 Thread Christoph Moench-Tegeder
## 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_

missing client_hostname

2023-11-01 Thread Atul Kumar
Hi, I have postgres 12 running in centos7. I recently have configured streaming replication from master to standby using below command: /usr/bin/pg_basebackup -h -p 5432 -U replication -D /path/of/data/directory/ -Fp -R -Xs -P -c fast It was successfully configured but when I query pg_stat_rep