On Thu, Feb 19, 2026 at 08:59:29AM +0000, Subramanian,Ramachandran wrote:
> Hello,
>
> we are in a Situation where Linux boxes are delivered to us with postgres installed.
> Our group cannot install or upgrade. We do not have root privileges.
>
> Yesterday I found out pg_waldump bin file is missing and today I found out
> pg_archivecleanup is also missing. I am new to postgres and do not have
> a complete list of executables that are expected to be present.
Referring do Debian installations you should be able (unless it's explicitely prohibited) to use the
debian package management to look around.
First you might want to look at the packages related to postgres installed:
dpkg -l | grep postgres
then you can take a look at which files they contain, like:
dpkg -L postgresql-server-dev-17
For RPM based distribution there are similar ways, just take a look at "man rpm".
> 1. Is there any command or method with which we as DBAs can check for completeness of installation.
"completeness" is a vage description as there are numerous optional components.
> 2. Is there any way with which we can install Postgress WITHOUT ROOT privileges.
You really should not do this, for several reasons. Just talk to the administration folks.
HTH, chris