Thread: Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Zdenek Kotala
Date:

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.teer@rite-group.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

Index: doc/FAQ_Solaris
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/FAQ_Solaris,v
retrieving revision 1.23
diff -c -r1.23 FAQ_Solaris
*** doc/FAQ_Solaris    2 Dec 2006 09:29:51 -0000    1.23
--- doc/FAQ_Solaris    23 Feb 2007 16:12:19 -0000
***************
*** 16,21 ****
--- 16,22 ----
  6) Where I can download prepared Solaris packages?
  7) How can I tune PostgreSQL and Solaris for performance?
  8) Can I use DTrace for tracing PostgreSQL?
+ 9) Can I compile PostgreSQL with Kerberos v5 support?


  1) What tools do I need to build and install PostgreSQL on Solaris?
***************
*** 72,85 ****
  This is probably a case of the run-time linker being unable to find
  some library, probably libz, libreadline or some other non-standard
  library such as libssl.  To point it to the right location, set the
! LD_LIBRARY_PATH environment variable, e.g.,

!     LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib
!     export LD_LIBRARY_PATH

! and restart configure.  You will also have to keep this setting whenever
! you run any of the installed PostgreSQL programs.   Alternatively, set
! the environment variable LD_RUN_PATH.  See the ld(1) man page for more
  information.


--- 73,84 ----
  This is probably a case of the run-time linker being unable to find
  some library, probably libz, libreadline or some other non-standard
  library such as libssl.  To point it to the right location, set the
! LDFLAGS environment variable, e.g.,

!     LDFLAGS="-R /usr/sfw/lib:/opt/sfw/lib:/usr/local/lib"
!     export LDFLAGS

! and restart configure. See the ld(1) man page for more
  information.


***************
*** 145,150 ****
--- 144,153 ----
  Yes, see the chapter "Monitoring Database Activity" in the documentation
  for further information.

+ You can also find more information here:
+
+     http://blogs.sun.com/robertlor/entry/user_level_dtrace_probes_in
+
  If you see the linking of the postgres executable abort with an error
  message like

***************
*** 157,164 ****
      gmake: *** [postgres] Error 1

  your DTrace installation is too old to handle probes in static
! functions.  You need Solaris 10u3 or newer.

- You can also find more information here:
-
-     http://blogs.sun.com/robertlor/entry/user_level_dtrace_probes_in
--- 160,176 ----
      gmake: *** [postgres] Error 1

  your DTrace installation is too old to handle probes in static
! functions.  You need Solaris 10u4 or newer. Workaround is remove static
! keyword from AbortTransaction and CommitTransaction functions declaration in
! src/backend/access/transam/xact.c.
!
! See http://sunsolve.sun.com/search/document.do?assetkey=1-1-2139224-1
! (registration required).
!
! 9) Can I compile PostgreSQL with Kerberos v5 support?
!
! Kerberos is integrated in OpenSolaris and will be integrated in Solaris 10u4. GSS security
! mechanism contains internal Kerberos v5 library implementation which provide all necessary
! krb5 function. However, usage this library is only on own risk. It is private library
! and interface may change without notice.


Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Bruce Momjian
Date:
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.teer@rite-group.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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Peter Eisentraut
Date:
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/

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Bruce Momjian
Date:
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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Zdenek Kotala
Date:
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

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Rich Teer
Date:
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

Re: [BUGS] BUG #2969: Inaccuracies in Solaris FAQ

From
Bruce Momjian
Date:
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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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