Re: large objects - Mailing list pgsql-hackers

From Nigel J. Andrews
Subject Re: large objects
Date
Msg-id Pine.LNX.4.21.0306081923050.2705-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to large objects  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-hackers

Repost just to add the information that this is [now] on 7.3.3, previously on
7.3.2.

Sorry for the noise of the incomplete previous message, although the email
lists seem to be very light this last week. Obviously the mail server is still
feeling under the weather, I presume many posts have been lost in a hole
somewhere much like another of my posts.


On Sun, 8 Jun 2003, Nigel J. Andrews wrote:

>
> Note, primary list address changed to -general, I'd suggest any followups
> remove the -hackers, which I've left in just for 'closure'.
>
>
> On Fri, 6 Jun 2003, Nigel J. Andrews wrote:
>
> > On Fri, 6 Jun 2003, Tom Lane wrote:
> >
> > > "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > > > Now, I did a little bit of testing and when doing a \lo_export <oid>
> > > > <filename> in psql connected via localhost a SIGPIPE is generated in
> > > > write() in libc and psql quit, without printing any message to the
> > > > terminal.  Perhaps interestingly
> > > > the file that gets written is always 65536 bytes long.
> > >
> > > Hm.  Are you using an SSL connection?  There are some known bugs in the
> > > SSL support in 7.3.1.  It's supposed to be fixed in 7.3.3, though I've
> > > not tried it myself.
> >
> > Damn, yes I am, I noticed the notice when connecting but then didn't think
> > anything of it. Thanks Tom, I'll check that later when I do have time
> > (shouldn't have wasted the precious minutes joining the NULL != "" war).
>
> Ok, I tried to try this but I can not get SSL to _not_ be used when connecting
> via any tcp connection, unless the client hasn't been built with ssl support of
> course. The pg_hba.conf has:
>
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
>
> local      all         all                                             md5
> host       all         all         127.0.0.1         255.255.255.255   md5
>
> psql -U me -h localhost db
>
> prints:
>
> SSL connection (cipher: EDH-RSA-DES-CBC3-SHA, bits: 168)
>
> psql -U me db
>
> doesn't.
>
> Am I losing my mind? Should I need hostssl on that second line of the config
> before ssl is allowed? I did look at that code once a few weeks ago and vaguely
> remember something about host and hostssl handling but can't remember the
> details. Is this really a bug, even if only in the documentation, or have I got
> completely the wrong end of the stick?
>

--
Nigel J. Andrews


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: 7.3.3 COMPILE FAILURE: pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Debugging tool for viewing parse trees?