Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLkiU-00GlgT-4A for pgsql-admin@arkaria.postgresql.org; Thu, 12 Dec 2024 15:03:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tLkiR-00Cl9k-GG for pgsql-admin@arkaria.postgresql.org; Thu, 12 Dec 2024 15:03:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLkiR-00Cl9b-1f for pgsql-admin@lists.postgresql.org; Thu, 12 Dec 2024 15:03:00 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLkiP-002SsC-52 for pgsql-admin@lists.postgresql.org; Thu, 12 Dec 2024 15:02:59 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-53e389d8dc7so729086e87.0 for ; Thu, 12 Dec 2024 07:02:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734015775; x=1734620575; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=E0EFWUFxc1J9kxR9OE2L3lHPhkJQQA76Rd0uwkVC7zQ=; b=QGF6AYmZ4BMrK9DCO9eXH7jpFlSnkVCZvMBBNzv7cb/H5PLjUiSJWXDSYc1ELPxGkm US2KFrEH4yvLtcNZ3MfmaQUI4NXLdPxK9tgo96FflMqfPs8cQx1YEZ4z5HK7DGG+OB3t cnsRIHcI8P1PFzQ7i99KiZmUQsiF6qkpXcIHF2fy11Ypbu5O8F4y8SABNwftgV88b5si njFPVawiDkd8IdQ1LIHa8i00DoBVXOXj+K4yKodUqm4qdz6GHA6AjUBR7OQiQ4A3tbhz WLgjEV31HxhEHl6R/TULigIgGZW9EdrO3P5RmqfTTG5cjihwGBlZMFY2SZ55yJnjATiG CzYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734015775; x=1734620575; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=E0EFWUFxc1J9kxR9OE2L3lHPhkJQQA76Rd0uwkVC7zQ=; b=StlrMJvZUDeCsLXrSfzW45N0De0A5+qlSP6AKOu2v8xiODrpB7KQz4zzlqbapA5p1H 8iIvVcxb0g5gKCLbDdLgGYQCaMTFsEt7zKgFE0/PN76rajCvyINko3GuDoy/GWeYYyzg wlilCGILZSvX4kHAamrG0ViK9f/whoY5MVOaaEZZ2J5nTtzoGZ0tCzEZWM+2qZh8u9SD RY27h5dccWziOOZ7AQY8oJ3YMJRyh61rhTOfYemFtj1LbgTvO7zAwmaTogqguFVav/WT pZpAvmuBgDm6Gy4gfyv4IwqeiyyPT/ELcuQ8ep14RlzlWjUbG5fo03T7jLN5JIny8/u5 Q4zA== X-Gm-Message-State: AOJu0YxBhzY5h60n/QGhpkY8ml6+H4oGG26dzd4fzVPnDIFdf93s9fpG e0q+77IBJmQGm4rtjxvD29OSVNqJ9iPvbsH81+41gBdhq9CvulCWzzxO3O7c11/rsYe5Ssn7p6j 0hpyAseoNN4zEGuVNNGMnFpQWKj1Kww== X-Gm-Gg: ASbGncsAuXg+RN6A6j5bs8tshJ2EYRHZOmfxmmIvPwTnZJwPAsa+x1l2m5L7ewLrQRX aqebbjuZi5tcRyESp5Wbl/5/FNHIoDONl63yRXIePBgnIXXagt25e4cxiAX3tVo1pNZvXmnQ= X-Google-Smtp-Source: AGHT+IG9enKNnzAvBf/uxxM0hjf8tqsxxgqx99M8eglfR0s8IsRxE2cZeGRSqPHZ78l1icDCzky/pURsntuwiJC7kh0= X-Received: by 2002:a05:6512:4019:b0:53a:1a81:f006 with SMTP id 2adb3069b0e04-5403410fbe1mr285476e87.31.1734015774972; Thu, 12 Dec 2024 07:02:54 -0800 (PST) MIME-Version: 1.0 References: <67a36e35-ddf6-aedb-aef8-838699b01892@jakobs.com> In-Reply-To: <67a36e35-ddf6-aedb-aef8-838699b01892@jakobs.com> From: Rajesh Kumar Date: Thu, 12 Dec 2024 20:32:43 +0530 Message-ID: Subject: Re: Psql not working To: Holger Jakobs Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004d65c8062914022b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004d65c8062914022b Content-Type: text/plain; charset="UTF-8" I don't think the size 0 is a problem here. On Thu, 12 Dec 2024, 20:28 Holger Jakobs, 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 > > --0000000000004d65c8062914022b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

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


On Thu, 12 Dec 2024, 20:28 Holger Jakobs, <holger@jakobs.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

=C2=A0=C2=A0 find / -xdev -name psql -ls

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

=C2=A0=C2=A0 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

--0000000000004d65c8062914022b--