MIME-Version: 1.0
References: 
 <CA+-Cqf52mv=mJO8VFsPB3COvOCHKLLvo_jkK=nmfaTt3n2qdug@mail.gmail.com>
In-Reply-To: 
 <CA+-Cqf52mv=mJO8VFsPB3COvOCHKLLvo_jkK=nmfaTt3n2qdug@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Thu, 12 Dec 2024 19:10:33 +0500
Message-ID: 
 <CAAPsdhfTwmrztts1eLXP2N9xRb7KZNxQakaGZPQkm2Y242kK0g@mail.gmail.com>
Subject: Re: Psql not working
To: "Narendran .j" <jnarendran3@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cbc2fe06291347e4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdhfTwmrztts1eLXP2N9xRb7KZNxQakaGZPQkm2Y242kK0g%40mail.gmail.com>
Precedence: bulk

--000000000000cbc2fe06291347e4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 <jnarendran3@gmail.com=
> 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
>

--000000000000cbc2fe06291347e4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi<div><br></div><div>Can you check which user you are usi=
ng to run psql,</div><div><br></div><div>Do the following</div><div>1. Exec=
ute ls -lrt /usr/pgsql../bin/psql to see if the user have access to it</div=
><div><br></div><div>2. If you have access then try running the command psq=
l --help to make sure if you have access to psql.</div><div><br></div><div>=
3. Also try to connect=C2=A0with the wrong user / port=C2=A0to see if psql =
generates error.</div><div><br></div><div>Regards</div><div>Kashif Zeeshan<=
/div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D=
"ltr" class=3D"gmail_attr">On Thu, Dec 12, 2024 at 6:31=E2=80=AFPM Narendra=
n .j &lt;<a href=3D"mailto:jnarendran3@gmail.com">jnarendran3@gmail.com</a>=
&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div=
 dir=3D"auto">Hello Team,<div dir=3D"auto"><br></div><div dir=3D"auto">I=
9;m facing one problem, can&#39;t login postgres by psql, even it&#39;s not=
 throwing any error and can&#39;t find anything in log.</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Checked server is running fine, able to che=
ck status using pg_ctl. Can can&#39;t login through psql</div><div dir=3D"a=
uto"><br></div><div dir=3D"auto">My login attempt=C2=A0</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">psql</div><div dir=3D"auto">/usr/pgsql-14/b=
in/psql</div><div dir=3D"auto">psql -U postgres -p 5432 -d postgres=C2=A0</=
div><div dir=3D"auto"><br></div><div dir=3D"auto">When I&#39;m running abov=
e query it&#39;s return to next line, nothing comes up</div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">Please on this.</div><div dir=3D"auto"><br><=
/div><div dir=3D"auto">Thanks</div></div>
</blockquote></div>

--000000000000cbc2fe06291347e4--