Re: pgbench v14.2 and hostname

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

pg_bench support -h option so you should be able to execute query on remote
host, it worked for me earlier. error message will help debug.

On Mon, Mar 7, 2022 at 4:19 PM 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 Ron 2022-03-07 14:03:50 Re: Incremental Postgres database backup
Previous Message Tomasz Ziss 2022-03-07 10:57:41 Re: pgbench v14.2 and hostname