Forum OpenACS Q&A: strange postgres command line behaviour...

1: strange postgres command line behaviour...

Posted by David Kuczek on 11/24/03 09:04 PM

I recently installed oacs5b on a box that somebody installed RH8.0 in German. He probably did some kind of minimal install as not even gcc was installed.

I changed /etc/sysconfig/i18n to:

LANG="en_US"
SUPPORTED="en_US:en"
SYSFONT="latarcyrheb-sun16"

I took out the UTF-8 stuff, as I did with the other machines I administer.

Now I encouter a problem that I don't encounter with any of my other machines. Whenever I do "psql mydb" and get the psql prompt, I cannot auto-complete the sql with tab. Or I get the following stuff, whenever I push the arrow right, left, up or down button:

mydb=# ^[[C^[[B^[[D^[[A

Must be something charset related?!

Any hints?

2: Re: strange postgres command line behaviour... (response to 1)

Posted by David Kuczek on 11/24/03 10:01 PM

Patrick from Zill.net gave me a very valueable hint. He told me to test the libraries that psql was using:

ldd ~postgres/bin/psql

I found out that I was missing three devel rpms:

up2date readline-devel
#readline-devel-4.3-3.i386.r ########################## Done.
up2date libtermcap-devel
#libtermcap-devel-2.0.8-31.i ########################## Done.
up2date zlib
#zlib-devel-1.1.4-8.8x.i386. ########################## Done.

Then I did a "make distclean", "./configure", "make all" and "make install" on Postgres ... everything works now.

Little hint from me: Always install RH as defined in the openacs docs 😊 You will have less trouble...

3: Re: strange postgres command line behaviour... (response to 2)

Posted by Andrei Popov on 11/24/03 10:40 PM

why did you not get postgresql out of RPM in the first place? having gcc on a production (if this is production) machine is a BAD IDEA.

4: Re: strange postgres command line behaviour... (response to 1)

Posted by David Kuczek on 11/26/03 06:45 PM

Hey Andrei,

why is gcc on a production system a bad idea?

Can I use unicode with rpm Postgres?