Re: pgbench v14.2 and hostname

From: Tomasz Ziss <tziss85(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pgbench v14.2 and hostname
Date: 2022-03-07 10:57:41
Message-ID: CAKFKtuedOpc5xZTF3K-51Vx3QabXZFJceJHgB0z655U46V_bng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thx. Problem was with wrong ph_hba.conf entry.

[postgres(at)postgres14p ~]$ pgbench -h localhost -f
/var/lib/pgsql/scripts/script.sql -c 10 -T 5 -U postgres postgres
pgbench (14.2)
starting vacuum...end.
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: 111282
latency average = 0.437 ms
initial connection time = 138.164 ms
tps = 22879.721402 (without initial connection time)

On Mon, Mar 7, 2022 at 11:49 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> On Mon, 2022-03-07 at 11:46 +0100, Tomasz Ziss wrote:
> > 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
>
> I suggest that you look at the error messages rather than sending
> them to /dev/null.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Amit jain 2022-03-07 10:57:45 Re: pgbench v14.2 and hostname
Previous Message Laurenz Albe 2022-03-07 10:49:24 Re: pgbench v14.2 and hostname