From olivemckenzie2003@yahoo.com Sun Nov 20 10:16:52 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12E09D6814 for ; Sun, 20 Nov 2005 06:16:52 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31920-07 for ; Sun, 20 Nov 2005 10:16:51 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web52012.mail.yahoo.com (web52012.mail.yahoo.com [206.190.48.95]) by svr1.postgresql.org (Postfix) with SMTP id DFCC9D6810 for ; Sun, 20 Nov 2005 06:16:46 -0400 (AST) Received: (qmail 80156 invoked by uid 60001); 20 Nov 2005 10:16:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=rLWzlpuJ7VYWvWuTdnvquSm5y/bTpiJlToAz5u/JI7QjkbTY9wjah3p+AT79I+5cWmMA9e59JdyZYyz08hmBzQA5PVoyp1Ao9g5C5RO7ktYJgdpLwaYwe1jWzFGRwukzLBIDzaeS/M2kRh9KmSf8GRpXmeLpseCv0KA0jL/QuW0= ; Message-ID: <20051120101645.80154.qmail@web52012.mail.yahoo.com> Received: from [86.137.25.78] by web52012.mail.yahoo.com via HTTP; Sun, 20 Nov 2005 02:16:45 PST Date: Sun, 20 Nov 2005 02:16:45 -0800 (PST) From: olive Mckenzie Subject: installation of postgresql8.0.1 on Solaris 10 To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1480979983-1132481805=:79385" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200511/262 X-Sequence-Number: 19635 --0-1480979983-1132481805=:79385 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Is there any one that has postgresql running on Solaris 10. Please could you let me know how you did it. I have had this problem for 2 months and no one seems to know how to solve it. Regards Olive Mckenzie Note I am a student and I need to get this system running in order to develope my dissertation I am running out of time, and becomming quite concern if this is an insurmountable problem. --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. --0-1480979983-1132481805=:79385 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Is there any one that has postgresql running on Solaris 10. Please could you let me know how you did it. I have had this problem for 2 months and no one seems to know how to solve it.
 
 
Regards
 
Olive Mckenzie
 
Note I am a student and I need to get this system running in order to develope my dissertation I am running out of time, and becomming quite concern if this is an insurmountable problem.


Yahoo! FareChase - Search multiple travel sites in one click. --0-1480979983-1132481805=:79385-- From mario.splivalo@mobart.hr Mon Nov 21 09:47:07 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0DE84D9691 for ; Mon, 21 Nov 2005 05:47:07 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91561-07 for ; Mon, 21 Nov 2005 09:47:07 +0000 (GMT) X-Greylist: delayed 00:12:27.007076 by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr1.postgresql.org (Postfix) with ESMTP id E87AAD957E for ; Mon, 21 Nov 2005 05:47:03 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id A31BE17A1F; Mon, 21 Nov 2005 10:47:05 +0100 (CET) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 15055-01-20; Mon, 21 Nov 2005 10:47:05 +0100 (CET) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 8031D17A19; Mon, 21 Nov 2005 10:47:05 +0100 (CET) Subject: Re: installation of postgresql8.0.1 on Solaris 10 From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: olive Mckenzie Cc: pgsql-admin@postgresql.org In-Reply-To: <20051121091904.23944.qmail@web52015.mail.yahoo.com> References: <20051121091904.23944.qmail@web52015.mail.yahoo.com> Content-Type: text/plain Organization: Mob-Art Date: Mon, 21 Nov 2005 10:47:05 +0100 Message-Id: <1132566425.8689.17.camel@ekim> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/272 X-Sequence-Number: 19645 Did you download the source or precompiled binary? It seems to me that either you don't have libreadline.so.4 installed on your system, or your LD_LIBRARY_PATH is not pointing to the right place. Neverthenless, on my system, I have it like this: [flyb] [/tmp/majk/postgresql-8.1.0] 2 > locate libreadline /usr/local/lib/libreadline.so /usr/local/lib/libreadline.so.3 [flyb] [/tmp/majk/postgresql-8.1.0] 2 > But, I downloaded source and compiled postgreSQL myself. I was able to run initdb to create the cluster, then I run the postmaster, psql, everything worked. It's just that compilation took more than two hours on Sun Fire something with UltraSparc2. Mike On Mon, 2005-11-21 at 01:19 -0800, olive Mckenzie wrote: > I typed > > # su postgres > $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > > Then I got the message > > $ ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open > failed: No such file or directory > > Note /usr/local/pgsql/data is owned by postgres > > > Olive > > Mario Splivalo wrote: > On Sun, 2005-11-20 at 02:16 -0800, olive Mckenzie wrote: > > Is there any one that has postgresql running on Solaris 10. > Please > > could you let me know how you did it. I have had this > problem for 2 > > months and no one seems to know how to solve it. > > > > > > Regards > > > > Olive Mckenzie > > > > Note I am a student and I need to get this system running in > order to > > develope my dissertation I am running out of time, and > becomming quite > > concern if this is an insurmountable problem. > > Could you be more specific with the problems you're having? > I'm running > Postgres 7.4.9 on Solaris10 with no troubles. I'm just > compiling > Postgres8.1 to see how it 'behaves'. If you could be more > specific I'd > know what to look in to. > > Mike > > > > > ______________________________________________________________________ > Yahoo! FareChase - Search multiple travel sites in one click. -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two." From philip.politowicz@berbee.com Mon Nov 21 14:47:53 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1DA98DA614 for ; Mon, 21 Nov 2005 10:47:53 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30242-01-6 for ; Mon, 21 Nov 2005 14:47:54 +0000 (GMT) X-Greylist: delayed 01:18:28.120122 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id AFC89DA67B for ; Mon, 21 Nov 2005 10:47:46 -0400 (AST) Received: from ctg-msnexc01.staff.berbee.com (msn-office-flr2.binc.net [64.73.12.254]) by svr2.postgresql.org (Postfix) with ESMTP id 83910F0BEF for ; Mon, 21 Nov 2005 13:29:23 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: installation of postgresql8.0.1 on Solaris 10 Date: Mon, 21 Nov 2005 07:29:19 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] installation of postgresql8.0.1 on Solaris 10 Thread-Index: AcXugVzEWGayTeiuQ1eLu6So8hePIAADD8Sg From: "Politowicz, Phil" To: "olive Mckenzie" Cc: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/277 X-Sequence-Number: 19650 Olive, You must compile from source, as Mike has mentioned; 8.0.1 is not certified on Solaris 10, and you must limit your functionality. If you can at least try 8.0.3, please do so. If you compile from source, check your gcc version. It must be at least as recent as that recommended in the release notes. You must tune the Solaris kernel, with the following entries in /etc/system: set shmsys:shminfo_shmmax=3D0x2000000 set shmsys:shminfo_shmmin=3D1 set shmsys:shminfo_shmmni=3D256 set shmsys:shminfo_shmseg=3D256 =20 set semsys:seminfo_semmap=3D256 set semsys:seminfo_semmni=3D512 set semsys:seminfo_semmns=3D512 set semsys:seminfo_semmsl=3D32 Need a system reboot for these to take effect. After unpacking the install files, I had to export CFLAGS=3D"-O3", then configured the makefile thus: # ./configure --without-readline --enable-thread-safety # gmake # gmake install I could not get Python, or Perl, or OpenSSL to work with this version. Part of that was the absence of current versions of the modules, part was the incompatibility issue. Hope this helps. Philip Politowicz -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Mario Splivalo Sent: Monday, November 21, 2005 3:47 AM To: olive Mckenzie Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] installation of postgresql8.0.1 on Solaris 10 Did you download the source or precompiled binary? It seems to me that either you don't have libreadline.so.4 installed on your system, or your LD_LIBRARY_PATH is not pointing to the right place. Neverthenless, on my system, I have it like this: [flyb] [/tmp/majk/postgresql-8.1.0] 2 > locate libreadline /usr/local/lib/libreadline.so /usr/local/lib/libreadline.so.3 [flyb] [/tmp/majk/postgresql-8.1.0] 2 > But, I downloaded source and compiled postgreSQL myself. I was able to run initdb to create the cluster, then I run the postmaster, psql, everything worked. It's just that compilation took more than two hours on Sun Fire something with UltraSparc2. Mike On Mon, 2005-11-21 at 01:19 -0800, olive Mckenzie wrote: > I typed=20 > =20 > # su postgres > $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > =20 > Then I got the message > =20 > $ ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open > failed: No such file or directory > =20 > Note /usr/local/pgsql/data is owned by postgres > =20 > =20 > Olive >=20 > Mario Splivalo wrote: > On Sun, 2005-11-20 at 02:16 -0800, olive Mckenzie wrote: > > Is there any one that has postgresql running on Solaris 10. > Please > > could you let me know how you did it. I have had this > problem for 2 > > months and no one seems to know how to solve it. > >=20 > >=20 > > Regards > >=20 > > Olive Mckenzie > >=20 > > Note I am a student and I need to get this system running in > order to > > develope my dissertation I am running out of time, and > becomming quite > > concern if this is an insurmountable problem. > =20 > Could you be more specific with the problems you're having? > I'm running > Postgres 7.4.9 on Solaris10 with no troubles. I'm just > compiling > Postgres8.1 to see how it 'behaves'. If you could be more > specific I'd > know what to look in to. > =20 > Mike > =20 >=20 >=20 >=20 > ______________________________________________________________________ > Yahoo! FareChase - Search multiple travel sites in one click.=20 --=20 Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two." ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend