Re: Psql not working

On Thu, Dec 12, 2024 at 7:44 PM Narendran .j <jnarendran3(at)gmail(dot)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 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 <kashi(dot)zeeshan(at)gmail(dot)com>
> 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 PM Narendran .j <jnarendran3(at)gmail(dot)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
>>>
>>