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

Could Not Save History To File Psql History

Why is credit card information not stolen more often? McClane is a NYPD cop. reply | permalink David F. Would presence of MANPADS ground the entire airline industry? have a peek at this web-site

How do you make a Canon 70D show the photo you just took on the rear display? Probably better to use HISTFILE to change it (\set HISTFILE > > '/path/to/histfile'). > > > > Regards. > > > > > You do know that you don't need to After editing this file, removing all relevant lines, the history was gone. I'm presuming you installed your database in a different location.

A published paper stole my unpublished results from a science fair Were Palpatine or Vader ever congratulatory or nice to any of their subordinates? That is, unless you connect to PSQL using your own account and you continue to get a similar error message. 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 Please refer to the help center for possible explanations why a question might be removed.

Wife Works in LA. 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 Join them; it only takes a minute: Sign up Where is psql client history kept? (~/.psql_history non-existant!) up vote 14 down vote favorite 3 A password is visible in my psql more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Note: I am working on Ubuntu 12.04 postgresql psql share|improve this question asked Jul 29 '13 at 13:06 Bentley4 3,31694896 Maybe you are executing psql as a different user? 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 You need todownload and install the real GNU Readline, having eliminated thereadline > whatever symlink. https://www.postgresql.org/message-id/[email protected] drwxr-xr-x 41 root root 4096 Jun 26 14:54 ..

Here are some reference solutions. Why did Sansa refuse to leave with Sandor Cleagane (Hound) during the Battle of Blackwater? In some installations, the location of the postgres user's home directory is /var/lib/postgresql. Technically it doesn't have to be ~/.psql_history.

Then recompile and reinstallPostgreSQL. https://bugs.launchpad.net/bugs/1334714 for help with psql commands\g or terminate with semicolon to execute query\q to quittest=# \qcould not save history to file "/usr/local/pgsql//.psql_history": Permissiondenied==========Other installations of stable releases of 8.x.x did not have Using the locate command I found the history file located in /var/lib/pgsql93/.psql_history. Edit bug mail Other bug subscribers Subscribe someone else • Take the tour • Read the guide © 2004-2016 CanonicalLtd. • Terms of use • Contact Launchpad Support • Blog

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 Check This Out Forum Index » PostgreSQL Installers for Windows, Linux and OS X Go to: Select a forum News & Announcements Website Issues EDB Postgres Advanced Server EDB Postgres Enterprise Manager EDB Postgres For some reason this has to be done manually. Seems to be the same problem as bug 32696 which was marked as fixed back in 2006.

Is it bad form to write mysterious proofs without explaining what one intends to do? securing the sql server ? There's no difference (semantically) between the two... Source sudo usermod --home '/path/to/database' postgres share|improve this answer answered Nov 27 '14 at 23:09 Quolonel Questions 1111 add a comment| up vote 1 down vote If your directory is actually /var/lib/postgres/

Why was the plane going to Dulles? That history file is just a list of commands that were executed inside the PSQL interface. Why do manufacturers detune engines?

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Validate Random Die Tippers Is three knights versus knight really winning? 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 share|improve this answer edited Jun 24 '15 at 13:30 answered Feb 9 '15 at 14:25 SPRBRN 1,04221937 add a comment| Your Answer draft saved draft discarded Sign up or log about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Other Stack Overflow Server Fault

Word for fake religious people When hiking, why is the right of way given to people going up? 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). current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. http://strobelfilms.com/could-not/could-not-save-history-to-file.html 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

Word for fake religious people Are zipped EXE files harmless for Linux servers? streaming replication: one problem & several questions Discussion Navigation viewthread | post Discussion Overview grouppgsql-general @ categoriespostgresql postedApr 24, '06 at 1:40a activeApr 26, '06 at 10:42p posts5 users4 websitepostgresql.org irc#postgresql 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 You need to download and install the real GNU Readline, having eliminated the readline > whatever symlink.

Subscribing... postgres=# select 1; ?column? ---------- 1 (1 row) postgres=# \q could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory postgres(at)vagrant-ubuntu-trusty-64:~$ ls -l /var/lib/postgresql/.psql_history -rw------- 1 postgres postgres 10 asked 2 years ago viewed 4347 times active 11 months ago Related 2Starting postgresql service and specifying data directory1How to change the data directory on Postgresql 9.1 on Ubuntu1Difficulty with Postgis Could large but sparsely populated country control its borders?

whatsspy=# GRANT ALL ON DATABASE whatsspy TO whatsspy; GRANT whatsspy=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO whatsspy; GRANT whatsspy=# \q could not save history to file "/root/.psql_history": But you don't even need to switch user if you do ~postgresql and hit tab (tilde expansion), it then expands to /var/lib/postgresql/. Measuring Water with a Holey Cube How to respond to a ridiculous request from a senior colleague? Browse other questions tagged postgresql ubuntu or ask your own question.

Still it remembers the history of psql.