Thread: psqlrc file on RHEL5

I have installed pg 8.3.6 from source code and I want to configure the
psqlrc file , BUT can't find to much tips and documentation:
Can anyone provide a good working copy here and the location/path where
to store this file  > ( /etc/sysconfig/pgsql/is empty !!!)
Isabella

My concern is after a PG upgrade to 8.3.6 the psql behavior has been
changed : can't use  history line anymore .
 The updates to .psql_history file  has been stopped after upgrade, so I
was looking to create my own psqlrc file.
Note :  PG  upgrade has been installed using the tarball file ( source
code) with .confgure --with -inlude=/usr/inlude/readline

thank you
Isabella

Vladimir Rusinov wrote:
>
>
>
>
> On Tue, Feb 24, 2009 at 9:51 PM, Isabella Ghiurea
> <isabella.ghiurea@nrc-cnrc.gc.ca
> <mailto:isabella.ghiurea@nrc-cnrc.gc.ca>> wrote:
>
>     I have installed pg 8.3.6 from source code and I want to configure
>     the psqlrc file , BUT can't find to much tips and documentation:
>     Can anyone provide a good working copy here and the location/path
>     where to store this file  > ( /etc/sysconfig/pgsql/is empty !!!)
>     Isabella
>
>
> First of all, you might want to use yum overlay for RHEL/CentOS:
> http://yum.postgresqlrpms.org/
>
> Next, why do you need this file and what do you expect to be there?
>
>
> --
> Vladimir Rusinov
> http://greenmice.info/

Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> writes:
> My concern is after a PG upgrade to 8.3.6 the psql behavior has been
> changed : can't use  history line anymore .

Apparently you failed to build it with readline support.  The correct
response is to fix that; no amount of fooling with psqlrc files will
help.

            regards, tom lane

Hi Tom,
As per your advise I removed the old PG 8.3.6 installation and run again
configure and compiled the pg src.
here is my configure settings , mentioned the psql behavior have not
changed , I''m still not able to use history line from readline.
./configure --prefix=/opt/pgsql/  --with-includes=/usr/include/
--with-libs=/usr/include/readline/
make all
make  install

thank you
Isabell
a


Tom Lane wrote:
>
> Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> writes:
> > My concern is after a PG upgrade to 8.3.6 the psql behavior has been
> > changed : can't use  history line anymore .
>
> Apparently you failed to build it with readline support.  The correct
> response is to fix that; no amount of fooling with psqlrc files will
> help.
>
>                         regards, tom lane
>

On Thu, 2009-02-26 at 01:08 +0300, Vladimir Rusinov wrote:
> First of all, you might want to use yum overlay for RHEL/CentOS:
> http://yum.postgresqlrpms.org/

http://yum.pgsqlrpms.org is a better URL (the other one is also valid,
but still...)
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

Thank you, but my problem is : psql can't make use of readline cmd line
history. I don't have a .psql_history file in my  .~/ dir.
I installed/upgrade PG 8.3.6 from tarball as user postgress, psql will
conect to db but not history cmd line so far...any tips ?
OS: RHEL 5-64 bits

 ldd /opt/pgsql/bin/psql
        libpq.so.5 => /opt/pgsql//lib/libpq.so.5 (0x00002ad404616000)
        libz.so.1 => /usr/lib64/libz.so.1 (0x000000334f000000)
        libreadline.so.5 => /usr/lib64/libreadline.so.5 (0x000000334f800000)
        libtermcap.so.2 => /lib64/libtermcap.so.2 (0x000000334f400000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003360600000)
        libdl.so.2 => /lib64/libdl.so.2 (0x000000334e400000)
        libm.so.6 => /lib64/libm.so.6 (0x000000334e800000)
        libc.so.6 => /lib64/libc.so.6 (0x000000334e000000)
        /lib64/ld-linux-x86-64.so.2 (0x000000334dc00000)


Devrim GÜNDÜZ wrote:
> On Thu, 2009-02-26 at 01:08 +0300, Vladimir Rusinov wrote:
>
>> First of all, you might want to use yum overlay for RHEL/CentOS:
>> http://yum.postgresqlrpms.org/
>>
>
> http://yum.pgsqlrpms.org is a better URL (the other one is also valid,
> but still...)
>