Re: pg_dump failed with error code 255, but I don't see why - Mailing list pgsql-general

From Jerry Sievers
Subject Re: pg_dump failed with error code 255, but I don't see why
Date
Msg-id m0r102ohzv.fsf@comcast.net
Whole thread Raw
In response to Re: pg_dump failed with error code 255, but I don't see why  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Ron <ronljohnsonjr@gmail.com> writes:

> On 9/22/22 09:34, Tom Lane wrote:
>
>> Ron <ronljohnsonjr@gmail.com> writes:
>>> v9.6.2.23
>>> I always run pg_dump with the --verbose option, and the bash script echos
>>> $?, so there's a 25,664 line log file for me to examine which explicitly
>>> shows the return code.
>> A quick search of the 9.6 pg_dump source code shows that it only
>> ever calls exit() with values 0 or 1.  255 would have to be coming
>> from some outside factor.  You sure your shell script isn't
>> misbehaving and corrupting the reported return code?
>
> Good to know.  The RC might be from ssh (the actual command being "ssh
> postgres@HOSTNAME pg_dump ...".


FWIW, here's what my ssh man page says, and a contrived example.

So it seems your ssh call itself borked for some reason perhaps.

EXIT STATUS
     ssh exits with the exit status of the remote command or with 255 if an
     error occurred.


tmp$ ssh localhost false; echo $?
1
tmp$ ssh no-such-host true; echo $?
ssh: Could not resolve hostname no-such-host: nodename nor servname provided, or not known
255
tmp$



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Database Horizon
Next
From: hubert depesz lubaczewski
Date:
Subject: How to handle logical replication 12->14, when our max_replication_slots gets overrun by inactive sync workers