AW: Psql not working

Hi,

on my system ist:

which psql
/usr/bin/psql
postgres(at)myserver:~$ file /usr/bin/psql
/usr/bin/psql: symbolic link to ../share/postgresql-common/pg_wrapper
file /usr/share/postgresql-common/pg_wrapper
/usr/share/postgresql-common/pg_wrapper: Perl script text executable

Regards,

Anton

Von: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Gesendet: Donnerstag, 12. Dezember 2024 16:03
An: Holger Jakobs <holger(at)jakobs(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Betreff: Re: Psql not working

I don't think the size 0 is a problem here.

On Thu, 12 Dec 2024, 20:28 Holger Jakobs, <holger(at)jakobs(dot)com<mailto:holger(at)jakobs(dot)com>> wrote:
Am 12.12.24 um 15:44 schrieb Narendran .j:
> I have checked the user, user is postgres
> I have noted that in bin path the size of psql client is 0
> psql --version and psql --help not working
> so i suspecting the psql client
>
> Regards,
> Narendran
>

Try finding psql on your disk with

find / -xdev -name psql -ls

and check whether one of the files found is an executable with

file path_of_file

and try it if it is.

Maybe your original psql file was deleted or its length set to zero by
incident. You might as well re-install your client package in order to
repair it.

Regards,
Holger

--

Holger Jakobs, Bergisch Gladbach