Thread: pg_verify_checksums on ubuntu 16.04

Rein Petersen <email@reinpetersen.com> writes:
> I have pg11.9 on ub16.04 and was expecting to find pg_verify_checksums
> command but it's nowhere to be found. any suggestions where i might find or
> install it?

Are you quite sure it's PG v11?  Later releases renamed that to
pg_checksums.

Otherwise, maybe Ubuntu put it in some sub-package you didn't install.

            regards, tom lane

> On Jul 28, 2021, at 09:47, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Rein Petersen <email@reinpetersen.com> writes:
>> I have pg11.9 on ub16.04 and was expecting to find pg_verify_checksums
>> command but it's nowhere to be found. any suggestions where i might find or
>> install it?
>
> Are you quite sure it's PG v11?  Later releases renamed that to
> pg_checksums.
>
> Otherwise, maybe Ubuntu put it in some sub-package you didn't install.

In Debian/Ubuntu packaging, pg_checksums is with the other binaries in:

    /usr/lib/postgresql/<major version>/bin/

That's usually not in $PATH, so the OP may have to fully-qualify the command or add that to the path.