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 1tLkde-00Gl6v-2F for pgsql-admin@arkaria.postgresql.org; Thu, 12 Dec 2024 14:58: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 1tLkda-00CcU4-SJ for pgsql-admin@arkaria.postgresql.org; Thu, 12 Dec 2024 14:58:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLkda-00CcTu-Eo for pgsql-admin@lists.postgresql.org; Thu, 12 Dec 2024 14:57:59 +0000 Received: from mail-vs1-xe31.google.com ([2607:f8b0:4864:20::e31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLkdY-002Tr2-Lv for pgsql-admin@lists.postgresql.org; Thu, 12 Dec 2024 14:57:59 +0000 Received: by mail-vs1-xe31.google.com with SMTP id ada2fe7eead31-4afdd15db60so181285137.1 for ; Thu, 12 Dec 2024 06:57:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734015476; x=1734620276; 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=EcHAmbm3lh2wc3RJvCA/kyF2nsFCW+6UcNPxj4FetUw=; b=Eyhmx9grCnPqvx6meRKpbU3WvsiZuzFaDg5ek/9bJ8MiE9rMQJY/uNC6JWR5V7rWDA nB/QhYpuQcwmVcxxReqInMkXWH2AyDaylaeEQL8aWYSTMP2EPcJRJBWcSUJvobFzqk4/ 2O3Pi+duXWGFsN4I1/6g+a7wrxMP1jHvMBF0fEsx6r0n9srxF/3A90KsVLthZ+pSFK6G flS8QqGj9rnbNuu1JSddpeV5DHlJtMhQBJAv4V6LHfV4KdpmfTgEhm8u6xBZZ8uRzIQd MKxSIN6cJpsQuztPx3Qu+epK3mVa/9jU9FLROjsnH7Mofxo7NgfiIWJbmOzT45OJpGDw bdFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734015476; x=1734620276; 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=EcHAmbm3lh2wc3RJvCA/kyF2nsFCW+6UcNPxj4FetUw=; b=QseetTyE/ePNLOThjsszrr3C0CV9P9hoFmmDBxcsZhews3iC7FB0iKhlb6PsTKX92n UDWDjBODWGXr5qLNl4E/626bLVcxlfCPXzYScfTsX2HaOJSsqMtU57TdhBvNUFaAc1un zQTuQOw0Omkm1WAUkLqtVN6mupSyqTat333XfBL5X7UynAwNp7vzB9NSNcPxKERxRf1K Jsduo7BXMIQATn+HCsvvHmGDOjW06T2pp+Rrbg7YflogO8v+YFaFinRJlJsYSxGCH92l F1hipoewdrLZ+8R3p+nRr2rZBw6vpksh3uWzR3cioNkDIFvbrZ17oLtxUG/w6geDQKqy ofiA== X-Gm-Message-State: AOJu0YysNt2ByUA3WtYsoTovqslxBkyCxTp/joUXgcyfMeSR4kppXjb/ WgXFA0rVrBmIRtRklJGg85arfzJdPAz33NHCCsqf5xlmKPVwwMb7D1tEGChoJCAnPfFSU798XO3 kORBznctTD3NHAJ9BNnhzip4bPd0= X-Gm-Gg: ASbGncsra8dPCC+Kmpx/6nBU9Y64yORpguI3SCQk2nvsILBX3h9BJzN5frbjU88pTKk uHKUVaTiYmLlIrwgx8SBlCauNWFB8EtTFflL8 X-Google-Smtp-Source: AGHT+IHafPXhjjkgjTaykUHBjztCfLNt8dfLJlDqztTNOBJsazdTdkrellTLEfz4o2wF5dVr06S/FAMiJj96cfL8v7A= X-Received: by 2002:a05:6102:3ecd:b0:4af:aae2:7582 with SMTP id ada2fe7eead31-4b257f1b9b3mr1060310137.2.1734015475777; Thu, 12 Dec 2024 06:57:55 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Thu, 12 Dec 2024 19:57:43 +0500 Message-ID: Subject: Re: Psql not working To: "Narendran .j" Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000780778062913f037" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000780778062913f037 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Dec 12, 2024 at 7:44=E2=80=AFPM Narendran .j wrote: > 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 > It means the psql is not properly installed. Try to re-install postgres client again. > > Regards, > Narendran > > On Thu, 12 Dec 2024 at 19:40, Kashif Zeeshan > wrote: > >> Hi >> >> Can you check which user you are using to run psql, >> >> Do the following >> 1. Execute ls -lrt /usr/pgsql../bin/psql to see if the user have access >> to it >> >> 2. If you have access then try running the command psql --help to make >> sure if you have access to psql. >> >> 3. Also try to connect with the wrong user / port to see if psql >> generates error. >> >> Regards >> Kashif Zeeshan >> >> On Thu, Dec 12, 2024 at 6:31=E2=80=AFPM Narendran .j >> wrote: >> >>> Hello Team, >>> >>> I'm facing one problem, can't login postgres by psql, even it's not >>> throwing any error and can't find anything in log. >>> >>> Checked server is running fine, able to check status using pg_ctl. Can >>> can't login through psql >>> >>> My login attempt >>> >>> psql >>> /usr/pgsql-14/bin/psql >>> psql -U postgres -p 5432 -d postgres >>> >>> When I'm running above query it's return to next line, nothing comes up >>> >>> Please on this. >>> >>> Thanks >>> >> --000000000000780778062913f037 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, Dec 12,= 2024 at 7:44=E2=80=AFPM Narendran .j <jnarendran3@gmail.com> wrote:
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 suspec= ting the psql client

It means t= he psql is not properly installed. Try to re-install postgres client=C2=A0a= gain.

Regards,
Narendran

On Thu, 12 Dec 202= 4 at 19:40, Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi

<= div>Can you check which user you are using to run psql,

Do the following
1. Execute ls -lrt /usr/pgsql../bin/psql t= o see if the user have access to it

2. If you have= access then try running the command psql --help to make sure if you have a= ccess to psql.

3. Also try to connect=C2=A0with th= e wrong user / port=C2=A0to see if psql generates error.

Regards
Kashif Zeeshan

On Thu, Dec 12, 2024 at 6:31= =E2=80=AFPM Narendran .j <jnarendran3@gmail.com> wrote:
Hello Team,

I'm facing one problem, can't log= in postgres by psql, even it's not throwing any error and can't fin= d anything in log.

Check= ed server is running fine, able to check status using pg_ctl. Can can't= login through psql

My l= ogin attempt=C2=A0

psql<= /div>
/usr/pgsql-14/bin/psql
psql -= U postgres -p 5432 -d postgres=C2=A0

When I'm running above query it's return to next line,= nothing comes up

Please= on this.

Thanks
--000000000000780778062913f037--