[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: [BUGS] BUG #12344: libcurses issue with psql binary of Solaris package
From: Egoitz Aurrekoetxea <egoitz () sarenet ! es>
Date: 2014-12-27 17:35:58
Message-ID: 15D98006-52CC-4776-89C5-0A9826807853 () sarenet ! es
[Download RAW message or body]
Good afternoon,
Ok, so….
Have been debugging all this issue and have seen the following details and \
assumptions :
- Binary package for Solaris downloadable in \
http://www.postgresql.org/ftp/binary/v9.4.0/solaris/solaris11/i386/ \
<http://www.postgresql.org/ftp/binary/v9.4.0/solaris/solaris11/i386/> will probably \
be for Solaris 11.0 not 11.1 or 11.2… unless it seems to be built \
there…
- It has been build with Solaris Studio 11 compilers which don't really know for \
Solaris 11 but for Solaris 11.2 are slightly old…. apart… why this compilers were \
used instead of GCC installable with pkg install?
- Have found in the config (pg_config output) too some flag that seem to be only \
valid for Sparc arch…
And some other thing I did not remember at present instant but I believe saw….
Well like I needed to use Postgresql on Solaris… I rebuilt it… I did use all \
systems default libraries… I didn't install any kind of Sunfreeware or whatever \
library….
So I have build successfully (unless until now, have not seen any issue with the \
binaries) in Solaris 11.2 concretely the OS is:
uname -ar
SunOS themachine 5.11 11.2 i86pc i386 i86pc
cat /etc/release
Oracle Solaris 11.2 X86
Copyright (c) 1983, 2014, Oracle and/or its affiliates. All rights reserved.
Assembled 23 June 2014
with just doing :
pkg install gcc-c++-48 gcc-c-48
export CC='/usr/gcc/4.8/bin/gcc -m64'
export CXX='/usr/gcc/4.8/bin/c++ -m64'
export LDFLAGS='-L/usr/local/lib -R/usr/local/lib'
export CPPFLAGS='-I/usr/local/include'
export CFLAGS='-O3'
export PATH=$PATH':/usr/gnu/bin'
./configure --prefix=/opt/postgres94 --enable-nls \
--with-system-tzdata=/usr/share/lib/zoneinfo --with-tclconfig=/usr/lib --with-python \
--with-tcl --with-pam --with-libedit-preferred --with-libxml --with-libxslt \
--enable-thread-safety --enable-integer-datetimes gmake
gmake install
Perhaps it would be better (instead of providing binaries) to include a script in the \
sources tar.gz that if you were in Solaris (I say in Solaris, because in FreeBSD for \
example, which is the main OS I do use, you build it easilly from ports, and in other \
systems like Linux you normally have prebuilt) which checks the env, the packages \
installed and so… or just directly, to say to everybody… "For installing \
Postgresql in Solaris, you need to have a Virgin Solaris installation and just run \
later the -build-on-solaris.sh-" or whatever script in order to start everybody in \
the same beginning point and later to run a script which for example does this same I \
have wrote before. I would say this is better than having, say old binaries or…. \
and like building, let's say, enforces you to have all required system libraries if \
you want the code to be built if you say everyone to start at the same beginning \
point I think could be perhaps easier to offer an easy way to install Postgresql in \
Solaris.
Thank you very much for you're help and hope this helps too,
Best regards,
Egoitz Aurrekoetxea
Departamento de sistemas
944 209 470
Parque Tecnológico. Edificio 103
48170 Zamudio (Bizkaia)
egoitz@sarenet.es <mailto:egoitz@sarenet.es>
www.sarenet.es <http://www.sarenet.es/>
Antes de imprimir este correo electrónico piense si es necesario hacerlo.
> El 26/12/2014, a las 17:55, pgsql-bugs-owner@postgresql.org escribió:
>
> Your message to pgsql-bugs has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> The author (Egoitz Aurrekoetxea <egoitz@sarenet.es>)
> is not a member of any of the restrict_post groups.
>
> If you do not wish the message to be posted, or have other concerns,
> please send a message to the list owners at the following address:
> pgsql-bugs-owner@postgresql.org
>
> Asunto: Re: [BUGS] BUG #12344: libcurses issue with psql binary of Solaris package
> De: Egoitz Aurrekoetxea <egoitz@sarenet.es>
> Fecha: 26 de diciembre de 2014, 17:55:40 CET
> Cc: pgsql-bugs@postgresql.org
> Para: Tom Lane <tgl@sss.pgh.pa.us>
>
>
> Hello!,
>
> And by the way… have done some checks….
>
> Have just build Postgresql 9.4.0 in Solaris 11.2 with this flags….
>
> export CC='/usr/gcc/4.8/bin/gcc -m64'
> export CXX='/usr/gcc/4.8/bin/c++ -m64'
> export LDFLAGS='-L/usr/local/lib -R/usr/local/lib'
> export CPPFLAGS='-I/usr/local/include'
>
> later
>
> ./configure --prefix=/tmp/postgresql-prueba
> gmake
>
> Just for ensuring was a bug in some Solaris library…… and not a versioning \
> issue (the package is compiled against or whatever….) or whatever…
> /tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# ./psql
> ld.so.1: psql: fatal: libpq.so.5: open failed: No such file or directory
> Killed
>
> It has not build libpq which I don't really know why not… but like was just for \
> the testing purpose…. have copied the Postgresql binary package for Solaris \
> libpq.so* files….
> /tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# cp \
> /usr/postgres/9.4-pgdg/lib/libpq.so* .
> Later…. have done a :
>
> export LD_LIBRARY_PATH='/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql'
> And voilà :
> /tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# ./psql
> psql: FATAL: role "root" does not exist
> root@themachine:/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# ./psql -U \
> thedatabase -h localhost psql (9.4.0)
> Type "help" for help.
>
> thedatabase=# aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
> thedatabase-#
> thedatabase-#
> thedatabase-# ;
> NOTICE: identifier \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" will be \
> truncated to \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
> ERROR: syntax error at or near \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" LINE 1: \
> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa... ^
> thedatabase=# select * from pg_stat_activity;
> thedatabase=# aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
> thedatabase-# ;
> NOTICE: identifier \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" will be \
> truncated to \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
> ERROR: syntax error at or near \
> "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" LINE 1: \
> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa... ^
> thedatabase=#
> thedatabase=#
> thedatabase=#
> thedatabase=# \q
> root@themachine:/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql#
>
> It's not being broken now…… So perhaps is that it was build against for \
> instance Solaris 11 not Solaris 11.2 and some issue exist with that linkage…. \
> done with a previous version…..
> If you tell me how… I wouldn't mind creating it for Solaris 11.2 again the \
> Postgresql package and donating it to you…. What is the proper way of building in \
> Solaris?? With libpq and all components?
> Thank you so much,
> Best regards,
>
>
> Egoitz Aurrekoetxea
> Departamento de sistemas
> 944 209 470
> Parque Tecnológico. Edificio 103
> 48170 Zamudio (Bizkaia)
> egoitz@sarenet.es <mailto:egoitz@sarenet.es>
> www.sarenet.es <http://www.sarenet.es/>
> Antes de imprimir este correo electrónico piense si es necesario hacerlo.
>
> > El 26/12/2014, a las 17:07, Egoitz Aurrekoetxea <egoitz@sarenet.es \
> > <mailto:egoitz@sarenet.es>> escribió:
> > Good afternoon,
> >
> > Thank you so much for the fast response. If I let it that way, without rebuilding \
> > and knowing the issue in one of the libraries mentioned by you, could this just \
> > bug end by affecting the Postgresql server part in some way?.
> > Thank you so much,
> > Best regards,
> >
> >
> > Egoitz Aurrekoetxea
> > Departamento de sistemas
> > 944 209 470
> > Parque Tecnológico. Edificio 103
> > 48170 Zamudio (Bizkaia)
> > egoitz@sarenet.es <mailto:egoitz@sarenet.es>
> > www.sarenet.es <http://www.sarenet.es/>
> > Antes de imprimir este correo electrónico piense si es necesario hacerlo.
> >
> > > El 26/12/2014, a las 16:39, Tom Lane <tgl@sss.pgh.pa.us \
> > > <mailto:tgl@sss.pgh.pa.us>> escribió:
> > > egoitz@sarenet.es <mailto:egoitz@sarenet.es> writes:
> > > > I'm giving a try to
> > > > https://ftp.postgresql.org/pub/binary/v9.4.0/solaris/solaris11/i386/postgresql-9.4.0-S11.i386-64.tar.bz2 \
> > > > <https://ftp.postgresql.org/pub/binary/v9.4.0/solaris/solaris11/i386/postgresql-9.4.0-S11.i386-64.tar.bz2>
> > > > under Solaris 11.2. All seems to be running fine although I have found an
> > > > issue running the psql binary. It generates a core if you hit for example
> > > > CTRL+A after writting an amount of text. I do paste here the test content
> > > > and the core in order to fixed...
> > >
> > > This is evidently a bug in libreadline or libedit (whichever you're
> > > using), and almost certainly has nothing to do with psql proper.
> > >
> > > The mention of el_gets() in the stack trace makes me suspect that it's
> > > libedit, which is not terribly surprising because frankly we've seen a
> > > darn lot of nasty bugs in that library. They do fix 'em, so you could try
> > > getting a newer version of libedit. Or you could get GNU readline and
> > > rebuild against that. TBH I'd recommend the latter solution.
> > >
> > > regards, tom lane
> >
>
>
>
[Attachment #3 (unknown)]
<html><head><meta http-equiv="Content-Type" content="text/html \
charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space;" class="">Good afternoon,<div class=""><br \
class=""></div><div class="">Ok, so….</div><div class=""><br class=""></div><div \
class="">Have been debugging all this issue and have seen the following details and \
assumptions : </div><div class=""><br class=""></div><div class="">- Binary \
package for Solaris downloadable in <a \
href="http://www.postgresql.org/ftp/binary/v9.4.0/solaris/solaris11/i386/" \
class="">http://www.postgresql.org/ftp/binary/v9.4.0/solaris/solaris11/i386/</a> will \
probably be for Solaris 11.0 not 11.1 or 11.2… unless it seems to be built \
there…</div><div class="">- It has been build with Solaris Studio 11 compilers \
which don't really know for Solaris 11 but for Solaris 11.2 are slightly old…. \
apart… why this compilers were used instead of GCC installable with pkg \
install?</div><div class="">- Have found in the config (pg_config output) too some \
flag that seem to be only valid for Sparc arch…</div><div class=""><br \
class=""></div><div class="">And some other thing I did not remember at present \
instant but I believe saw….</div><div class=""><br class=""></div><div \
class="">Well like I needed to use Postgresql on Solaris… I rebuilt it… I did use \
all systems default libraries… I didn't install any kind of Sunfreeware or whatever \
library….</div><div class=""><br class=""></div><div class="">So I have build \
successfully (unless until now, have not seen any issue with the binaries) in Solaris \
11.2 concretely the OS is: </div><div class=""><br class=""></div><div \
class="">uname -ar</div><div class=""><div class="">SunOS themachine 5.11 11.2 i86pc \
i386 i86pc</div><div class=""><br class=""></div><div class="">cat \
/etc/release </div><div class=""> \
Oracle Solaris 11.2 \
X86</div><div class=""> Copyright (c) 1983, 2014, Oracle and/or its affiliates. \
All rights reserved.</div><div class=""> \
Assembled 23 \
June 2014</div></div><div class=""><br class=""></div><div class=""><br \
class=""></div><div class="">with just doing : </div><div class=""><br \
class=""></div><div class="">pkg install gcc-c++-48 gcc-c-48</div><div class=""><br \
class=""></div><div class=""><div class="">export CC='/usr/gcc/4.8/bin/gcc \
-m64'</div><div class="">export CXX='/usr/gcc/4.8/bin/c++ -m64'</div><div \
class="">export LDFLAGS='-L/usr/local/lib -R/usr/local/lib'</div><div class="">export \
CPPFLAGS='-I/usr/local/include'</div><div class="">export CFLAGS='-O3'</div><div \
class="">export PATH=$PATH':/usr/gnu/bin'</div><div class=""><br class=""></div><div \
class="">./configure --prefix=/opt/postgres94 --enable-nls \
--with-system-tzdata=/usr/share/lib/zoneinfo --with-tclconfig=/usr/lib --with-python \
--with-tcl --with-pam --with-libedit-preferred --with-libxml --with-libxslt \
--enable-thread-safety --enable-integer-datetimes</div><div \
class="">gmake</div><div class="">gmake install</div></div><div class=""><br \
class=""></div><div class="">Perhaps it would be better (instead of providing \
binaries) to include a script in the sources tar.gz that if you were in Solaris (I \
say in Solaris, because in FreeBSD for example, which is the main OS I do use, you \
build it easilly from ports, and in other systems like Linux </div><div \
class="">you normally have prebuilt) which checks the env, the packages installed and \
so… or just directly, to say to everybody… "For installing Postgresql in Solaris, \
you need to have a Virgin Solaris installation and just run later the \
-build-on-solaris.sh-" or whatever script in order </div><div class="">to start \
everybody in the same beginning point and later to run a script which for example \
does this same I have wrote before. I would say this is better than having, say old \
binaries or…. and like building, let's say, enforces you to have all required \
system libraries if you </div><div class="">want the code to be built if you say \
everyone to start at the same beginning point I think could be perhaps easier to \
offer an easy way to install Postgresql in Solaris.</div><div class=""><br \
class=""></div><div class="">Thank you very much for you're help and hope this helps \
too,</div><div class="">Best regards,</div><div class=""><div class=""> <style \
class=""> body {
font-family:Helvetica, Arial, sans-serif;
font-size:12px;
color:#333;
}
.moz-signature { color:#333!important; }
.firmasarenet {
font-family:Helvetica, Arial, sans-serif;
text-align:left;
color:#333333;
}
.titulosarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:bold;
font-size:12px;
color:#333333;
}
.textosarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:bold;
font-size:12px;
color:#333333;
}
.dptosarenet { }
.imgsarenet { margin:0px 0px 10px 0px }
.imgsarenet img { }
.lnksarenet {
color:#007AC4!important;
font-size:12px;
line-height:1.2;
text-decoration:underline;
}
.firmasarenet a { color:#007ac4!important }
.imprimirsarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:normal;
font-size:10px;
line-height:1.2;
color:#006600
}
</style>
<br class="">
<br class="">
<div style="clear:both; text-align:left;" class="firmasarenet">
<div style="margin:0 0 10px 0" class="imgsarenet"><img \
src="http://www.sarenet.es/estaticos/LogoSarenetEmails.png?13022013" alt="sarenet" \
class=""></div> <div style="font-family:Helvetica, Arial, sans-serif; \
font-weight:bold; font-size:14px; color:#333333" class="titulosarenet"><strong \
class="">Egoitz Aurrekoetxea</strong></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#333333" \
class="dptosarenet">Departamento de sistemas</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#333333" class="textosarenet">944 209 470<br class="">Parque Tecnológico. \
Edificio 103<br class="">48170 Zamudio (Bizkaia)</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#007AC4; line-height:1.2" class="lnksarenet"><a id="mailto" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
href="mailto:egoitz@sarenet.es" class=""><label id="label_email" \
class="">egoitz@sarenet.es</label></a></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#007AC4; \
line-height:1.2" class="lnksarenet"><a href="http://www.sarenet.es" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
class="">www.sarenet.es</a></div> <br class="">
<div style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; \
font-size:10px; color:#A0C361" class="imprimirsarenet">Antes de imprimir este correo \
electrónico piense si es necesario hacerlo.</div> </div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">El 26/12/2014, a las \
17:55, <a href="mailto:pgsql-bugs-owner@postgresql.org" \
class="">pgsql-bugs-owner@postgresql.org</a> escribió:</div><br \
class="Apple-interchange-newline"><div class="">Your message to pgsql-bugs has been \
delayed, and requires the approval <br class="">of the moderators, for the following \
reason(s):<br class=""><br class="">The author (Egoitz Aurrekoetxea <<a \
href="mailto:egoitz@sarenet.es" class="">egoitz@sarenet.es</a>>)<br class=""> \
is not a member of any of the restrict_post groups.<br class=""><br class="">If \
you do not wish the message to be posted, or have other concerns, <br class="">please \
send a message to the list owners at the following address: <br class=""> <a \
href="mailto:pgsql-bugs-owner@postgresql.org" \
class="">pgsql-bugs-owner@postgresql.org</a><br class=""><br class=""><div \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" \
class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif; color:rgba(127, 127, 127, 1.0);" class=""><b class="">Asunto: \
</b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif;" class=""><b class="">Re: [BUGS] BUG #12344: libcurses issue with psql \
binary of Solaris package</b><br class=""></span></div><div style="margin-top: 0px; \
margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span \
style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; \
color:rgba(127, 127, 127, 1.0);" class=""><b class="">De: </b></span><span \
style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" \
class="">Egoitz Aurrekoetxea <<a href="mailto:egoitz@sarenet.es" \
class="">egoitz@sarenet.es</a>><br class=""></span></div><div style="margin-top: \
0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" class=""><span \
style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif; \
color:rgba(127, 127, 127, 1.0);" class=""><b class="">Fecha: </b></span><span \
style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, sans-serif;" \
class="">26 de diciembre de 2014, 17:55:40 CET<br class=""></span></div><div \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" \
class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif; color:rgba(127, 127, 127, 1.0);" class=""><b class="">Cc: \
</b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif;" class=""><a href="mailto:pgsql-bugs@postgresql.org" \
class="">pgsql-bugs@postgresql.org</a><br class=""></span></div><div \
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;" \
class=""><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif; color:rgba(127, 127, 127, 1.0);" class=""><b class="">Para: \
</b></span><span style="font-family: -webkit-system-font, Helvetica Neue, Helvetica, \
sans-serif;" class="">Tom Lane <<a href="mailto:tgl@sss.pgh.pa.us" \
class="">tgl@sss.pgh.pa.us</a>><br class=""></span></div><br class=""><br \
class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" \
class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space;" class="">Hello!,<div class=""><br \
class=""></div><div class="">And by the way… have done some checks….</div><div \
class=""><br class=""></div><div class="">Have just build Postgresql 9.4.0 in Solaris \
11.2 with this flags….</div><div class=""><br class=""></div><div class=""><div \
class="">export CC='/usr/gcc/4.8/bin/gcc -m64'</div><div class="">export \
CXX='/usr/gcc/4.8/bin/c++ -m64'</div><div class="">export LDFLAGS='-L/usr/local/lib \
-R/usr/local/lib'</div><div class="">export CPPFLAGS='-I/usr/local/include'</div><div \
class=""><br class=""></div><div class="">later </div><div class=""><br \
class=""></div><div class=""><div style="margin: 0px; font-size: 10px; font-family: \
Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);" \
class=""> ./configure --prefix=/tmp/postgresql-prueba</div><div style="margin: \
0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); \
background-color: rgb(0, 0, 0);" class=""> gmake</div></div><div class=""><br \
class=""></div><div apple-content-edited="true" class=""> <style class="">
body {
font-family:Helvetica, Arial, sans-serif;
font-size:12px;
color:#333;
}
.moz-signature { color:#333!important; }
.firmasarenet {
font-family:Helvetica, Arial, sans-serif;
text-align:left;
color:#333333;
}
.titulosarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:bold;
font-size:12px;
color:#333333;
}
.textosarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:bold;
font-size:12px;
color:#333333;
}
.dptosarenet { }
.imgsarenet { margin:0px 0px 10px 0px }
.imgsarenet img { }
.lnksarenet {
color:#007AC4!important;
font-size:12px;
line-height:1.2;
text-decoration:underline;
}
.firmasarenet a { color:#007ac4!important }
.imprimirsarenet {
font-family:Helvetica, Arial, sans-serif;
font-weight:normal;
font-size:10px;
line-height:1.2;
color:#006600
}
</style>
Just for ensuring was a bug in some Solaris library…… and not a versioning issue \
(the package is compiled against or whatever….) or whatever… </div><div \
apple-content-edited="true" class=""><br class=""></div><div \
apple-content-edited="true" class=""><div style="margin: 0px; font-size: 10px; \
font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);" \
class="">/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# ./psql</div><div \
style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); \
background-color: rgb(0, 0, 0);" class="">ld.so.1: psql: fatal: libpq.so.5: open \
failed: No such file or directory</div><div style="margin: 0px; font-size: 10px; \
font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);" \
class="">Killed</div> <div apple-content-edited="true" class=""><br \
class=""></div><div apple-content-edited="true" class="">It has not build libpq which \
I don't really know why not… but like was just for the testing purpose…. have \
copied the Postgresql binary package for Solaris libpq.so* files….</div><div \
apple-content-edited="true" class=""><br class=""></div><div style="margin: 0px; \
font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: \
rgb(0, 0, 0);" class="">/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# cp \
/usr/postgres/9.4-pgdg/lib/libpq.so* .</div> <div style="clear:both; \
text-align:left;" class="firmasarenet"> <div style="margin:0 0 10px 0" \
class="imgsarenet"><br class=""></div><div style="margin:0 0 10px 0" \
class="imgsarenet">Later…. have done a : </div><div style="margin:0 0 10px 0" \
class="imgsarenet"><br class=""></div><div style="margin:0 0 10px 0" \
class="imgsarenet"><div style="margin: 0px; font-size: 10px; font-family: Monaco; \
color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);" class="">export \
LD_LIBRARY_PATH='/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql'</div></div><div \
style="margin:0 0 10px 0" class="imgsarenet">And voilà : </div><div \
style="margin:0 0 10px 0" \
class="imgsarenet">/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# \
./psql</div><div style="margin:0 0 10px 0" class="imgsarenet"><div \
class="imgsarenet">psql: FATAL: role "root" does not exist</div><div \
class="imgsarenet">root@themachine:/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# \
./psql -U thedatabase -h localhost</div><div class="imgsarenet">psql \
(9.4.0)</div><div class="imgsarenet">Type "help" for help.</div><div \
class="imgsarenet"><br class=""></div><div class="imgsarenet">thedatabase=# \
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</div><div \
class="imgsarenet">thedatabase-# </div><div \
class="imgsarenet">thedatabase-# </div><div class="imgsarenet">thedatabase-# \
;</div><div class="imgsarenet">NOTICE: identifier \
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" will be \
truncated to "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"</div><div \
class="imgsarenet">ERROR: syntax error at or near \
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"</div><div \
class="imgsarenet">LINE 1: \
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...</div><div \
class="imgsarenet"> ^</div><div \
class="imgsarenet">thedatabase=# select * from pg_stat_activity;</div><div \
class="imgsarenet">thedatabase=# \
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</div><div \
class="imgsarenet">thedatabase-# ;</div><div class="imgsarenet">NOTICE: \
identifier "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" \
will be truncated to \
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"</div><div \
class="imgsarenet">ERROR: syntax error at or near \
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"</div><div \
class="imgsarenet">LINE 1: \
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...</div><div \
class="imgsarenet"> ^</div><div \
class="imgsarenet">thedatabase=# </div><div \
class="imgsarenet">thedatabase=# </div><div \
class="imgsarenet">thedatabase=# </div><div class="imgsarenet">thedatabase=# \
\q</div><div class="imgsarenet">root@themachine:/tmp/prueba-comp-postgres/postgresql-9.4.0/src/bin/psql# </div><div \
class="imgsarenet"><br class=""></div><div class="imgsarenet">It's not being broken \
now…… So perhaps is that it was build against for instance Solaris 11 not Solaris \
11.2 and some issue exist with that linkage…. done with a previous \
version…..</div><div class="imgsarenet"><br class=""></div><div \
class="imgsarenet">If you tell me how… I wouldn't mind creating it for Solaris 11.2 \
again the Postgresql package and donating it to you….</div><div \
class="imgsarenet">What is the proper way of building in Solaris?? With libpq and all \
components?</div><div class="imgsarenet"><br class=""></div><div \
class="imgsarenet">Thank you so much,</div><div class="imgsarenet">Best \
regards,</div></div><div style="margin:0 0 10px 0" class="imgsarenet"><br \
class=""></div><div style="margin:0 0 10px 0" class="imgsarenet"><img \
src="http://www.sarenet.es/estaticos/LogoSarenetEmails.png?13022013" alt="sarenet" \
class=""></div> <div style="font-family:Helvetica, Arial, sans-serif; \
font-weight:bold; font-size:14px; color:#333333" class="titulosarenet"><strong \
class="">Egoitz Aurrekoetxea</strong></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#333333" \
class="dptosarenet">Departamento de sistemas</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#333333" class="textosarenet">944 209 470<br class="">Parque Tecnológico. \
Edificio 103<br class="">48170 Zamudio (Bizkaia)</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#007AC4; line-height:1.2" class="lnksarenet"><a id="mailto" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
href="mailto:egoitz@sarenet.es" class=""><label id="label_email" \
class="">egoitz@sarenet.es</label></a></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#007AC4; \
line-height:1.2" class="lnksarenet"><a href="http://www.sarenet.es/" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
class="">www.sarenet.es</a></div> <br class="">
<div style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; \
font-size:10px; color:#A0C361" class="imprimirsarenet">Antes de imprimir este correo \
electrónico piense si es necesario hacerlo.</div> </div>
</div>
<br class=""><div class=""><blockquote type="cite" class=""><div class="">El \
26/12/2014, a las 17:07, Egoitz Aurrekoetxea <<a href="mailto:egoitz@sarenet.es" \
class="">egoitz@sarenet.es</a>> escribió:</div><br \
class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" \
content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; \
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Good \
afternoon,<div class=""><br class=""></div><div class="">Thank you so much for the \
fast response. If I let it that way, without rebuilding and knowing the issue in one \
of the libraries mentioned </div><div class="">by you, could this just bug end \
by affecting the Postgresql server part in some way?.</div><div class=""><br \
class=""></div><div class="">Thank you so much,</div><div class="">Best \
regards,</div><div class=""><br class=""></div><div class=""><div \
apple-content-edited="true" class=""> <div style="clear:both; text-align:left;" \
class="firmasarenet"> <div style="margin:0 0 10px 0" class="imgsarenet"><img \
src="http://www.sarenet.es/estaticos/LogoSarenetEmails.png?13022013" alt="sarenet" \
class=""></div> <div style="font-family:Helvetica, Arial, sans-serif; \
font-weight:bold; font-size:14px; color:#333333" class="titulosarenet"><strong \
class="">Egoitz Aurrekoetxea</strong></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#333333" \
class="dptosarenet">Departamento de sistemas</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#333333" class="textosarenet">944 209 470<br class="">Parque Tecnológico. \
Edificio 103<br class="">48170 Zamudio (Bizkaia)</div> <div \
style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; font-size:12px; \
color:#007AC4; line-height:1.2" class="lnksarenet"><a id="mailto" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
href="mailto:egoitz@sarenet.es" class=""><label id="label_email" \
class="">egoitz@sarenet.es</label></a></div> <div style="font-family:Helvetica, \
Arial, sans-serif; font-weight:normal; font-size:12px; color:#007AC4; \
line-height:1.2" class="lnksarenet"><a href="http://www.sarenet.es/" style=" \
font-size:12px; color:#007AC4; text-decoration:underline;" \
class="">www.sarenet.es</a></div> <br class="">
<div style="font-family:Helvetica, Arial, sans-serif; font-weight:normal; \
font-size:10px; color:#A0C361" class="imprimirsarenet">Antes de imprimir este correo \
electrónico piense si es necesario hacerlo.</div> </div>
</div>
<br class=""><div class=""><blockquote type="cite" class=""><div class="">El \
26/12/2014, a las 16:39, Tom Lane <<a href="mailto:tgl@sss.pgh.pa.us" \
class="">tgl@sss.pgh.pa.us</a>> escribió:</div><br \
class="Apple-interchange-newline"><div class=""><a href="mailto:egoitz@sarenet.es" \
class="">egoitz@sarenet.es</a> writes:<br class=""><blockquote type="cite" \
class="">I'm giving a try to<br class=""><a \
href="https://ftp.postgresql.org/pub/binary/v9.4.0/solaris/solaris11/i386/postgresql-9.4.0-S11.i386-64.tar.bz2" \
class="">https://ftp.postgresql.org/pub/binary/v9.4.0/solaris/solaris11/i386/postgresql-9.4.0-S11.i386-64.tar.bz2</a><br \
class="">under Solaris 11.2. All seems to be running fine although I have found an<br \
class="">issue running the psql binary. It generates a core if you hit for example<br \
class="">CTRL+A after writting an amount of text. I do paste here the test content<br \
class="">and the core in order to fixed...<br class=""></blockquote><br class="">This \
is evidently a bug in libreadline or libedit (whichever you're<br class="">using), \
and almost certainly has nothing to do with psql proper.<br class=""><br class="">The \
mention of el_gets() in the stack trace makes me suspect that it's<br \
class="">libedit, which is not terribly surprising because frankly we've seen a<br \
class="">darn lot of nasty bugs in that library. They do fix 'em, so you could \
try<br class="">getting a newer version of libedit. Or you could get GNU \
readline and<br class="">rebuild against that. TBH I'd recommend the latter \
solution.<br class=""><br class=""><span class="Apple-tab-span" \
style="white-space:pre"> </span><span class="Apple-tab-span" \
style="white-space:pre"> </span><span class="Apple-tab-span" \
style="white-space:pre"> </span>regards, tom lane<br \
class=""></div></blockquote></div><br \
class=""></div></div></div></blockquote></div><br class=""></div></div><br \
class=""><br class=""></div></blockquote></div><br class=""></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic