pg.ddx.io  pgsql-hackers-win32@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL 8.0.3 and Ipv6
12+ messages / 7 participants
[nested] [flat]

* PostgreSQL 8.0.3 and Ipv6
@ 2005-08-16 19:05  Solange <voss@arnet.com.br>
  0 siblings, 1 reply; 12+ messages in thread

From: Solange @ 2005-08-16 19:05 UTC (permalink / raw)
  To: pgsql-patches@postgresql.org

Hi, I am with problems to function postgreSQL 8.0.3 in 
 windows XP with the Ipv6 protocol. I try to have access the 
 bank in the following way: 

 psql -h ::1 -d db_teste -u postgres

 but it gives an error: could not translate ::1: Unknown host.
 already I configured the archive pg_hba.conf so that it has 
 accepted address::1 of ipv6. My machine is effecting ping6 in 
 ::1 and my apache server also is functioning in ipv6. I made 
 everything what it said in the manual. 

My question is the following one: PostgreSQL does not function in windows XP 
with the Ipv6 protocol, or has that to configure plus some 
 thing? Or It only functions in linux? 
Necessary of some patch so that it functions in windows Xp?

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-16 19:32  Andrew Dunstan <andrew@dunslane.net>
  parent: Solange <voss@arnet.com.br>
  0 siblings, 1 reply; 12+ messages in thread

From: Andrew Dunstan @ 2005-08-16 19:32 UTC (permalink / raw)
  To: Solange <voss@arnet.com.br>; +Cc: pgsql-hackers-win32


[moving lists]

First, this question should not be on the -patches list. Please read the 
mailing list descriptions carefully before posting and use the right one 
- in this case probably the -hackers-win32 list.

IPv6 is a build time setting, and it appears that the current build 
environment used for Windows (or at least mine) does not support IPv6. 
It looks for struct sockaddr_in6 and fails to find it, apparently.

In fact, I am surprised that your postmaster doesn't complain if you put 
an IPv6 address in pg_hba.conf.

cheers

andrew



Solange wrote:

> Hi, I am with problems to function postgreSQL 8.0.3 in 
> windows XP with the Ipv6 protocol. I try to have access the 
> bank in the following way: 
>
>  psql -h ::1 -d db_teste -u postgres
>
>  but it gives an error: could not translate ::1: Unknown host.
>  already I configured the archive pg_hba.conf so that it has 
> accepted address::1 of ipv6. My machine is effecting ping6 in 
> ::1 and my apache server also is functioning in ipv6. I made 
> everything what it said in the manual.
>  
> My question is the following one: PostgreSQL does not function in 
> windows XP
> with the Ipv6 protocol, or has that to configure plus some 
> thing? Or It only functions in linux?
> Necessary of some patch so that it functions in windows Xp?




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-16 21:54  Andrew Dunstan <andrew@dunslane.net>
  parent: Andrew Dunstan <andrew@dunslane.net>
  0 siblings, 0 replies; 12+ messages in thread

From: Andrew Dunstan @ 2005-08-16 21:54 UTC (permalink / raw)
  To: pgsql-hackers-win32; +Cc: voss@arnet.com.br


Researching this some more, I see:

/mingw/include/ws2tcpip.h:struct sockaddr_in6 {

do we need to include this somewhere?

cheers

andrew

Andrew Dunstan said:
>
> [moving lists]
>
> First, this question should not be on the -patches list. Please read
> the  mailing list descriptions carefully before posting and use the
> right one  - in this case probably the -hackers-win32 list.
>
> IPv6 is a build time setting, and it appears that the current build
> environment used for Windows (or at least mine) does not support IPv6.
> It looks for struct sockaddr_in6 and fails to find it, apparently.
>
> In fact, I am surprised that your postmaster doesn't complain if you
> put  an IPv6 address in pg_hba.conf.
>
> cheers
>
> andrew
>
>
>
> Solange wrote:
>
>> Hi, I am with problems to function postgreSQL 8.0.3 in
>> windows XP with the Ipv6 protocol. I try to have access the
>> bank in the following way:
>>
>>  psql -h ::1 -d db_teste -u postgres
>>
>>  but it gives an error: could not translate ::1: Unknown host.
>>  already I configured the archive pg_hba.conf so that it has
>> accepted address::1 of ipv6. My machine is effecting ping6 in
>> ::1 and my apache server also is functioning in ipv6. I made
>> everything what it said in the manual.
>>
>> My question is the following one: PostgreSQL does not function in
>> windows XP
>> with the Ipv6 protocol, or has that to configure plus some
>> thing? Or It only functions in linux?
>> Necessary of some patch so that it functions in windows Xp?
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: explain analyze is your
> friend






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-17 06:55  Magnus Hagander <mha@sollentuna.net>
  0 siblings, 1 reply; 12+ messages in thread

From: Magnus Hagander @ 2005-08-17 06:55 UTC (permalink / raw)
  To: Andrew Dunstan <andrew@dunslane.net>; pgsql-hackers-win32; +Cc: voss@arnet.com.br

> Researching this some more, I see:
> 
> /mingw/include/ws2tcpip.h:struct sockaddr_in6 {
> 
> do we need to include this somewhere?

Probably.
Note that most of what's in that file is only supported on win2000 and
newer, IIRC. So I'm unsure wether we can include it unconditionally - it
has to be tested.

//Magnus



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-17 12:57  Andrew Dunstan <andrew@dunslane.net>
  parent: Magnus Hagander <mha@sollentuna.net>
  0 siblings, 1 reply; 12+ messages in thread

From: Andrew Dunstan @ 2005-08-17 12:57 UTC (permalink / raw)
  To: Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-hackers-win32



Magnus Hagander wrote:

>>Researching this some more, I see:
>>
>>/mingw/include/ws2tcpip.h:struct sockaddr_in6 {
>>
>>do we need to include this somewhere?
>>    
>>
>
>Probably.
>Note that most of what's in that file is only supported on win2000 and
>newer, IIRC. So I'm unsure wether we can include it unconditionally - it
>has to be tested.
>
>
>  
>

Ouch! Remind me again why we decided to support NT4?

Does anyone have an NT4 build enviroment that they can test patches on 
if I come up with a fix? I sure don't.

cheers

andrew



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-17 17:04  Petr Jelinek <pjmodos@seznam.cz>
  parent: Andrew Dunstan <andrew@dunslane.net>
  0 siblings, 0 replies; 12+ messages in thread

From: Petr Jelinek @ 2005-08-17 17:04 UTC (permalink / raw)
  To: Andrew Dunstan <andrew@dunslane.net>; +Cc: pgsql-hackers-win32@postgresql.org, Magnus Hagander <mha@sollentuna.net>

Andrew Dunstan wrote:
> 
> Ouch! Remind me again why we decided to support NT4?
> 
> Does anyone have an NT4 build enviroment that they can test patches on 
> if I come up with a fix? I sure don't.

The truth is that IPv6 isn't even in Windows 2000.
There is some "technology preview" ipv6 implementation for Windows 2000 
which could be downloaded from MS website but it should not be used in 
production enviroments.

I can test patches on my W2k if needed (I mean I can test if Postgres 
still works without IPv6 support after patching because I don't have IPv6).

-- 
Regards
Petr Jelinek (PJMODOS)



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-18 11:05  Magnus Hagander <mha@sollentuna.net>
  0 siblings, 2 replies; 12+ messages in thread

From: Magnus Hagander @ 2005-08-18 11:05 UTC (permalink / raw)
  To: Andrew Dunstan <andrew@dunslane.net>; +Cc: pgsql-hackers-win32

> >>Researching this some more, I see:
> >>
> >>/mingw/include/ws2tcpip.h:struct sockaddr_in6 {
> >>
> >>do we need to include this somewhere?
> >>    
> >>
> >
> >Probably.
> >Note that most of what's in that file is only supported on 
> win2000 and 
> >newer, IIRC. So I'm unsure wether we can include it 
> unconditionally - 
> >it has to be tested.
> >
> >
> >  
> >
> 
> Ouch! Remind me again why we decided to support NT4?

Because people use it?
We don's supoprt it in the installer, but IIRC we've had a couple of
requests for it. So *somebody* uses it.

I haven't looked at things, but I assume client code is also affected in
some ways? If so, we also support 9x.


> Does anyone have an NT4 build enviroment that they can test 
> patches on if I come up with a fix? I sure don't.

Build, no. Runtime, yes. I keep a couple of vmwares with NT4 around to
do this kind of testing on.

I'd be fine with requiring 2000+ to build as long as it can be *used* on
NT4...

//Magnus



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-18 12:48  Andrew Dunstan <andrew@dunslane.net>
  parent: Magnus Hagander <mha@sollentuna.net>
  1 sibling, 0 replies; 12+ messages in thread

From: Andrew Dunstan @ 2005-08-18 12:48 UTC (permalink / raw)
  To: Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-hackers-win32



Magnus Hagander wrote:

>>Does anyone have an NT4 build enviroment that they can test 
>>patches on if I come up with a fix? I sure don't.
>>    
>>
>
>Build, no. Runtime, yes. I keep a couple of vmwares with NT4 around to
>do this kind of testing on.
>
>I'd be fine with requiring 2000+ to build as long as it can be *used* on
>NT4...
>
>
>  
>
If I manage to get anything built I will get you the binaries to test with.

Right now, having faked out the configure test for getaddrinfo, I am 
snookered by a mingw bug that has gai_strerror defined to a non-existent 
object (In the MS headers it is defined inline in ws2tcpip.h). See 
https://sourceforge.net/tracker/?func=detail&atid=102435&aid=1158095&group_id=2435

This has linking for postmaster failing with unresolved symbol errors.

What a mess. ;-(

cheers

andrew





^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-18 14:37  Joshua D. Drake <jd@commandprompt.com>
  parent: Magnus Hagander <mha@sollentuna.net>
  1 sibling, 0 replies; 12+ messages in thread

From: Joshua D. Drake @ 2005-08-18 14:37 UTC (permalink / raw)
  To: Magnus Hagander <mha@sollentuna.net>; +Cc: Andrew Dunstan <andrew@dunslane.net>; pgsql-hackers-win32


>Build, no. Runtime, yes. I keep a couple of vmwares with NT4 around to
>do this kind of testing on.
>
>I'd be fine with requiring 2000+ to build as long as it can be *used* on
>NT4...
>  
>
NT4 is dead. Let it die. It is very, very old and no longer supported
by Microsoft.

2000+ should be the minimum.

Just curious but would PostgreSQL compile on RedHat 6.2 and run?

Sincerely,

Joshua D. Drake



>//Magnus
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings
>  
>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-19 18:02  Merlin Moncure <merlin.moncure@rcsonline.com>
  0 siblings, 1 reply; 12+ messages in thread

From: Merlin Moncure @ 2005-08-19 18:02 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-hackers-win32

Joshua wrote:
> NT4 is dead. Let it die. It is very, very old and no longer supported
> by Microsoft.
> 
> 2000+ should be the minimum.
> 
> Just curious but would PostgreSQL compile on RedHat 6.2 and run?
> 
Windows NT 4.0 was released in Jul of 1996.  The official release of red
had linux at that time was 3.04 with the upcoming 4.0 in beta.

Just to put things into perspective :).

(I agree with you, let it die!)

Merlin



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-19 18:16  Andrew Dunstan <andrew@dunslane.net>
  parent: Merlin Moncure <merlin.moncure@rcsonline.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Andrew Dunstan @ 2005-08-19 18:16 UTC (permalink / raw)
  To: Merlin Moncure <merlin.moncure@rcsonline.com>; +Cc: Joshua D. Drake <jd@commandprompt.com>; pgsql-hackers-win32



Merlin Moncure wrote:

>Joshua wrote:
>  
>
>>NT4 is dead. Let it die. It is very, very old and no longer supported
>>by Microsoft.
>>
>>2000+ should be the minimum.
>>
>>Just curious but would PostgreSQL compile on RedHat 6.2 and run?
>>
>>    
>>
>Windows NT 4.0 was released in Jul of 1996.  The official release of red
>had linux at that time was 3.04 with the upcoming 4.0 in beta.
>
>Just to put things into perspective :).
>
>
>  
>

All this is irrelevant to the present discussion, as W2K does not 
support what I tried to do.

In any case, EOL date matters far more than release date, and how many 
users there still are matters even more than either date. RH7.3 has been 
EOLed for some time, but I see huge amounts of it still in data centers.


cheers

andrew



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6
@ 2005-08-19 18:36  Dave Page <dpage@vale-housing.co.uk>
  0 siblings, 0 replies; 12+ messages in thread

From: Dave Page @ 2005-08-19 18:36 UTC (permalink / raw)
  To: Merlin Moncure <merlin.moncure@rcsonline.com>; Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-hackers-win32

 

> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org 
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf 
> Of Merlin Moncure
> Sent: 19 August 2005 19:03
> To: Joshua D. Drake
> Cc: pgsql-hackers-win32@postgresql.org
> Subject: Re: [pgsql-hackers-win32] [PATCHES] PostgreSQL 8.0.3 and Ipv6
> 
> Joshua wrote:
> > NT4 is dead. Let it die. It is very, very old and no longer 
> supported
> > by Microsoft.
> > 
> > 2000+ should be the minimum.
> > 
> > Just curious but would PostgreSQL compile on RedHat 6.2 and run?
> > 
> Windows NT 4.0 was released in Jul of 1996.  The official 
> release of red
> had linux at that time was 3.04 with the upcoming 4.0 in beta.
> 
> Just to put things into perspective :).
> 
> (I agree with you, let it die!)

+1

FWIW, pgInstaller won't run fully on NT because we can't initdb as a
different user (the APIs simply aren't there in <2K).

/D



^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2005-08-19 18:36 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-16 19:05 PostgreSQL 8.0.3 and Ipv6 Solange <voss@arnet.com.br>
2005-08-16 19:32 ` Andrew Dunstan <andrew@dunslane.net>
2005-08-16 21:54   ` Andrew Dunstan <andrew@dunslane.net>
2005-08-17 06:55 Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6 Magnus Hagander <mha@sollentuna.net>
2005-08-17 12:57 ` Andrew Dunstan <andrew@dunslane.net>
2005-08-17 17:04   ` Petr Jelinek <pjmodos@seznam.cz>
2005-08-18 11:05 Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6 Magnus Hagander <mha@sollentuna.net>
2005-08-18 12:48 ` Andrew Dunstan <andrew@dunslane.net>
2005-08-18 14:37 ` Joshua D. Drake <jd@commandprompt.com>
2005-08-19 18:02 Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6 Merlin Moncure <merlin.moncure@rcsonline.com>
2005-08-19 18:16 ` Andrew Dunstan <andrew@dunslane.net>
2005-08-19 18:36 Re: [PATCHES] PostgreSQL 8.0.3 and Ipv6 Dave Page <dpage@vale-housing.co.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox