Re: installation of postgresql8.0.1 on Solaris 10 - Mailing list pgsql-admin

From Politowicz, Phil
Subject Re: installation of postgresql8.0.1 on Solaris 10
Date
Msg-id D078DAD578D48A46A67AB71E6D23249402B801F8@CTG-MSNEXC01.staff.berbee.com
Whole thread Raw
In response to installation of postgresql8.0.1 on Solaris 10  (olive Mckenzie <olivemckenzie2003@yahoo.com>)
List pgsql-admin
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=0x2000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=256

set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=512
set semsys:seminfo_semmsl=32

Need a system reboot for these to take effect.

After unpacking the install files, I had to export CFLAGS="-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
>
> # 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 <mario.splivalo@mobart.hr> 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."



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

pgsql-admin by date:

Previous
From: Marcin Giedz
Date:
Subject: Re: Server Hardware Configuration
Next
From: Alvaro Herrera
Date:
Subject: Re: Server Hardware Configuration