Re: BUG #2969: Inaccuracies in Solaris FAQ

The following bug has been logged online:

Bug reference: 2969
Logged by: Rich Teer
Email address: rich(dot)teer(at)rite-group(dot)com
PostgreSQL version: 8.2.2
Operating system: Solaris 10
Description: Inaccuracies in Solaris FAQ
Details:

Hi there,

First, many thanks for providing the best open source database! I've
spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
think should be updated.

1. The answer to question 3 (Why does configure complain about a failed test
program?) says to set LD_LIBRARY_PATH to point to the directory containing
the missing libs. While this does work (as does the other suggestion of
using LD_RUN_PATH), the correct answer to this question is to include the
library's path in the executable by using the -R flag, thus avoiding the
need for the end user to mess about with environment variables. For
example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
which uses Sun's OpenSSL.

2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
that Solaris 10u3 or newer is required to handle probes in static functions.
Unfortunately, this is not the case. DTrace can't be enabled when using
update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
required.

Thanks for reading!

Rich Teer,
Author of Solaris Systems Programming

Rich Teer wrote:
> The following bug has been logged online:
>
> Bug reference: 2969
> Logged by: Rich Teer
> Email address: rich(dot)teer(at)rite-group(dot)com
> PostgreSQL version: 8.2.2
> Operating system: Solaris 10
> Description: Inaccuracies in Solaris FAQ
> Details:
>
> Hi there,
>
> First, many thanks for providing the best open source database! I've
> spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
> think should be updated.
>
> 1. The answer to question 3 (Why does configure complain about a failed test
> program?) says to set LD_LIBRARY_PATH to point to the directory containing
> the missing libs. While this does work (as does the other suggestion of
> using LD_RUN_PATH), the correct answer to this question is to include the
> library's path in the executable by using the -R flag, thus avoiding the
> need for the end user to mess about with environment variables. For
> example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
> which uses Sun's OpenSSL.

Yes you have right we use -R for official Solaris package as well. Good
comment.

> 2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
> that Solaris 10u3 or newer is required to handle probes in static functions.
> Unfortunately, this is not the case. DTrace can't be enabled when using
> update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
> required.

Original plan was release new version of DTrace in the update 3. Thanks
for comment. But if you want to use Dtrace on Solaris 10u3 or older you
can remove static from affected function in the transaction manager. It
is not much clean but it works.

Thanks for the comments and I will prepare a patch asap together with
another improvements.

Thanks Zdenek

I have not seen an updated patch for FAQ_Solaris yet.

---------------------------------------------------------------------------

Zdenek Kotala wrote:
> Rich Teer wrote:
> > The following bug has been logged online:
> >
> > Bug reference: 2969
> > Logged by: Rich Teer
> > Email address: rich(dot)teer(at)rite-group(dot)com
> > PostgreSQL version: 8.2.2
> > Operating system: Solaris 10
> > Description: Inaccuracies in Solaris FAQ
> > Details:
> >
> > Hi there,
> >
> > First, many thanks for providing the best open source database! I've
> > spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
> > think should be updated.
> >
> > 1. The answer to question 3 (Why does configure complain about a failed test
> > program?) says to set LD_LIBRARY_PATH to point to the directory containing
> > the missing libs. While this does work (as does the other suggestion of
> > using LD_RUN_PATH), the correct answer to this question is to include the
> > library's path in the executable by using the -R flag, thus avoiding the
> > need for the end user to mess about with environment variables. For
> > example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
> > which uses Sun's OpenSSL.
>
> Yes you have right we use -R for official Solaris package as well. Good
> comment.
>
> > 2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
> > that Solaris 10u3 or newer is required to handle probes in static functions.
> > Unfortunately, this is not the case. DTrace can't be enabled when using
> > update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
> > required.
>
> Original plan was release new version of DTrace in the update 3. Thanks
> for comment. But if you want to use Dtrace on Solaris 10u3 or older you
> can remove static from affected function in the transaction manager. It
> is not much clean but it works.
>
>
> Thanks for the comments and I will prepare a patch asap together with
> another improvements.
>
>
> Thanks Zdenek
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

I work on it. It will be ready until Friday.

Zdenek

Bruce Momjian wrote:
> I have not seen an updated patch for FAQ_Solaris yet.
>
> ---------------------------------------------------------------------------
>
> Zdenek Kotala wrote:
>> Rich Teer wrote:
>>> The following bug has been logged online:
>>>
>>> Bug reference: 2969
>>> Logged by: Rich Teer
>>> Email address: rich(dot)teer(at)rite-group(dot)com
>>> PostgreSQL version: 8.2.2
>>> Operating system: Solaris 10
>>> Description: Inaccuracies in Solaris FAQ
>>> Details:
>>>
>>> Hi there,
>>>
>>> First, many thanks for providing the best open source database! I've
>>> spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
>>> think should be updated.
>>>
>>> 1. The answer to question 3 (Why does configure complain about a failed test
>>> program?) says to set LD_LIBRARY_PATH to point to the directory containing
>>> the missing libs. While this does work (as does the other suggestion of
>>> using LD_RUN_PATH), the correct answer to this question is to include the
>>> library's path in the executable by using the -R flag, thus avoiding the
>>> need for the end user to mess about with environment variables. For
>>> example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
>>> which uses Sun's OpenSSL.
>> Yes you have right we use -R for official Solaris package as well. Good
>> comment.
>>
>>> 2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
>>> that Solaris 10u3 or newer is required to handle probes in static functions.
>>> Unfortunately, this is not the case. DTrace can't be enabled when using
>>> update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
>>> required.
>> Original plan was release new version of DTrace in the update 3. Thanks
>> for comment. But if you want to use Dtrace on Solaris 10u3 or older you
>> can remove static from affected function in the transaction manager. It
>> is not much clean but it works.
>>
>>
>> Thanks for the comments and I will prepare a patch asap together with
>> another improvements.
>>
>>
>> Thanks Zdenek
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>> http://www.postgresql.org/about/donate
>

There is Solaris FAQ update. Please, look on it and let me know any
comments.

Thanks Zdenek

Rich Teer wrote:
> The following bug has been logged online:
>
> Bug reference: 2969
> Logged by: Rich Teer
> Email address: rich(dot)teer(at)rite-group(dot)com
> PostgreSQL version: 8.2.2
> Operating system: Solaris 10
> Description: Inaccuracies in Solaris FAQ
> Details:
>
> Hi there,
>
> First, many thanks for providing the best open source database! I've
> spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
> think should be updated.
>
> 1. The answer to question 3 (Why does configure complain about a failed test
> program?) says to set LD_LIBRARY_PATH to point to the directory containing
> the missing libs. While this does work (as does the other suggestion of
> using LD_RUN_PATH), the correct answer to this question is to include the
> library's path in the executable by using the -R flag, thus avoiding the
> need for the end user to mess about with environment variables. For
> example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
> which uses Sun's OpenSSL.
>
> 2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
> that Solaris 10u3 or newer is required to handle probes in static functions.
> Unfortunately, this is not the case. DTrace can't be enabled when using
> update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
> required.
>
> Thanks for reading!
>
> Rich Teer,
> Author of Solaris Systems Programming
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

Patch applied. Thanks.

---------------------------------------------------------------------------

Zdenek Kotala wrote:
>
>
> There is Solaris FAQ update. Please, look on it and let me know any
> comments.
>
> Thanks Zdenek
>
>
> Rich Teer wrote:
> > The following bug has been logged online:
> >
> > Bug reference: 2969
> > Logged by: Rich Teer
> > Email address: rich(dot)teer(at)rite-group(dot)com
> > PostgreSQL version: 8.2.2
> > Operating system: Solaris 10
> > Description: Inaccuracies in Solaris FAQ
> > Details:
> >
> > Hi there,
> >
> > First, many thanks for providing the best open source database! I've
> > spotted a couple of errors/bits of bad advice in doc/FAQ_Solaris, which I
> > think should be updated.
> >
> > 1. The answer to question 3 (Why does configure complain about a failed test
> > program?) says to set LD_LIBRARY_PATH to point to the directory containing
> > the missing libs. While this does work (as does the other suggestion of
> > using LD_RUN_PATH), the correct answer to this question is to include the
> > library's path in the executable by using the -R flag, thus avoiding the
> > need for the end user to mess about with environment variables. For
> > example, I use "LDFLAGS=-R/usr/sfw/lib ./configure ..." to build Postgres
> > which uses Sun's OpenSSL.
> >
> > 2. The answer to question 8 (Can I use DTrace for tracing PostgreSQL?) says
> > that Solaris 10u3 or newer is required to handle probes in static functions.
> > Unfortunately, this is not the case. DTrace can't be enabled when using
> > update 3 (aka 11/06); the (as yet unreleased) update 4 or newer is
> > required.
> >
> > Thanks for reading!
> >
> > Rich Teer,
> > Author of Solaris Systems Programming
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Zdenek Kotala wrote:
> There is Solaris FAQ update. Please, look on it and let me know any
> comments.

The actual answer to the question "Can I compile PostgreSQL with
Kerberos v5 support?" is "Yes, why not?". I don't think "Can I use
this weird internal private library that seems to provide a similar
interface?" is a "Frequently Asked Question".

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Fri, 23 Feb 2007, Zdenek Kotala wrote:

> There is Solaris FAQ update. Please, look on it and let me know any comments.

Very minor grammatical nits aside, it looks fine to me.
Thanks for updating the FAQ!

Cheers,

--
Rich Teer, SCSA, SCNA, SCSECA, OpenSolaris CAB member

President,
Rite Online Inc.

Voice: +1 (250) 979-1638
URL: http://www.rite-group.com/rich

Peter Eisentraut wrote:
> Zdenek Kotala wrote:
> > There is Solaris FAQ update. Please, look on it and let me know any
> > comments.
>
> The actual answer to the question "Can I compile PostgreSQL with
> Kerberos v5 support?" is "Yes, why not?". I don't think "Can I use
> this weird internal private library that seems to provide a similar
> interface?" is a "Frequently Asked Question".

I don't use Solaris so I don't know if it is frequent issue or not.
I assume the author knows.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Peter Eisentraut wrote:
> Zdenek Kotala wrote:
>> There is Solaris FAQ update. Please, look on it and let me know any
>> comments.
>
> The actual answer to the question "Can I compile PostgreSQL with
> Kerberos v5 support?" is "Yes, why not?". I don't think "Can I use
> this weird internal private library that seems to provide a similar
> interface?" is a "Frequently Asked Question".
>

You have right that it is not frequent question, but my colleagues have
bad experience with people who did it with samba server and it is only
warning "don't do that" for people who want to try it.

If you guess that it is not important, do not hesitate to remove it.

Zdenek

Zdenek Kotala wrote:
> Peter Eisentraut wrote:
> > Zdenek Kotala wrote:
> >> There is Solaris FAQ update. Please, look on it and let me know any
> >> comments.
> >
> > The actual answer to the question "Can I compile PostgreSQL with
> > Kerberos v5 support?" is "Yes, why not?". I don't think "Can I use
> > this weird internal private library that seems to provide a similar
> > interface?" is a "Frequently Asked Question".
> >
>
> You have right that it is not frequent question, but my colleagues have
> bad experience with people who did it with samba server and it is only
> warning "don't do that" for people who want to try it.
>
> If you guess that it is not important, do not hesitate to remove it.

OK, removed.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +