Re: pg_hba.conf change in 7.4

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Seum-Lim Gan <slgan(at)lucent(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_hba.conf change in 7.4
Date: 2003-12-07 20:54:17
Message-ID: 200312072054.hB7KsHm24183@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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
> >> pgman(at)candle(dot)pha(dot)pa(dot)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 majordomo(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-12-07 21:01:29 Re: pg_hba.conf change in 7.4
Previous Message Tom Lane 2003-12-07 20:24:32 Re: GRANT ON C