Re: pgbench v14.2 and hostname - Mailing list pgsql-admin

From Amit jain
Subject Re: pgbench v14.2 and hostname
Date
Msg-id CAFBajrNYFDqOC+wE8maB5kq2GNRCmvFTXK8xDf52_LrtDpXdyQ@mail.gmail.com
Whole thread Raw
In response to Re: pgbench v14.2 and hostname  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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.albe@cybertec.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@postgres14p ~]$ pgbench -h localhost -f
> /var/lib/pgsql/scripts/script.sql -c 10 -T 5 -U postgres postg
> res 2>/dev/null
> [postgres@postgres14p ~]$
> [postgres@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



pgsql-admin by date:

Previous
From: Tomasz Ziss
Date:
Subject: Re: pgbench v14.2 and hostname
Next
From: Ron
Date:
Subject: Re: Incremental Postgres database backup