pgbench v14.2 and hostname

From: Tomasz Ziss <tziss85(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pgbench v14.2 and hostname
Date: 2022-03-07 10:46:52
Message-ID: CAKFKtuepx6sE2cM+hY1xgw4Y1tvHXc=eM7NyMd7p-fcWV1FmZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm not sure if I'm doing correctly, but I cannot specify hostname in
pgbench (v14.)
[postgres(at)postgres14p ~]$ pgbench -h localhost -f
/var/lib/pgsql/scripts/script.sql -c 10 -T 5 -U postgres postg
res 2>/dev/null
[postgres(at)postgres14p ~]$
[postgres(at)postgres14p ~]$ echo $?
1

Without hostname (going through socket) it works correctly:
[postgres(at)postgres14p ~]$ pgbench -f /var/lib/pgsql/scripts/script.sql
-c 10 -T 5 -U postgres postgres 2>/dev/null
pgbench (14.2)
transaction type: /var/lib/pgsql/scripts/script.sql
scaling factor: 1
query mode: simple
number of clients: 10
number of threads: 1
duration: 5 s
number of transactions actually processed: 184018
latency average = 0.270 ms
initial connection time = 26.990 ms
tps = 36984.453980 (without initial connection time)

My /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.103 postgres14s postgres14s

Br,
Tomasz

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-03-07 10:49:24 Re: pgbench v14.2 and hostname
Previous Message Daulat 2022-03-07 10:25:41 Re: Steps to enable SSL Enable