Home > Could Not > Could Not Save History To File Pgsql

Could Not Save History To File Pgsql

Johnson Hi Martijn. Since you're done installing, I doubt you'll ever see the message again. More Information: The version of postgresql that is being installed is 9.3 and I'm installing it on Ubuntu Server 14.04 LTS postgresql ubuntu share|improve this question edited Nov 12 '15 at where can I say psql that it must > >> write .psql_history into the datadir? > >> > > > > psql tries to write there because the home directory of have a peek at this web-site

I'm guessingit's a Tiger issue but I don't know what to do about it.This was answered by Tom Lane in the NOVICE list recently. Please refer to the help center for possible explanations why a question might be removed. Wife Works in LA. A Page of Puzzling Employer offering Roth 401k as well as traditional 401(k), established in career Why do Latin nouns (like cena, -ae) include two forms? http://dba.stackexchange.com/questions/68705/could-not-save-history-to-file-var-lib-postgresql-psql-history-no-such-file

Steps taken to install: $ sudo apt-get install postgresql postgresql-contrib $ sudo apt-get install pgadmin3 Problem occurs: [email protected]:~$ sudo -u postgres psql postgres psql (9.3.4) Type "help" Changed in postgresql-common (Ubuntu): status: New → Confirmed Phil (philip-olson-m) wrote on 2014-10-09: #2 Same issue - not EC2 instance but home server with default install of postgresql Diagnostics Description: Ubuntu Johnson wrote:...could not save history to file "/usr/local/pgsql//.psql_history": Unknownerror: 0...though I'm just now running it under Mac OS X Tiger (10.4.6).

JohnstonDate: 2015-03-14 01:55:18 Subject: Re: bogus psql "could not save history file[...]" message in 9.3.6 Previous:From: Tom LaneDate: 2015-03-14 01:42:28 Subject: Re: bogus psql "could not save history file[...]" message in Subscribing... drwxr-xr-x 3 postgres postgres 4096 Jun 26 14:54 9.3 -rw------- 1 postgres postgres 19 Jun 26 14:58 .psql_history Diagnostics [email protected]:~$ lsb_release -rd Description: Ubuntu 14.04 LTS Release: 14.04 [email protected]:~$ apt-cache policy Since that directory doesn't exist, the PSQL program cannot access that folder to create its history file. (PSQL is the interactive command line for PGSQL).

Why did Sansa refuse to leave with Sandor Cleagane (Hound) during the Battle of Blackwater? Honestly, it's not that big of a deal. How do organic chemistry mechanisms become accepted? You're not logged in to your system as postgres are you?

Even after I did initdb and then created my test database in the /var/lib/postgres/data/ directory, a .psql_history file was not created. Why do Latin nouns (like cena, -ae) include two forms? Save PL/pgSQL output from PostgreSQL to a CSV file Repairing Postgresql after upgrading to OSX 10.7 Lion Can not connect to local PostgreSQL PostgreSQL error 'Could not connect to server: No reply Tweet Search Discussions Search All Groups PostgreSQL pgsql-general 4 responses Oldest Nested Martijn van Oosterhout I don't know about the platform, but shouldn't that refer to your home directory?

Does gunlugger AP ammo affects all armor? Unfortunately, as I said in my original post, using the .psqlrc option to set the HISTFILE to the user directory didn't work either. Affecting: postgresql-common (Ubuntu) Filed here by: freshi When: 2006-02-24 Assigned: 2006-02-24 Completed: 2006-03-08 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab in effect it is a very little problem if you consider that probably I will call psql from normal accounts... :-) thanks Il giorno dom, 28/06/2009 alle 01.04 +0930, Shane Ambler

Why was the plane going to Dulles? http://strobelfilms.com/could-not/could-not-save-history-to-file.html Mark as duplicate Convert to a question Link a related branch Link to CVE You are not directly subscribed to this bug's notifications. Probably better to use HISTFILE to change it (\set HISTFILE > > '/path/to/histfile'). > > > > Regards. > > > > > You do know that you don't need to If you > run psql from your normal user account the history file will be saved > into your home folder not the postgresql install/data file dir. > > > --

Not the answer you're looking for? securing the sql server ? Wife Works in LA. Source Seems to be the same problem as bug 32696 which was marked as fixed back in 2006.

So now, what version of libedit have you got? (On Red Hat > "rpm -q libedit" would be the thing to do, but I have no idea about > Ubuntu's package I've tried to uninstall it many times but I always have some kind of error when I install it back. I'm not sure what may have happened in your uninstall process to remove that, but it looks like that's the cause of the error in both of the steps you list.

Seems to be the same problem as bug 32696 which was marked as fixed back in 2006.

ls -la /var/lib/postgresql/ total 12 drwxr-xr-x 3 root root 4096 Feb 24 10:45 . Johnson at Apr 25, 2006 at 1:20 am ⇧ 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 Maikel Zweerink @maikeldus 2015-05-10 18:36:26 +0200 Status changed to closed Please register or sign in to post a comment Assignee No assignee Select assigneeAssign to None Milestone None MilestoneAssign milestone None Johnson wrote:Greetings.Any ideas on how to resolve this problem: test=# \qcould not save history to file "/usr/local/pgsql//.psql_history": PermissiondeniedI don't know about the platform, but shouldn't that refer to your homedirectory?Other installations

reply | permalink Jerry LeVan David, It appears that the problem is related to the fact that MacOSX does not really use the libreadline (checks and you will see that it What does this symbol of a car balancing on two wheels mean? Parents disagree on type of music for toddler's listening Help, my office wants infinite branch merges as policy; what other options do we have? have a peek here reply | permalink David F.

drwxr-xr-x 42 root root 4096 Feb 24 10:45 .. Browse other questions tagged database postgresql ubuntu-14.04 postgresql-9.3 or ask your own question. KretschmerDate: 2009-06-29 08:02:32 Subject: Re: uniqueness constraint with NULLs Previous:From: Leo MannhartDate: 2009-06-29 07:23:51 Subject: Re: uniqueness constraint with NULLs Privacy Policy | About PostgreSQL Copyright © 1996-2016 The PostgreSQL Global I'm guessingit'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_historybe/usr/local/pgsql/.psql_historyThere's no difference (semantically) between the