Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5C42E633E66 for ; Wed, 25 Feb 2009 18:59:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43151-07 for ; Wed, 25 Feb 2009 18:59:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenexf2.nrc.ca (nrccenexf2.nrc.ca [132.246.15.83]) by mail.postgresql.org (Postfix) with ESMTP id 56A02633DB6 for ; Wed, 25 Feb 2009 18:59:51 -0400 (AST) Received: from nrccenexf2.nrc.ca ([132.246.15.83]) by nrccenexf2.nrc.ca with Microsoft SMTPSVC(6.0.3790.3959); Wed, 25 Feb 2009 17:59:49 -0500 Received: from [192.168.11.209] ([132.246.15.69]) by nrccenexf2.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Wed, 25 Feb 2009 17:59:49 -0500 Message-ID: <49A5CD64.3040802@nrc-cnrc.gc.ca> Date: Wed, 25 Feb 2009 14:59:48 -0800 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: Vladimir Rusinov Subject: issues with psql after upgrade References: <49A441C4.3040806@nrc-cnrc.gc.ca> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 25 Feb 2009 22:59:49.0667 (UTC) FILETIME=[C2DC2730:01C9979C] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.461 tagged_above=0 required=5 tests=URIBL_BLACK=1.961, URI_NOVOWEL=0.5 X-Spam-Level: ** X-Archive-Number: 200902/219 X-Sequence-Number: 31440 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 > > 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/