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
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 |