Re: pg_verify_checksums on ubuntu 16.04

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Rein Petersen <email(at)reinpetersen(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_verify_checksums on ubuntu 16.04
Date: 2021-07-28 16:51:29
Message-ID: 41969BA2-3D24-4467-911D-7DFAE783A800@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Jul 28, 2021, at 09:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Rein Petersen <email(at)reinpetersen(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Avadhut Narayan Joshi 2021-07-29 12:22:35 Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL
Previous Message Tom Lane 2021-07-28 16:47:30 Re: pg_verify_checksums on ubuntu 16.04