Re: "save history" problem

Hi Martijn.

Thanks for the tip on there being no real difference in the two paths (i.e.,
I'm not a Unix guy).

Unfortunately, as I said in my original post, using the .psqlrc option to
set the HISTFILE to the user directory didn't work either.

After changing ownership of the /usr/local/pgsql/ to the postgres user, the
history file mechanism works (i.e., the history is saved in the
.psql_history file), but this message is reported:

could not save history to file "/usr/local/pgsql//.psql_history": Unknown
error: 0

There's no .psqlrc file so it's just using the default. Since the message
is benign I'll just ignore it (like Jerry Levan does :)

Thanks,
David

On 4/24/06 1:59 PM, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote:

> On Sun, Apr 23, 2006 at 09:33:40PM -0400, David F. Johnson wrote:
>> Greetings.
>>
>> Any ideas on how to resolve this problem:
>
> <snip>
>
>> test=# \q
>> could not save history to file "/usr/local/pgsql//.psql_history": Permission
>> denied
>
> I don't know about the platform, but shouldn't that refer to your home
> directory?
>
>> Other installations of stable releases of 8.x.x did not have this problem,
>> though I'm just now running it under Mac OS X Tiger (10.4.6). I'm guessing
>> it's a Tiger issue but I don't know what to do about it.
>
> Something like: \set HISTFILE 'blah' should do it, check the docs.
>
>> That said, shouldn't
>> /usr/local/pgsql//.psql_history
>> be
>> /usr/local/pgsql/.psql_history
>
> There's no difference (semantically) between the two...
>
> Have a nice day,