Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
On 11/27/23 16:58, Atul Kumar wrote: I Don't know how postgres was installed, 1) Someone installed it. Ask around on where it came from. 2) Query the package manager to see if it was installed that way? How do I check if I have more than one version of psql installed ? A quick and dirty

Re: IPV6 issue

2023-11-27 Thread Atul Kumar
I Don't know how postgres was installed, How do I check if I have more than one version of psql installed ? Regards. On Tue, Nov 28, 2023 at 6:26 AM Adrian Klaver wrote: > On 11/27/23 16:42, Atul Kumar wrote: > > Hi, > > > > unix_socket_directories is set to default i.e. /tmp and I could see

Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
On 11/27/23 16:42, Atul Kumar wrote: Hi, unix_socket_directories is set to default i.e. /tmp and I could see the socket in /tmp directory. You have not answered: How did you install Postgres? Do you have more then one version of psql installed? Though I am pretty sure I know the ans

Re: IPV6 issue

2023-11-27 Thread Atul Kumar
Hi, unix_socket_directories is set to default i.e. /tmp and I could see the socket in /tmp directory. Regards. On Tue, Nov 28, 2023 at 2:11 AM Tom Lane wrote: > Adrian Klaver writes: > > On 11/27/23 12:11, Atul Kumar wrote: > >> I found that localhost was set to .bash_profile and when I r

Re: IPV6 issue

2023-11-27 Thread Atul Kumar
listen_address is set to '*', version= psql (12.15, server 12.15.19) Regards. On Tue, Nov 28, 2023 at 2:01 AM Adrian Klaver wrote: > On 11/27/23 12:11, Atul Kumar wrote: > > Hi, > > > > I found that localhost was set to .bash_profile and when I removed it > > and then re-attempted to connecte

Re: IPV6 issue

2023-11-27 Thread Tom Lane
Adrian Klaver writes: > On 11/27/23 12:11, Atul Kumar wrote: >> I found that localhost was set to .bash_profile and when I removed it >> and then re-attempted to connected the database using "psql postgres", I >> got this new error: >> >> psql postgres -p 5432 >> psql: error: could not connect

Re: IPV6 issue

2023-11-27 Thread Adrian Klaver
On 11/27/23 12:11, Atul Kumar wrote: Hi, I found that localhost was set to .bash_profile and when I removed it and then re-attempted to connected the database using "psql postgres", I got this new error: psql postgres -p 5432 psql: error: could not connect to server: No such file or director

Re: IPV6 issue

2023-11-27 Thread Atul Kumar
Hi, I found that localhost was set to .bash_profile and when I removed it and then re-attempted to connected the database using "psql postgres", I got this new error: psql postgres -p 5432 psql: error: could not connect to server: No such file or directory Is the server running locally an

Re: IPV6 issue

2023-11-23 Thread Adrian Klaver
On 11/23/23 11:18, Atul Kumar wrote: I have postgres 12 running in centos 7 on my two machines, recently I changed the authentication of entries of pg_hba.conf to scram-sha-256 for localhost. Since then in my one machine, I have started getting the below error when I use command "psql postgre

Re: IPV6 issue

2023-11-23 Thread Andreas Kretschmer
Am 23.11.23 um 20:18 schrieb Atul Kumar: I am not able to understand that my both machines are resolved to IPV6 then why is my first machine is throwing this error ? please check https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/network-flow-analysis/21

IPV6 issue

2023-11-23 Thread Atul Kumar
I have postgres 12 running in centos 7 on my two machines, recently I changed the authentication of entries of pg_hba.conf to scram-sha-256 for localhost. Since then in my one machine, I have started getting the below error when I use command "psql postgres" no pg_hba.conf entry for host "::1", u