Thread: Postgres in a solaris zone - patch 125077-02 needed

Postgres in a solaris zone - patch 125077-02 needed

From
"Markova, Nina"
Date:

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.

Thanks,
Nina

Re: Postgres in a solaris zone - patch 125077-02 needed

From
Greg Smith
Date:
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

Re: Postgres in a solaris zone - patch 125077-02 needed

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

Re: Postgres in a solaris zone - patch 125077-02 needed

From
"Markova, Nina"
Date:
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

3 postgres processes

From
"Markova, Nina"
Date:
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----------------------------------------------------------------------------

Re: Postgres in a solaris zone - patch 125077-02 needed

From
James Gates
Date:
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

Re: 3 postgres processes

From
Lennin Caro
Date:
--- 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





Re: Postgres in a solaris zone - patch 125077-02 needed

From
James Gates
Date:
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