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