Обсуждение: HELP: language option software package not installed
Hello Everyone, It has been sometime since I have installed PostgreSQL. It has been running great with no crashes for like a year! But alas, my faithful Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@ I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk that loaded Perl5. Everything appears to be loaded into /usr/Perl5/5.00503. It looks OK to me but this happens: ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert Then during the gmake: cp Pg.pm blib/lib/Pg.pm AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg) /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c && mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend -DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c /usr/ucb/cc: language optional software package not installed gmake[4]: *** [Pg.o] Error 1 gmake[4]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[3]: *** [Install] Error 2 gmake[3]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[2]: *** [Install] Error 2 gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces' gmake[1]: *** [Install] Error 2 gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src' gmake: *** [Install] Error 2
On Mon, 14 Jan 2002 18:11:59 +0100
"Allan C. Huffman" <huffmana@ppc.pims.org> wrote:
> Hello Everyone,
>
> It has been sometime since I have installed PostgreSQL. It has been
> running great with no crashes for like a year! But alas, my faithful
> Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@
>
> I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk
> that loaded Perl5. Everything appears to be loaded into
> /usr/Perl5/5.00503. It looks OK to me but this happens:
>
> ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert
>
> Then during the gmake:
>
> cp Pg.pm blib/lib/Pg.pm
> AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
> /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
> /usr/perl5/5.00503/ExtUtils/xsubpp -typemap
> /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
> mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
> -DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
> -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
> /usr/ucb/cc: language optional software package not installed
> gmake[4]: *** [Pg.o] Error 1
> gmake[4]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[3]: *** [Install] Error 2
> gmake[3]: Leaving directory
> '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
> gmake[2]: *** [Install] Error 2
> gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'
>
> gmake[1]: *** [Install] Error 2
> gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
> gmake: *** [Install] Error 2
Hi,
You don't have a C compiler installed. Or if you do, it is not picking
it up.
This is a OS problem. It looks like it has not changed since the SunOS 5.X
days...:(
GB
--
GB Clark II | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
It looks like the user you are when you install postgres does not know the path to your compiler. Try installing gcc and use it instead of cc to compile postgres. Make sure your user's .profile has the path to gcc before installing. Heather ----- Original Message ----- From: "Allan C. Huffman" <huffmana@ppc.pims.org> To: <pgsql-admin@postgresql.org>; <shuttr@pims.org> Sent: Monday, January 14, 2002 12:11 PM Subject: [ADMIN] HELP: language option software package not installed > Hello Everyone, > > It has been sometime since I have installed PostgreSQL. It has been > running great with no crashes for like a year! But alas, my faithful > Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@ > > I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk > that loaded Perl5. Everything appears to be loaded into > /usr/Perl5/5.00503. It looks OK to me but this happens: > > ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert > > Then during the gmake: > > cp Pg.pm blib/lib/Pg.pm > AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg) > /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 > /usr/perl5/5.00503/ExtUtils/xsubpp -typemap > /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c && > mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend > -DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC > -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c > /usr/ucb/cc: language optional software package not installed > gmake[4]: *** [Pg.o] Error 1 > gmake[4]: Leaving directory > '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' > gmake[3]: *** [Install] Error 2 > gmake[3]: Leaving directory > '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' > gmake[2]: *** [Install] Error 2 > gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces' > > gmake[1]: *** [Install] Error 2 > gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src' > gmake: *** [Install] Error 2 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
It's all good..... The root of the problem lied in the fact that
the default perl install for Solaris8 was built using SUNWspro (Sun's
compiler), and therefore the Config.pm had flags/paths/arguments to
reflect that compiler.... However, we are using the sunfreeware
installs of GCC and associated tools.... The bottom line is that the
Config.pm had to be adjusted to use GCC instead of cc.... Thanks for
the help.
--Randall
Heather Johnson wrote:
>It looks like the user you are when you install postgres does not know the
>path to your compiler. Try installing gcc and use it instead of cc to
>compile postgres. Make sure your user's .profile has the path to gcc before
>installing.
>
>Heather
>
>----- Original Message -----
>From: "Allan C. Huffman" <huffmana@ppc.pims.org>
>To: <pgsql-admin@postgresql.org>; <shuttr@pims.org>
>Sent: Monday, January 14, 2002 12:11 PM
>Subject: [ADMIN] HELP: language option software package not installed
>
>
>>Hello Everyone,
>>
>>It has been sometime since I have installed PostgreSQL. It has been
>>running great with no crashes for like a year! But alas, my faithful
>>Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@
>>
>>I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk
>>that loaded Perl5. Everything appears to be loaded into
>>/usr/Perl5/5.00503. It looks OK to me but this happens:
>>
>>./configure --with-perl --enable-odbc --enable-syslog --enable-cassert
>>
>>Then during the gmake:
>>
>>cp Pg.pm blib/lib/Pg.pm
>>AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg)
>>/usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
>>/usr/perl5/5.00503/ExtUtils/xsubpp -typemap
>>/usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs >xstmp.c &&
>>mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend
>>-DVERSION=\"1.8.0\" -DXS_VERSION=\"1.8.0\" -KPIC
>>-I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c
>>/usr/ucb/cc: language optional software package not installed
>>gmake[4]: *** [Pg.o] Error 1
>>gmake[4]: Leaving directory
>>'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
>>gmake[3]: *** [Install] Error 2
>>gmake[3]: Leaving directory
>>'/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5'
>>gmake[2]: *** [Install] Error 2
>>gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces'
>>
>>gmake[1]: *** [Install] Error 2
>>gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src'
>>gmake: *** [Install] Error 2
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>
--
Randall S. Shutt
Systems Engineer
Computer Systems and Communications Corporation
A General Dynamics Company
randall@cscc.net
1-703-814-9105
Dear Guys,
May I have a question about the authorization of psql?
By using '\z' in psql context, I can get the description of authorization about each table/view.
r -- SELECT
w -- UPDATE/DELETE
a -- INSERT
R -- RULE
arwR -- ALL
Authoriztion switches are specified as above, but what should I do if I want to grant 'update' without 'delete' to some
table/view?
thank you
Eddy
Dong Meng writes: > Authoriztion switches are specified as above, but what should I do if > I want to grant 'update' without 'delete' to some table/view? Wait for release 7.2. -- Peter Eisentraut peter_e@gmx.net
Eddy, The command you need is: psql> grant update on table_name to username; Banghe Dong Meng wrote: > Dear Guys, > > May I have a question about the authorization of psql? > > By using '\z' in psql context, I can get the description of authorization about each table/view. > > > r -- SELECT > w -- UPDATE/DELETE > a -- INSERT > R -- RULE > arwR -- ALL > > Authoriztion switches are specified as above, but what should I do if I want to grant 'update' without 'delete' to sometable/view? > > thank you > > Eddy > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html