Hi,
In 7.4, I noticed there is this ::1 and ffff: (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:
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:
psql: FATAL: IDENT authentication failed for user "postgres"
Right now, I have it set to trust to work around.
Any idea what to do about this ?
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
Thanks.
Gan
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org) 9  2315 
Seum-Lim Gan wrote: Hi,
In 7.4, I noticed there is this ::1 and ffff: (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 PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:
Seems you have an OS that makes all connections IPv6, even IPv4 ones.
That is why we had to have that line in there. Seems ::1 controls your
local connections on that platform. Some platforms have distinct IPv4
and IPv6 connections, so we have to include both lines in the file.
Right now, I have it set to trust to work around.
Any idea what to do about this ?
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
Yea, that's about it. My guess is that nothing is coming in via IPv4 on
your machine so 127.0.0.1 does nothing. Perhaps netstat will show the
IP address family used.
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
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
--------------------------------- ---------------------------------
---------- -----
localhost.35847 localhost.35847 Connected
TCP: IPv4
Local Address Remote Address Swind Send-Q Rwind Recv-Q State
-------------------- -------------------- ----- ------ ----- ------ -------
localhost.32906 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32906 49152 0 49152 0 ESTABLISHED
localhost.32908 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32908 49152 0 49152 0 ESTABLISHED
localhost.32910 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32910 49152 0 49152 0 ESTABLISHED
localhost.32911 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32911 49152 0 49152 0 ESTABLISHED
localhost.32913 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32913 49152 0 49152 0 ESTABLISHED
localhost.32915 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32915 49152 0 49152 0 ESTABLISHED
localhost.32917 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32917 49152 0 49152 0 ESTABLISHED
localhost.32919 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32919 49152 0 49152 0 ESTABLISHED
localhost.32920 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32920 49152 0 49152 0 ESTABLISHED
localhost.32922 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32922 49152 0 49152 0 ESTABLISHED
localhost.32923 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32923 49152 0 49152 0 ESTABLISHED
localhost.32924 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32924 49152 0 49152 0 ESTABLISHED
localhost.32926 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32926 49152 0 49152 0 ESTABLISHED
localhost.32927 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32927 49152 0 49152 0 ESTABLISHED
localhost.33086 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.33086 49152 0 49152 0 ESTABLISHED
localhost.33087 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.33087 49152 0 49152 0 ESTABLISHED
localhost.50882 localhost.14502 49152 0 49152 0 ESTABLISHED
localhost.14502 localhost.50882 49152 0 49152 0 ESTABLISHED
localhost.50883 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.50883 49152 0 49152 0 ESTABLISHED
At 12:11 pm -0500 2003/11/20, Bruce Momjian wrote: Seum-Lim Gan wrote: Hi,
In 7.4, I noticed there is this ::1 and ffff: (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 PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
host all all 127.0.0.1 255.255.255.255
> ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:
Seems you have an OS that makes all connections IPv6, even IPv4 ones.
That is why we had to have that line in there. Seems ::1 controls your
local connections on that platform. Some platforms have distinct IPv4
and IPv6 connections, so we have to include both lines in the file.
Right now, I have it set to trust to work around.
Any idea what to do about this ?
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
Yea, that's about it. My guess is that nothing is coming in via IPv4 on
your machine so 127.0.0.1 does nothing. Perhaps netstat will show the
IP address family used.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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.
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
--------------------------------- ---------------------------------
---------- -----
localhost.35847 localhost.35847 Connected
TCP: IPv4
Local Address Remote Address Swind Send-Q Rwind Recv-Q State
-------------------- -------------------- ----- ------ ----- ------ -------
localhost.32906 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32906 49152 0 49152 0 ESTABLISHED
localhost.32908 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32908 49152 0 49152 0 ESTABLISHED
localhost.32910 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32910 49152 0 49152 0 ESTABLISHED
localhost.32911 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32911 49152 0 49152 0 ESTABLISHED
localhost.32913 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32913 49152 0 49152 0 ESTABLISHED
localhost.32915 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32915 49152 0 49152 0 ESTABLISHED
localhost.32917 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32917 49152 0 49152 0 ESTABLISHED
localhost.32919 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32919 49152 0 49152 0 ESTABLISHED
localhost.32920 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32920 49152 0 49152 0 ESTABLISHED
localhost.32922 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32922 49152 0 49152 0 ESTABLISHED
localhost.32923 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32923 49152 0 49152 0 ESTABLISHED
localhost.32924 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32924 49152 0 49152 0 ESTABLISHED
localhost.32926 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32926 49152 0 49152 0 ESTABLISHED
localhost.32927 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.32927 49152 0 49152 0 ESTABLISHED
localhost.33086 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.33086 49152 0 49152 0 ESTABLISHED
localhost.33087 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.33087 49152 0 49152 0 ESTABLISHED
localhost.50882 localhost.14502 49152 0 49152 0 ESTABLISHED
localhost.14502 localhost.50882 49152 0 49152 0 ESTABLISHED
localhost.50883 localhost.14500 49152 0 49152 0 ESTABLISHED
localhost.14500 localhost.50883 49152 0 49152 0 ESTABLISHED
At 12:11 pm -0500 2003/11/20, Bruce Momjian wrote:Seum-Lim Gan wrote: Hi,
In 7.4, I noticed there is this ::1 and ffff: (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 PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
host all all 127.0.0.1 255.255.255.255
> ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:
Seems you have an OS that makes all connections IPv6, even IPv4 ones.
That is why we had to have that line in there. Seems ::1 controls your
local connections on that platform. Some platforms have distinct IPv4
and IPv6 connections, so we have to include both lines in the file.
Right now, I have it set to trust to work around.
Any idea what to do about this ?
host all all 127.0.0.1 255.255.255.255
ident pspmap
local all all password
host all all 0.0.0.0 0.0.0.0 reject
# IPv4-style local connections:
#host all all 127.0.0.1 255.255.255.255 trust
# IPv6-style local connections:
host all all ::1
ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
Yea, that's about it. My guess is that nothing is coming in via IPv4 on
your machine so 127.0.0.1 does nothing. Perhaps netstat will show the
IP address family used.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
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?
---------------------------------------------------------------------------
Seum-Lim Gan wrote: 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
--------------------------------- ---------------------------------
---------- -----
localhost.35847 localhost.35847
Connected
TCP: IPv4
Local Address Remote Address Swind Send-Q Rwind Recv-Q State
-------------------- -------------------- ----- ------ ----- ------ -------
localhost.32906 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32906 49152 0 49152
0 ESTABLISHED
localhost.32908 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32908 49152 0 49152
0 ESTABLISHED
localhost.32910 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32910 49152 0 49152
0 ESTABLISHED
localhost.32911 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32911 49152 0 49152
0 ESTABLISHED
localhost.32913 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32913 49152 0 49152
0 ESTABLISHED
localhost.32915 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32915 49152 0 49152
0 ESTABLISHED
localhost.32917 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32917 49152 0 49152
0 ESTABLISHED
localhost.32919 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32919 49152 0 49152
0 ESTABLISHED
localhost.32920 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32920 49152 0 49152
0 ESTABLISHED
localhost.32922 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32922 49152 0 49152
0 ESTABLISHED
localhost.32923 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32923 49152 0 49152
0 ESTABLISHED
localhost.32924 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32924 49152 0 49152
0 ESTABLISHED
localhost.32926 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32926 49152 0 49152
0 ESTABLISHED
localhost.32927 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32927 49152 0 49152
0 ESTABLISHED
localhost.33086 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.33086 49152 0 49152
0 ESTABLISHED
localhost.33087 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.33087 49152 0 49152
0 ESTABLISHED
localhost.50882 localhost.14502 49152 0 49152
0 ESTABLISHED
localhost.14502 localhost.50882 49152 0 49152
0 ESTABLISHED
localhost.50883 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.50883 49152 0 49152
0 ESTABLISHED
>
At 12:11 pm -0500 2003/11/20, Bruce Momjian wrote: >Seum-Lim Gan wrote:
>> Hi,
>>
>> In 7.4, I noticed there is this ::1 and ffff: (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 PostgreSQL
>> from psql unless I put trust for that line.
>>
>> This is what I had in 7.3.4:
>> host all all 127.0.0.1 255.255.255.255
> > ident pspmap
>> local all all
password >> host all all 0.0.0.0 0.0.0.0 reject
>>
>> But in 7.4, it does not work anymore. It seems to want ::1 to
be somewhere. >> If I change the line with ::1 from trust to ident pspmap, it
complains that >> the user cannot be found. But it is in the pspmap. Message fromm psql:
>
>Seems you have an OS that makes all connections IPv6, even IPv4 ones.
>That is why we had to have that line in there. Seems ::1 controls your
>local connections on that platform. Some platforms have distinct IPv4
>and IPv6 connections, so we have to include both lines in the file.
>
>> Right now, I have it set to trust to work around.
>> Any idea what to do about this ?
>>
>> host all all 127.0.0.1 255.255.255.255
>> ident pspmap
>> local all all
password >> host all all 0.0.0.0 0.0.0.0 reject
>> # IPv4-style local connections:
>> #host all all 127.0.0.1
255.255.255.2 55 trust >> # IPv6-style local connections:
>> host all all ::1
>> ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
>
>Yea, that's about it. My guess is that nothing is coming in via IPv4 on
>your machine so 127.0.0.1 does nothing. Perhaps netstat will show the
> >IP address family used.
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
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.
Gan
At 11:37 am -0600 2003/11/20, Seum-Lim Gan wrote: 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?
---------------------------------------------------------------------------
Seum-Lim Gan wrote: 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
--------------------------------- ---------------------------------
---------- -----
localhost.35847 localhost.35847
Connected
TCP: IPv4
Local Address Remote Address Swind Send-Q Rwind Recv-Q State
-------------------- -------------------- ----- ------ ----- ------ -------
localhost.32906 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32906 49152 0 49152
0 ESTABLISHED
localhost.32908 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32908 49152 0 49152
0 ESTABLISHED
localhost.32910 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32910 49152 0 49152
0 ESTABLISHED
localhost.32911 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32911 49152 0 49152
0 ESTABLISHED
localhost.32913 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32913 49152 0 49152
0 ESTABLISHED
localhost.32915 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32915 49152 0 49152
0 ESTABLISHED
localhost.32917 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32917 49152 0 49152
0 ESTABLISHED
localhost.32919 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32919 49152 0 49152
0 ESTABLISHED
localhost.32920 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32920 49152 0 49152
0 ESTABLISHED
localhost.32922 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32922 49152 0 49152
0 ESTABLISHED
localhost.32923 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32923 49152 0 49152
0 ESTABLISHED
localhost.32924 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32924 49152 0 49152
0 ESTABLISHED
localhost.32926 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32926 49152 0 49152
0 ESTABLISHED
localhost.32927 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.32927 49152 0 49152
0 ESTABLISHED
localhost.33086 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.33086 49152 0 49152
0 ESTABLISHED
localhost.33087 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.33087 49152 0 49152
0 ESTABLISHED
> localhost.50882 localhost.14502 49152 0 49152
0 ESTABLISHED localhost.14502 localhost.50882 49152 0 49152
0 ESTABLISHED
localhost.50883 localhost.14500 49152 0 49152
0 ESTABLISHED
localhost.14500 localhost.50883 49152 0 49152
0 ESTABLISHED
At 12:11 pm -0500 2003/11/20, Bruce Momjian wrote:
>Seum-Lim Gan wrote:
>> Hi,
>>
>> In 7.4, I noticed there is this ::1 and ffff: (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 PostgreSQL
>> from psql unless I put trust for that line.
>>
>> This is what I had in 7.3.4:
>> host all all 127.0.0.1 255.255.255.255
> > ident pspmap
>> local all all
password
>> host all all 0.0.0.0 0.0.0.0 reject
>>
>> But in 7.4, it does not work anymore. It seems to want ::1 to
be somewhere.
>> If I change the line with ::1 from trust to ident pspmap, it
complains that
>> the user cannot be found. But it is in the pspmap. Message fromm psql:
>
>Seems you have an OS that makes all connections IPv6, even IPv4 ones.
>That is why we had to have that line in there. Seems ::1 controls your
>local connections on that platform. Some platforms have distinct IPv4
>and IPv6 connections, so we have to include both lines in the file.
>
>> Right now, I have it set to trust to work around.
>> Any idea what to do about this ?
>>
>> host all all 127.0.0.1 255.255.255.255
>> ident pspmap
>> local all all
password
>> host all all 0.0.0.0 0.0.0.0 reject
>> # IPv4-style local connections:
>> #host all all 127.0.0.1
255.255.255. 255 trust
>> # IPv6-style local connections:
>> host all all ::1
>> ffff:ffff:ffff: ffff:ffff:ffff: ffff:ffff trust
>
>Yea, that's about it. My guess is that nothing is coming in via IPv4 on
>your machine so 127.0.0.1 does nothing. Perhaps netstat will show the
> >IP address family used.
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
Seum-Lim Gan wrote: Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
One idea is to edit include/pg_config.h and comment out HAVE_IPV6 and
recompile and see if it works. That will disable the postmaster from
listening on IPv6.
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
Hi Bruce,
Thanks for the recommendation.
I will edit the pg_config.h file and comment out the
HAVE_IPV6 #define.
It is now defined as 0.
Earlier on, I tried to set IPV6 to no or 0 in configure.ih
and then configure and rebuild but that did not work.
Will let you know if commenting out the HAVE_IPV6 will work.
Thanks.
Gan
At 11:28 am -0500 2003/12/6, Bruce Momjian wrote: Seum-Lim Gan wrote: Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
One idea is to edit include/pg_config.h and comment out HAVE_IPV6 and
recompile and see if it works. That will disable the postmaster from
listening on IPv6.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
--
+--------------------------------------------------------+
| Seum-Lim GAN email : sl***@lucent.co m |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
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 the
HAVE_IPV6 #define.
It is now defined as 0.
Earlier on, I tried to set IPV6 to no or 0 in configure.ih
and then configure and rebuild but that did not work.
Will let you know if commenting out the HAVE_IPV6 will work.
Thanks.
Gan
At 11:28 am -0500 2003/12/6, Bruce Momjian wrote:
Seum-Lim Gan wrote:
Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
One idea is to edit include/pg_config.h and comment out HAVE_IPV6 and
recompile and see if it works. That will disable the postmaster from
listening on IPv6.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square,
Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandpromp t.com - http://www.commandprompt.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
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.
Now, I can see Solaris favoring IPv6 if we listen on IPv4 and IPv6, but
if you compiled with IPv6 disabled, we don't listen on that port and I
can't see how the connection could be coming in on IPv6.
I think you need to dig into Solaris to see what netstat shows and how
your localhost is mapped on your machine.
---------------------------------------------------------------------------
Joshua D. Drake wrote: 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 the
HAVE_IPV6 #define.
It is now defined as 0.
Earlier on, I tried to set IPV6 to no or 0 in configure.ih
and then configure and rebuild but that did not work.
Will let you know if commenting out the HAVE_IPV6 will work.
Thanks.
Gan
At 11:28 am -0500 2003/12/6, Bruce Momjian wrote:
Seum-Lim Gan wrote:
Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
One idea is to edit include/pg_config.h and comment out HAVE_IPV6 and
recompile and see if it works. That will disable the postmaster from
listening on IPv6.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square,
Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandpromp t.com - http://www.commandprompt.com
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Angel Todorov |
last post by:
Hello, sometimes I get a strange error from postgresql when I try to
connect using ssl to the server:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token
"hostssl"
FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for
details
The contents of the pg_hba.conf file are
|
by: Seum-Lim Gan |
last post by:
Hi,
In 7.4, I noticed there is this ::1 and ffff: (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.
|
by: David Nedrow |
last post by:
I'm trying to set up the cyrus imap server using PostgreSQL as the
authentication backend.
Currently, the issue I'm having is that I'm unable to connect via psql
on the loopback address (127.0.0.1).
I believe I have the pg_hba.conf file correct, though I've tried a
number of variations other than what I've included below. After each
change to pg_hba.conf, I bounce postgresql (stop start), but still get
a FATAL error re: missing...
|
by: Liza |
last post by:
Hi,
I've just setup postgreSQL on my Fedora Core1 box. I installed
postgresql from rpm files.
When I try to connect to the postgresql server in pgmanage, or through
an ODBC from other windows machines I get a message:
"missing or erroneous pg_hba.conf file"
I set tcpip_socket = true in var/lib/pgsql/data/postgresql.conf
I added '-i' optin to etc/rc.d/init.d/postgresql as follows
|
by: Tom Allison |
last post by:
pg_hba.conf entry:
host all all 192.168.0/24 md5
I get the error
2004-06-14 20:51:48 LOG: invalid entry in pg_hba.conf file at
line 89, token "md5"
When I connect as:
psql -U postfix -h 192.168.0.5 postfix
| | |
by: Si Chen |
last post by:
Hello.
It seems that every time I make a change to pg_hba.conf, I have to
restart the database server for the new authentication to take effect.
Is there a way to have the server use the new pg_hba.conf authentication
without restarting the production server.
Thanks,
Si
|
by: Raymond O'Donnell |
last post by:
Hello all,
I've installed the new Win32 version of 8.0-beta1, running as a
service. When I connect to it using pgAdmin III and attempt to list
databases, I get an error: 'Column "datpath" does not exist.' I got
the same error reported when starting postmaster from the command
line using pg_ctl.
It's not causing me any real problems, apart from having to use psql
rather than pgAdmin for administration.
|
by: David Parker |
last post by:
We ran into a problem with pg_hba processing recently when we upgraded
from 7.3.2 to 7.4.5. We use postgres as part of a network appliance that
runs on Solaris 9/intel boxes. 7.4.5 runs fine in our development
environment, but when we deploy it to a production box, we get a
"missing or erroneous pg_hba.conf file" error.
The error in the log is
"invalid entry in pg_hba.conf file at line 60, token 255.255.255.255"
which corresponds to...
|
by: =?Utf-8?B?QWxleA==?= |
last post by:
Hi to everyone
At the moment, I am converting a .Net 1.1 application to 2.0. As the
My.settings did not exist in the 1.1 framework, the "101 VB.NET Sample" "How
to configuration settings" was used.
At the moment, the App.exe.conf is stored under "Program Files\MyApp". As
read/write access is needed to the Application configuration file, I have to
change the current approach to get the application running under Windows
Vista.
|
by: gjain123 |
last post by:
Hi all,
I am using netbeans as IDE and glassfish as app server for my web application.
At runtime it needs some dll files and .conf file. Now the question is:
1. How should I package the .conf file into my web application war file. The scenario is that one .conf file makes use of another. e.g. if one file is a.conf and another is b.conf then the path of b.con is specified in a.conf as absolute path. How I have to change this path in case I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
