Thread: Re: your mail
Moved off of -announce ... On Mon, 2 Aug 1999, Diana Eichert wrote: > hi > > i'm not a Linux user, but an OpenBSD user. recently Louis > Bertrand posted some requests for assistance in getting ODBC support to > work on the postgres port to openbsd. i didn't see many responses to his > requests, though I saw lots of discussions re: Linux problems. I'm not much into ODBC myself, so can't help much, but could you have Louis repost his problem. The problem is that the 'Linux community' makes up a very very large chunk (sadly *grin*) of our user base...but not necessarily a large chunk of the developers. I don't know if there are any OpenBSD "developers" right now...I'm FreeBSD, as I believe Vadim is, Bruce is BSD/OS, and Thomas is Linux...I don't know what anyone else is...except D'Arcy, who's Net/BSD ... Vince, I believe, is FreeBSD also ... so there is a pretty good proportion of *BSD users out there, but I don't think any of us use ODBC vs 'straight interfaces'... Basically, if you are non-Linux in this world nowadays, you have to learn to be a little more pushy to get your point across :( > I'd like to use PostgreSQL, but it doesn't seem like there is > much interest from this community in assisting an OpenBSD developer. > I'll change databases before I change OS's. > > Sorry if this sounds like sour grapes, just call 'em like I see them > > Diana Eichert > Network Systems Analyst > Sandia National Laboratories > > On Mon, 2 Aug 1999, The Hermit Hacker wrote: > > > > > LinuxDev.Net is currently conducting a poll of "The Most Popular DBMS", at > > http://linuxdev.net. Currently, PostgreSQL ia in second place, with 21 > > out of 84 votes, while MySQL is in first with 33... > > > > Even if you aren't using Linux, take a minute and make your vote...we like > > to see PostgreSQL on top, no? :) > > > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy > > Systems Administrator @ hub.org > > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org > > > > > > > > > Diana Eichert > deichert@wrench.com > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
The Hermit Hacker <scrappy@hub.org> writes:
> Basically, if you are non-Linux in this world nowadays, you have to learn
> to be a little more pushy to get your point across :(
Or, go and do it yourself. I think the real problem here is that the
people who use OpenBSD *and* ODBC *and* Postgres probably form a pretty
small group. Sitting back and waiting for someone else to fix problems
seen only (?) in that combination may be a long wait. Roll up your
sleeves and help make it better, instead.
regards, tom lane
Hello all, I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a limited target audience for this port, but that audience won't get any bigger if nobody does anything about it. Like Diana, I chose my OS first and my database engine second. However, my choice of OS shouldn't dictate that I must settle for second-best applications, hence the effort to port pgsql and its various components. I think I played by The Rules[TM] of freenix software with my posts to the ports mailing list: well researched to the limits of my abilities, showing what and where I thought the problem was, and asking specific questions. Marc and Tom's replies make me sound like all I did was whine that "it doesn't work". To be fair to the PostgreSQL developer team, Bruce Momjian was very helpful in orienting me to the way the project has configured the builds and the OS dependencies with Autoconf and Gmake. I posted first in the PostgreSQL lists because I hoped the group would be more focused. I got _no_ reply, not even hints (I think I got buried in the flurry of 64-bit issues). Maybe I should have been more pushy, but that's history now. With both specific problems, a repost to the OpenBSD misc list brought the answer from experienced OpenBSD developers. I have a preliminary port of PostgreSQL that optionally builds pgaccess and libpgsqlodbc.so. I'm now working on making sure the regression tests perform correctly (at least on i386) and that the man pages get built and installed correctly (the old OpenBSD port didn't make them). When it's ready, I will submit the entire package to the OpenBSD ports maintainers. The preliminary version is available from me directly. Ciao--Louis <louis@bertrandtech.on.ca> Louis Bertrand http://www.bertrandtech.on.ca Bertrand Technical Services, Bowmanville, ON, Canada OpenBSD: Secure by default. http://www.openbsd.org/ On Mon, 2 Aug 1999, Tom Lane wrote: > The Hermit Hacker <scrappy@hub.org> writes: > > Basically, if you are non-Linux in this world nowadays, you have to learn > > to be a little more pushy to get your point across :( > > Or, go and do it yourself. I think the real problem here is that the > people who use OpenBSD *and* ODBC *and* Postgres probably form a pretty > small group. Sitting back and waiting for someone else to fix problems > seen only (?) in that combination may be a long wait. Roll up your > sleeves and help make it better, instead. > > regards, tom lane > > >
Louis Bertrand <louis@bertrandtech.on.ca> writes:
> Marc and Tom's replies make me sound like all I did was whine that "it
> doesn't work".
I certainly didn't mean to sound like I was casting aspersions on *you*.
It sounds like you've done what needed to be done --- excellent!
Thank you.
> ... When it's ready, I will submit the entire package to the OpenBSD
> ports maintainers.
Please also submit any necessary source diffs to the pgsql-patches
mailing list, so that they will get into future releases.
regards, tom lane
heh, i've got a thick skin, if you were casting apersions towards me, so be it. all i really care about is that PostgreSQL runs under OpenBSD, i'd like to use it. thanks everyone for PostgreSQL thanks Louis for the effort he has put into getting all of PostgreSQL running under OpenBSD. just another whiny enduser, diana On Mon, 2 Aug 1999, Tom Lane wrote: > I certainly didn't mean to sound like I was casting aspersions on *you*. > Diana Eichert deichert@wrench.com
On Mon, 2 Aug 1999, Louis Bertrand wrote:
> Hello all,
>
> I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a
> limited target audience for this port, but that audience won't get any
> bigger if nobody does anything about it. Like Diana, I chose my OS first
> and my database engine second. However, my choice of OS shouldn't dictate
> that I must settle for second-best applications, hence the effort to port
> pgsql and its various components.
>
> I think I played by The Rules[TM] of freenix software with my posts to the
> ports mailing list: well researched to the limits of my abilities, showing
> what and where I thought the problem was, and asking specific questions.
> Marc and Tom's replies make me sound like all I did was whine that "it
Marc who?? unless I black'd out the episode, this is the first I've read
about it...*raised eyebrow* And if I gave the impression that I thought
you were whining, I do apologize, as it was not my intention to do so...
> Maybe I should have been more pushy, but that's history
> now. With both specific problems, a repost to the OpenBSD misc list
> brought the answer from experienced OpenBSD developers.
Just curious, but what turned out to be the problem, and is it something
we can/should change in the source tree to prevent it in the future?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
On Mon, 2 Aug 1999, The Hermit Hacker wrote: > On Mon, 2 Aug 1999, Louis Bertrand wrote: > > > Hello all, > > > > I'm the guy trying to build the 6.5.1 port for OpenBSD. I agree there is a > > limited target audience for this port, but that audience won't get any > > bigger if nobody does anything about it. Like Diana, I chose my OS first > > and my database engine second. However, my choice of OS shouldn't dictate > > that I must settle for second-best applications, hence the effort to port > > pgsql and its various components. > > > > I think I played by The Rules[TM] of freenix software with my posts to the > > ports mailing list: well researched to the limits of my abilities, showing > > what and where I thought the problem was, and asking specific questions. > > Marc and Tom's replies make me sound like all I did was whine that "it > > Marc who?? unless I black'd out the episode, this is the first I've read > about it...*raised eyebrow* And if I gave the impression that I thought > you were whining, I do apologize, as it was not my intention to do so... ooops, too wide a tar brush. Sorry. > > Just curious, but what turned out to be the problem, and is it something > we can/should change in the source tree to prevent it in the future? > 1) EGCS in OpenBSD no longer defines symbol i386, using the namespace-friendly __i386__ instead. I suspect there will be a similar problem with SPARC and maybe others. I had to add: bsd.h: #ifdef(__i386__) #define i386 #endif 2) When building libpgsqlodbc.so, /usr/lib/libcompat.a on OpenBSD had a problem with doubly defining symbol _v8_regerror(). I'm not even sure why pgsql's build uses libcompat.a because it's not needed to resolve anything. I patched src/configure.in to remove the AC_CHECK_LIB(compat,main) macro. OpenBSD-current has been changed to remove the doubly-defined symbol, but the port should still be able to work with earlier released CD-ROM versions. 3) src/bin/pg_passwd/pg_passwd.c is patched to change the password length from the hard-coded 14 with _PASSWORD_LEN of 128. It was like that in the previous (6.3.2) port and FreeBSD has it also, so I just updated it. Ciao--Louis <louis@bertrandtech.on.ca> Louis Bertrand http://www.bertrandtech.on.ca Bertrand Technical Services, Bowmanville, ON, Canada OpenBSD: Secure by default. http://www.openbsd.org/
On Tue, 3 Aug 1999, Louis Bertrand wrote:
> > Just curious, but what turned out to be the problem, and is it something
> > we can/should change in the source tree to prevent it in the future?
> >
> 1) EGCS in OpenBSD no longer defines symbol i386, using the
> namespace-friendly __i386__ instead. I suspect there will be a similar
> problem with SPARC and maybe others. I had to add:
> bsd.h:
> #ifdef(__i386__)
> #define i386
> #endif
Okay, I know that Bruce did some patches for this, changing i386 ->
__i386__, so that v6.6 will have it, and v6.5.2 *might* ... I'm the one
working on back-patching that...
> 2) When building libpgsqlodbc.so, /usr/lib/libcompat.a on OpenBSD had a
> problem with doubly defining symbol _v8_regerror(). I'm not even sure why
> pgsql's build uses libcompat.a because it's not needed to resolve
> anything. I patched src/configure.in to remove the
> AC_CHECK_LIB(compat,main) macro. OpenBSD-current has been changed to
> remove the doubly-defined symbol, but the port should still be able to
> work with earlier released CD-ROM versions.
hrmmm...let me look at patching configure.in such that 'if openbsd' it
doesn't get added...I've never seen the problem with FreeBSD, so it must
be an 'OpenBSD' specific problem...
> 3) src/bin/pg_passwd/pg_passwd.c is patched to change the password length
> from the hard-coded 14 with _PASSWORD_LEN of 128. It was like that in the
> previous (6.3.2) port and FreeBSD has it also, so I just updated it.
Will look at this one too...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
On Mon, 2 Aug 1999, The Hermit Hacker wrote: > Okay, I know that Bruce did some patches for this, changing i386 -> > __i386__, so that v6.6 will have it, and v6.5.2 *might* ... I'm the one > working on back-patching that... > OK, I'll look at it again when 6.5.2 or 6.6 gets released. I'll also see what happens with other architectures. > hrmmm...let me look at patching configure.in such that 'if openbsd' it > doesn't get added...I've never seen the problem with FreeBSD, so it must > be an 'OpenBSD' specific problem... > Yes, it was specific to OpenBSD. It's fixed in -current now. I'll keep the patch in my 6.5.1 port and update it as needed. Ciao--Louis <louis@bertrandtech.on.ca> Louis Bertrand http://www.bertrandtech.on.ca Bertrand Technical Services, Bowmanville, ON, Canada OpenBSD: Secure by default. http://www.openbsd.org/