Re: BUG #12344: libcurses issue with psql binary of Solaris package

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(at)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(at)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(at)sarenet(dot)es <mailto:egoitz(at)sarenet(dot)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(at)sarenet(dot)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(at)sarenet(dot)es <mailto:egoitz(at)sarenet(dot)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(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> escribió:
>>
>> egoitz(at)sarenet(dot)es <mailto:egoitz(at)sarenet(dot)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
>