Re: Psql not working

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

On Thu, Dec 12, 2024 at 7:44 PM Narendran .j <jnarendran3@xxxxxxxxx> 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.zeeshan@xxxxxxxxx> 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@xxxxxxxxx> 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