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@xxxxxxxxx> 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,
