pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: clayton cottingham <clayton@marketingchallenge.com>
To: Joe Conway <joe@conway-family.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: sqllist <pgsql-sql@postgresql.org>
Subject: Re: psql question
Date: Thu, 23 Nov 2000 15:43:12 -0800
Message-ID: <3A1DAB90.9BDC08E0@marketingchallenge.com> (raw)
References: <Pine.LNX.4.21.0011231929460.1355-100000@peter.localdomain>
	<03db01c05598$fce41590$0705a8c0@jecw2k1>

Joe Conway wrote:
> 
> > > On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows
> use
> > > of the up arrow key for history and the escape/tab key for command
> > > completion, but on my remote web host (webpipe.net) those keys don't
> work.
> > > What do I need to do to get these features working on my remote web
> host?
> > > I've seen reference to .psqlrc in the psql man file, but not much else
> (no
> > > syntax, etc).
> >
> > If you compiled from source, make sure you had the readline-devel package
> > installed.
> >
> 
> Thanks for your responses, Peter & Mathijs.
> 
> Actually, since the issue is on a hosted system, I don't have access to
> recompile. I was hoping that maybe there would be something I could
> configure from my own (non-root and non-postgres) account.
> 
> My question actaully took several days just to make it to the list, so in
> the meantime I found my own work-around -- I copied local copies of psql and
> libpq up to my account on the web host. Then I put my own account folder to
> the front of the PATH and added a LD_LIBRARY_PATH. Now when I run 'psql' it
> works just like on my own machine!
> 
> Thanks again for the response.
> 
> Joe


you could use a version of pgsql on your own machine and use the host
switch to connect to an extrenal db

of course your db isp will have to allow your ip to connect, not an easy
thing if your dial up!!


this way you could recompile your own ver of psql

hope that helps



view thread (11+ messages)  latest in thread

Message-ID: <3A1DAB90.9BDC08E0@marketingchallenge.com>
Permalink:  ../3A1DAB90.9BDC08E0@marketingchallenge.com/
Also on:    postgresql.org/message-id/3A1DAB90.9BDC08E0@marketingchallenge.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: clayton@marketingchallenge.com, joe@conway-family.com, peter_e@gmx.net
  Subject: Re: psql question
  In-Reply-To: <3A1DAB90.9BDC08E0@marketingchallenge.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox