PSQL History not working

Discussion:

Pradeepkumar, Pyatalo (IE10)

2004-12-01 13:25:47 UTC

Hi all,

I am using Postgresql 7.4.3. Everythings working fine except for the psql
history. I did go through the documentation, but did not get much
information about it. The psql doesn't remember the previous commands. There
is no .psql_history file under the $HOME/ and there is no .psqlrc file also.
Its real pain to retype the same command all the time.

Could anyone help me in configuring the .psql_history file.

Thanx in advance.

Regs,
Pradeep

Tom Lane

2004-12-01 15:40:41 UTC

Permalink

Post by Pradeepkumar, Pyatalo (IE10)
I am using Postgresql 7.4.3. Everythings working fine except for the psql
history. I did go through the documentation, but did not get much
information about it. The psql doesn't remember the previous commands. There
is no .psql_history file under the $HOME/ and there is no .psqlrc file also.

It sounds to me like you have a build without the readline library.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Dominic Mitchell

2004-12-01 15:38:29 UTC

Permalink

It sounds like your version of postgres was built without readline
support. I see this output on my FreeBSD box:

% psql -V
psql (PostgreSQL) 7.4.6
contains support for command-line editing

Unless your output contains that, you'll probably have to rebuild
PostgreSQL.

If you don't want to rebuild PostgreSQL, you might want to look at
something like rlwrap[1] which will do the same sort of thing.

-Dom

[1] http://utopia.knoware.nl/~hlub/uck/rlwrap/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster