public inbox for [email protected]
help / color / mirror / Atom feedPsql not working
9+ messages / 6 participants
[nested] [flat]
* Psql not working
@ 2024-12-12 13:31 Narendran .j <[email protected]>
2024-12-12 13:36 ` AW: Psql not working Dischner, Anton <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 15:05 ` Re: Psql not working vignesh kumar <[email protected]>
0 siblings, 3 replies; 9+ messages in thread
From: Narendran .j @ 2024-12-12 13:31 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* AW: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
@ 2024-12-12 13:36 ` Dischner, Anton <[email protected]>
2 siblings, 0 replies; 9+ messages in thread
From: Dischner, Anton @ 2024-12-12 13:36 UTC (permalink / raw)
To: Narendran .j <[email protected]>; [email protected] <[email protected]>
Hi,
which user are you?
Check with: id
Try something like "su - postgres" before issuing psql command
Best,
Anton
Von: Narendran .j <[email protected]>
Gesendet: Donnerstag, 12. Dezember 2024 14:31
An: [email protected]
Betreff: Psql not working
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
@ 2024-12-12 14:10 ` Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Re: Psql not working Narendran .j <[email protected]>
2 siblings, 1 reply; 9+ messages in thread
From: Kashif Zeeshan @ 2024-12-12 14:10 UTC (permalink / raw)
To: Narendran .j <[email protected]>; +Cc: [email protected]
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 <[email protected]> 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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
@ 2024-12-12 14:44 ` Narendran .j <[email protected]>
2024-12-12 14:57 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 14:58 ` Re: Psql not working Holger Jakobs <[email protected]>
0 siblings, 2 replies; 9+ messages in thread
From: Narendran .j @ 2024-12-12 14:44 UTC (permalink / raw)
To: Kashif Zeeshan <[email protected]>; +Cc: [email protected]
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
On Thu, 12 Dec 2024 at 19:40, Kashif Zeeshan <[email protected]>
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 <[email protected]>
> 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
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Re: Psql not working Narendran .j <[email protected]>
@ 2024-12-12 14:57 ` Kashif Zeeshan <[email protected]>
1 sibling, 0 replies; 9+ messages in thread
From: Kashif Zeeshan @ 2024-12-12 14:57 UTC (permalink / raw)
To: Narendran .j <[email protected]>; +Cc: [email protected]
On Thu, Dec 12, 2024 at 7:44 PM Narendran .j <[email protected]> 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 <[email protected]>
> 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 <[email protected]>
>> 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
>>>
>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Re: Psql not working Narendran .j <[email protected]>
@ 2024-12-12 14:58 ` Holger Jakobs <[email protected]>
2024-12-12 15:02 ` Re: Psql not working Rajesh Kumar <[email protected]>
1 sibling, 1 reply; 9+ messages in thread
From: Holger Jakobs @ 2024-12-12 14:58 UTC (permalink / raw)
To: [email protected]
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
Attachments:
[application/pgp-signature] OpenPGP_signature (203B, 2-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Re: Psql not working Narendran .j <[email protected]>
2024-12-12 14:58 ` Re: Psql not working Holger Jakobs <[email protected]>
@ 2024-12-12 15:02 ` Rajesh Kumar <[email protected]>
2024-12-12 15:05 ` AW: Psql not working Dischner, Anton <[email protected]>
0 siblings, 1 reply; 9+ messages in thread
From: Rajesh Kumar @ 2024-12-12 15:02 UTC (permalink / raw)
To: Holger Jakobs <[email protected]>; +Cc: [email protected]
I don't think the size 0 is a problem here.
On Thu, 12 Dec 2024, 20:28 Holger Jakobs, <[email protected]> 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
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* AW: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 14:10 ` Re: Psql not working Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Re: Psql not working Narendran .j <[email protected]>
2024-12-12 14:58 ` Re: Psql not working Holger Jakobs <[email protected]>
2024-12-12 15:02 ` Re: Psql not working Rajesh Kumar <[email protected]>
@ 2024-12-12 15:05 ` Dischner, Anton <[email protected]>
0 siblings, 0 replies; 9+ messages in thread
From: Dischner, Anton @ 2024-12-12 15:05 UTC (permalink / raw)
To: Rajesh Kumar <[email protected]>; Holger Jakobs <[email protected]>; +Cc: [email protected] <[email protected]>
Hi,
on my system ist:
which psql
/usr/bin/psql
postgres@myserver:~$ file /usr/bin/psql
/usr/bin/psql: symbolic link to ../share/postgresql-common/pg_wrapper
file /usr/share/postgresql-common/pg_wrapper
/usr/share/postgresql-common/pg_wrapper: Perl script text executable
Regards,
Anton
Von: Rajesh Kumar <[email protected]>
Gesendet: Donnerstag, 12. Dezember 2024 16:03
An: Holger Jakobs <[email protected]>
Cc: [email protected]
Betreff: Re: Psql not working
I don't think the size 0 is a problem here.
On Thu, 12 Dec 2024, 20:28 Holger Jakobs, <[email protected]<mailto:[email protected]>> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Psql not working
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
@ 2024-12-12 15:05 ` vignesh kumar <[email protected]>
2 siblings, 0 replies; 9+ messages in thread
From: vignesh kumar @ 2024-12-12 15:05 UTC (permalink / raw)
To: Narendran .j <[email protected]>; [email protected] <[email protected]>
Re install your client binaries.. could be one potential problem..
Sent from Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Narendran .j <[email protected]>
Sent: Thursday, December 12, 2024 7:01:28 PM
To: [email protected] <[email protected]>
Subject: Psql not working
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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2024-12-12 15:05 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-12 13:31 Psql not working Narendran .j <[email protected]>
2024-12-12 13:36 ` AW: Psql not working Dischner, Anton <[email protected]>
2024-12-12 14:10 ` Kashif Zeeshan <[email protected]>
2024-12-12 14:44 ` Narendran .j <[email protected]>
2024-12-12 14:57 ` Kashif Zeeshan <[email protected]>
2024-12-12 14:58 ` Holger Jakobs <[email protected]>
2024-12-12 15:02 ` Rajesh Kumar <[email protected]>
2024-12-12 15:05 ` AW: Psql not working Dischner, Anton <[email protected]>
2024-12-12 15:05 ` vignesh kumar <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox