Re: Linux vs FreeBSD - Mailing list pgsql-general

On 11/04/2014 13:05, Alban Hertroys wrote:
> On 11 Apr 2014, at 8:04, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>
>> Basically it goes beyond what ppl would describe as OS holly wars.
>> If one chooses to go by FreeBSD, then he better be prepared to handle the burden, both the part that is
>> imposed by the OS administration itself, as well as the part that is a side effect of the different base system.
>>
>> Example of admin part :
>> Generally, compiling postgresql from source gives more freedom than be stuck on the OS's ports or PKGng
>> system. (the later being a very handy and welcome addition to FreeBSD).
>> Now what if e.g. the user wants pgsql software X (e.g. pgadmin3, p5-Pg, etc...) only to find out that most of those
>> ports need postgresql client as a dependency. He/she must be prepared to work his way through :
>> - manual installations (gmake config && gmake && gmake install)
>> - /usr/ports
>> - PKG binary installations
>> in decreasing order of freedom but increasing order of easiness, and in many cases work through a combination
>> of the above.
> That argument holds for any package system on any OS I know of. Once you start custom compiling things outside the
controlof the package management system, you’re on your own. 
I am not against FreeBSD in any way, as a matter of fact i am struggling for about 20 years
to keep it alive at least in my working environment, being my primary development workstation.
> Custom compiling may give more freedom, but it’s hardly ever necessary on FreeBSD. For example, the only ports that I
everhad to custom compile were ports for software I was developing, which of course no package management system can
keeptrack of. 
Try to install/setup PgSQL-backed openldap with unixODBC when your KDE has iodbc as a prerequisite.
Or try to install pljava, for which of course no OS port/OS package/PgSQL extension exists, yet.
Good luck with any of those.
> In general, the various options the port Makefile provides for customisation are quite sufficient. It’s a plus to the
portssystem that you get any options at all. 
>
>> Example of base system part :
>> Recently I had to install pl-java on my FreeBSD workstation. There was a problem with libtrh, postgresql should be
recompiled
>> with explicitly setting : -lpthread in /usr/local/src/postgresql-9.3.4/src/backend/Makefile, without this the
backendwould simply hang 
>> at the very first invocation of a java function. This came after detailed following or email exchange of various
hackersgroups 
>> in both pgsql and FreeBSD lists, to describe the issue as accurately as possible, to help debug as most as possible,
totalk 
>> to the right people, to give them incentive to answer back, etc.
> It seems to me that the reason you were custom compiling Postgres in the first place was a problem with the port. I’m
suretracking down the problem wasn’t easy, but that is not really relevant to the topic. Ports break sometimes (on any
OS)and it would have been sufficient to contact the port maintainer about the issue. 
No, i wasn't compiling postgresql from standard distribution because of a problem with the port.
(although the port had the same exact behavior)
I always run postgresql compiled by hand, since I see no reason to sacrifice my peace of mind
for a short-lived joy going with the ports or PKGng system.
As a matter of fact, PostgreSQL is among the few software packages that i would advice strongly
against using ports or pkgs of any kind. Might work in Debian. Would not risk this in FreeBSD.
> For a quick (temporary) fix, you could probably have fixed the port by editing the port Makefile. With that, there’s
noreason anymore to “custom compile” postgres and it leaves the dependency tracking of the port in place. Editing
Makefilesis indeed not for everyone, but at least you _can_ do that on FreeBSD. Not every package management system
willlet you do that. 
Sure, but the way to do this is not by simply editing a Makefile, but with writing an extra patch
inside /usr/ports/databases/postgresql93-server/files/ . Which is more burden than easiness.
> And yes, I have edited Makefiles, although the need hasn’t risen recently.
With plain vanilla ports it is rarely needed.
>> I don't mean to scare the OP, but FreeBSD is not for everyone.
> And that (again) could be said about any OS. Even Windows or OS X.
> It depends on what you intend to use it for and what prior experience, preconceptions and expectations you might
have.
Playing with words aside, going with FreeBSD is not for the average Ubuntu user.
>
> Oh, and please try not to top-post when replying on this list.
I did just for this message, because i did not feel appropriate to quote anything that the previous
poster wrote.
>> On 11/04/2014 00:50, Jan Wieck wrote:
>>> On 04/10/14 17:25, Christofer C. Bell wrote:
>>>> I'm not wanting to get after anyone here, but I want it on the record
>>>> that I am not the source of the above quote discouraging the use of
>>>> Ubuntu in a server role.  That would be Bruce Momjian. While Bruce is
>>>> entitled to his opinion, it's not one I agree with and I don't want a
>>>> Google search years from now to tie my name to that viewpoint.
>>> Who (in their right mind) would ever think of anything but BSD in a server role?
>>>
>>> <shaking head>
>>>
>>>
>>> Jan
> Alban Hertroys
> --
> If you can't see the forest for the trees,
> cut the trees and you'll find there is no forest.
>
>
>


--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt