Postgres in a solaris zone - patch 125077-02 needed

On Mon, 8 Sep 2008, Markova, Nina wrote:

I wasn't able to find 125077-02 patch for SPARC, and contacted SUN last
week - they are very slow.

It wasn't released; according to
http://www.mail-archive.com/pca@lists.univie.ac.at/msg00199.html that fix
made its way into 120011-09 instead.

I'm not so sure you actually need this though.
http://bugs.opensolaris.org/view_bug.do;jsessionid=1ce76d3cbf20747f874eb1a300df?bug_id=6546052
suggests there's actually a bug in how the checkinstall script looks for
the file that prevent it from installing in a zone. Looks just like your
report. That says the s10u4_07 update fixes the problem. I don't know
enough about Solaris packaging to suggest exactly what to do here, but
that should get you moving in the right direction rather than chasing a
non-existant patch.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

Markova, Nina napsal(a):

Hi,

I am working on installing postgres ina zone - zoneadm install command
finished with errors :

Error: /usr/lib/libkrb5.so.1 not found.
Please install the patch for 6381288 (we should expose the krb5 api).
The patch needed is 125077-02 for SPARC and 125078-02 for x86 systems.
pkgadd: ERROR: checkinstall script did not complete successfully

I wasn't able to find 125077-02 patch for SPARC, and contacted SUN last
week - they are very slow.

Had anybody encountered the same problem? How have you solved it? Do you
by chance have patch in question handy, so you can email it to me.

What version of postgreSQL and Solaris (include update version) do you
use? Do you use official solaris'es packages? Kerberos 5 has been
integrated in Solaris 10 update 4.

Zdenek

bug_id 6546052 is already fixed in the PostgreSQL 8.2 packages on the
Solaris S10 update 4 DVD. The "Fixed in Build: s10u4_07" reference in
the bug means that it was fixed in build 7 of S10u4, which is prior to
general release. If the bug was fixed after release of S10u4 (and could
therefore affect you), it would be fixed in a build of a later update.

So I don't know of any other bugs with this particular checkinstall
script. It's looking for the /usr/lib/libkrb5.so.1 library, which was
introduced with Solaris 10 in update 4. The library was also made
available in (sparc) patch 125077-02, which was never released, but
replaced by 120011-09.

So if you are running S10u4 (or later) then you *should* have
/usr/lib/libkrb5.so.1. If you do, maybe there *is* another problem with
the package checkinstall script. Did you get the PostgreSQL 8.2 packages
from somewhere other than the S10u4 DVD?

If you're running S10u3 (or earlier), then you need to install patch
120011-09 (or later) to get /usr/lib/libkrb5.so.1.

Greg Smith wrote:

On Mon, 8 Sep 2008, Markova, Nina wrote:

I wasn't able to find 125077-02 patch for SPARC, and contacted SUN last
week - they are very slow.

It wasn't released; according to
http://www.mail-archive.com/pca@lists.univie.ac.at/msg00199.html that
fix made its way into 120011-09 instead.

I'm not so sure you actually need this though.
http://bugs.opensolaris.org/view_bug.do;jsessionid=1ce76d3cbf20747f874eb1a300df?bug_id=6546052
suggests there's actually a bug in how the checkinstall script looks for
the file that prevent it from installing in a zone. Looks just like
your report. That says the s10u4_07 update fixes the problem. I don't
know enough about Solaris packaging to suggest exactly what to do here,
but that should get you moving in the right direction rather than
chasing a non-existant patch.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

--
Jim Gates Sun Microsystems
Nashua, NH, USA http://sun.com/postgresql

Thanks all.

I have the /usr/lib/libkrb5.so.1 but somehow the checkinstall script
can't find it (it is s10u4). As a result in the non-global zone these
<SUNWpostgr-82-client> and <SUNWpostgr-82-lib> are missing, they exist
in the global zone though.

Nina

-----Original Message-----
From: James Gates [mailto:james.gates@sun.com]
Sent: September 9, 2008 09:43
To: Markova, Nina
Cc: Greg Smith; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres in a solaris zone - patch 125077-02
needed

bug_id 6546052 is already fixed in the PostgreSQL 8.2 packages on the
Solaris S10 update 4 DVD. The "Fixed in Build: s10u4_07" reference in
the bug means that it was fixed in build 7 of S10u4, which is prior to
general release. If the bug was fixed after release of S10u4 (and could
therefore affect you), it would be fixed in a build of a later update.

So I don't know of any other bugs with this particular checkinstall
script. It's looking for the /usr/lib/libkrb5.so.1 library, which was
introduced with Solaris 10 in update 4. The library was also made
available in (sparc) patch 125077-02, which was never released, but
replaced by 120011-09.

So if you are running S10u4 (or later) then you *should* have
/usr/lib/libkrb5.so.1. If you do, maybe there *is* another problem with
the package checkinstall script. Did you get the PostgreSQL 8.2 packages
from somewhere other than the S10u4 DVD?

If you're running S10u3 (or earlier), then you need to install patch
120011-09 (or later) to get /usr/lib/libkrb5.so.1.

Greg Smith wrote:

On Mon, 8 Sep 2008, Markova, Nina wrote:

I wasn't able to find 125077-02 patch for SPARC, and contacted SUN

last

week - they are very slow.

It wasn't released; according to
http://www.mail-archive.com/pca@lists.univie.ac.at/msg00199.html that
fix made its way into 120011-09 instead.

I'm not so sure you actually need this though.

http://bugs.opensolaris.org/view_bug.do;jsessionid=1ce76d3cbf20747f874eb
1a300df?bug_id=6546052

suggests there's actually a bug in how the checkinstall script looks

for

the file that prevent it from installing in a zone. Looks just like
your report. That says the s10u4_07 update fixes the problem. I

don't

know enough about Solaris packaging to suggest exactly what to do

here,

but that should get you moving in the right direction rather than
chasing a non-existant patch.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore,

MD

--
Jim Gates Sun Microsystems
Nashua, NH, USA http://sun.com/postgresql

Hi,

After issuning initdb and starting the postgres server, I checked for processes running, expecting to see just one:

postgres 4926 4924 0 14:44:52 ? 0:00 /usr/postgres/8.2/bin/postgres
postgres 4924 1 0 14:44:52 pts/1 0:00 /usr/postgres/8.2/bin/postgres
postgres 4929 4850 0 14:44:56 pts/1 0:00 grep postgres
postgres 4928 4850 0 14:44:56 pts/1 0:00 ps -ef
postgres 4927 4924 0 14:44:52 ? 0:00 /usr/postgres/8.2/bin/postgres

Only one of them is in postmaster.pid. What the other ones are for?

more /pg_data/postmaster.pid
4924
/pg_data
5432001 31

Thanks,

-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------
Nina Markova,
Database Analyst / Analyst de base de données
(613) 992-3753 facsimile / télécopieur (613) 992-8836
nmarkova@nrcan.gc.ca

Geological Survey of Canada / Commission géologique du Canada
Natural Resources Canada / Ressources naturelles Canada
Government of Canada / Gouvernement du Canada
-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------

--- On Tue, 9/9/08, Markova, Nina <nmarkova@NRCan.gc.ca> wrote:

From: Markova, Nina <nmarkova@NRCan.gc.ca>
Subject: [GENERAL] 3 postgres processes
To: pgsql-general@postgresql.org
Date: Tuesday, September 9, 2008, 2:50 PM
Hi,

After issuning initdb and starting the postgres server, I
checked for processes running, expecting to see just one:

postgres 4926 4924 0 14:44:52 ? 0:00
/usr/postgres/8.2/bin/postgres
postgres 4924 1 0 14:44:52 pts/1 0:00
/usr/postgres/8.2/bin/postgres
postgres 4929 4850 0 14:44:56 pts/1 0:00 grep
postgres
postgres 4928 4850 0 14:44:56 pts/1 0:00 ps -ef
postgres 4927 4924 0 14:44:52 ? 0:00
/usr/postgres/8.2/bin/postgres

Only one of them is in postmaster.pid. What the other ones
are for?

more /pg_data/postmaster.pid
4924
/pg_data
5432001 31

Thanks,

use ps auxw to see more details of the process

i think the processes are one of this

writer process
wal writer process
autovacuum launcher process
stats collector process

Then there would seem to be another problem with the checkinstall script
and non-global zones (although this was tested).

I'll look into it, but I need to reproduce it. Can you tell me exactly
what you've done so far (commands that you used to create the non-global
zone, commands you're using to install the PostgreSQL packages, where
you got the packages, etc).

If you're calling the pkgadd command directly, can you please run it
again and add the "-v" argument (this will trace the checkinstall script).

Markova, Nina wrote:

Thanks all.

I have the /usr/lib/libkrb5.so.1 but somehow the checkinstall script
can't find it (it is s10u4). As a result in the non-global zone these
<SUNWpostgr-82-client> and <SUNWpostgr-82-lib> are missing, they exist
in the global zone though.

Nina

-----Original Message-----
From: James Gates [mailto:james.gates@sun.com]
Sent: September 9, 2008 09:43
To: Markova, Nina
Cc: Greg Smith; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres in a solaris zone - patch 125077-02
needed

bug_id 6546052 is already fixed in the PostgreSQL 8.2 packages on the
Solaris S10 update 4 DVD. The "Fixed in Build: s10u4_07" reference in
the bug means that it was fixed in build 7 of S10u4, which is prior to
general release. If the bug was fixed after release of S10u4 (and could
therefore affect you), it would be fixed in a build of a later update.

So I don't know of any other bugs with this particular checkinstall
script. It's looking for the /usr/lib/libkrb5.so.1 library, which was
introduced with Solaris 10 in update 4. The library was also made
available in (sparc) patch 125077-02, which was never released, but
replaced by 120011-09.

So if you are running S10u4 (or later) then you *should* have
/usr/lib/libkrb5.so.1. If you do, maybe there *is* another problem with
the package checkinstall script. Did you get the PostgreSQL 8.2 packages
from somewhere other than the S10u4 DVD?

If you're running S10u3 (or earlier), then you need to install patch
120011-09 (or later) to get /usr/lib/libkrb5.so.1.

Greg Smith wrote:

On Mon, 8 Sep 2008, Markova, Nina wrote:

I wasn't able to find 125077-02 patch for SPARC, and contacted SUN

last

week - they are very slow.

It wasn't released; according to
http://www.mail-archive.com/pca@lists.univie.ac.at/msg00199.html that
fix made its way into 120011-09 instead.

I'm not so sure you actually need this though.

http://bugs.opensolaris.org/view_bug.do;jsessionid=1ce76d3cbf20747f874eb
1a300df?bug_id=6546052

suggests there's actually a bug in how the checkinstall script looks

for

the file that prevent it from installing in a zone. Looks just like
your report. That says the s10u4_07 update fixes the problem. I

don't

know enough about Solaris packaging to suggest exactly what to do

here,

but that should get you moving in the right direction rather than
chasing a non-existant patch.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore,

MD

--
Jim Gates Sun Microsystems
Nashua, NH, USA http://sun.com/postgresql