Seum-Lim Gan wrote:
> Hi Bruce,
>
> I tried to newly compiled 7.4 with HAVE_IPV6 commented out
> in /src/include/pg_config.h.
>
> After that I tried psql:
>
> psql -U scncraft -h localhost
> psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft",
> database "A"
>
> This happens the
Yes, I am not suspecting that there is something strange with that
Solaris installation. Maybe everything is IPv6. We certainly have lots
of Solaris users.
Are all Solaris connections coming in as IPv6? That seems impossible
because we didn't support IPv6 in PostgreSQL 7.3 and it worked fine.
Hello,
Also solaris has an option to not use IPV6 at least with Solaris 9.
When we installed
it it asked us if we wanted IPV6 support. We just said no.
Sincerely,
Joshua D. Drake
Seum-Lim Gan wrote:
Hi Bruce,
Thanks for the recommendation.
I will edit the pg_config.h file and comment out th
Hi Bruce,
I tried to newly compiled 7.4 with HAVE_IPV6 commented out
in /src/include/pg_config.h.
After that I tried psql:
psql -U scncraft -h localhost
psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft",
database "A"
This happens the same way whether I have this line in pg_hba.
Hi Bruce,
I am rebuilding now and noticed some error that I may have missed
since the last time I build 7.4.
Essentially the postmaster, bin, lib have been built and server is able to
start and I am able to create a new DB and etc.
Will let you know if the commenting out the HAVE_IPV6 will work.
M
Title: Re: [GENERAL] pg_hba.conf change in
7.4
Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
We are also wonder if there is a version of Ident server
that the PostgreSQL community knows that will work
with IPv6.
Thanks
Hi Bruce,
We are using Sun Solaris 9 on Sparc. uname -a :
SunOS test01 5.9 Generic_112233-04 sun4u sparc SUNW,Ultra-80
Gan
At 12:29 pm -0500 2003/11/20, Bruce Momjian wrote:
I think what happens is that when we listen on IPv4 and IPv6, that all
connections get IPv6. What OS are you using?
I think what happens is that when we listen on IPv4 and IPv6, that all
connections get IPv6. What OS are you using?
---
Seum-Lim Gan wrote:
> Hi Bruce,
>
> Thanks for the info.
> I captured the netstat output below.
>
> L
Hi Bruce,
Thanks for the info.
I captured the netstat output below.
Looks like there is a bunch of IPv4 being used.
Any idea how this can be resolved ?
Thanks.
Gan
UDP: IPv6
Local Address Remote Address
State If
- --
Seum-Lim Gan wrote:
> Hi,
>
> In 7.4, I noticed there is this ::1 and : (x8 of them)
> for IPv6.
>
> I looked at the documentation and there is nothing that says
> what the ::1 is for.
The ::1 is a IPv6 shorthand for 127.0.0.1 (localhost).
> Commenting out that line will prevent access to P
Hi,
In 7.4, I noticed there is this ::1 and : (x8 of them)
for IPv6.
I looked at the documentation and there is nothing that says
what the ::1 is for.
Commenting out that line will prevent access to PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
hostall
11 matches
Mail list logo
