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

Could Not Save History To File Postgresql

for help with psql commands \g or terminate with semicolon to execute query \q to quit template1=# \q could not save history to file "/var/lib/postgresql/.psql_history": Permission denied [email protected]:~$ Add tags Tag Changed in postgresql-8.1: assignee: nobody → pitti status: Unconfirmed → Confirmed Martin Pitt (pitti) wrote on 2006-03-08: #2 postgresql-common (43.1ubuntu2) dapper; urgency=low . * Merge changes from Debian branch (mainly robustness http://inventtheweb.blogspot.ca/2012/05/install-postgresql-for-django.html After I finish running the CREATE DATABASE command and run \q I get the following response. 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). have a peek at this web-site

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 Johnston" writes: >> On Fri, Mar 13, 2015 at 6:13 PM, Tom Lane wrote: >>> Running ldd on the psql executable would be a good first step. > >> Report a bug This report contains Public information Edit Everyone can see this information. Is this behaviour is normal...? have a peek here

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 Looks like you block unknown database users. –Frank Heikens Mar 12 '15 at 10:56 @FrankHeikens thanks, added to the question. –Richard Mar 12 '15 at 11:01 add a comment| Thank you very much. –Richard Mar 12 '15 at 11:22 Check the manual for things like this: postgresql.org/docs/current/interactive/auth-pg-hba-conf.htm‌l If you change "peer" to "md5", you can connect the way

Subscribing... How to send the ESC signal to vim when my esc key doesn't work? You are trying to connect as the 'prescribing' user but logged in as the linux 'postgres' user. For some reason this has to be done manually.

How do organic chemistry mechanisms become accepted? If you change the 'local' entry to md5, then you will be able to use password authentication. Why is credit card information not stolen more often? 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

Could aliens colonize Earth without realizing humans are people too? How to send the ESC signal to vim when my esc key doesn't work? Four Birds + One Is it possible to see animals from space? However, I don't seem to be able to connect to my new database once I've created it.

Is the form "double Dutch" still used? https://forums.gentoo.org/viewtopic-t-982254-view-previous.html?sid=6800a932b8a1d3c64a52740d259dae56 Here are some similar questions that might be relevant: PostgreSQL “DESCRIBE TABLE” Show tables in PostgreSQL Insert, on duplicate update in PostgreSQL? postgres=# \password postgres Enter new password: Enter it again: postgres=# \q could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory Listing of /var/lib/postgresql directory: [email protected]:~$ ls -al current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list.

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. http://strobelfilms.com/could-not/could-not-save-history-to-file.html Does gunlugger AP ammo affects all armor? 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 I'm too cold, turn up the temperature Could aliens colonize Earth without realizing humans are people too?

Honestly, it's not that big of a deal. That is, unless you connect to PSQL using your own account and you continue to get a similar error message. I tried to fully uninstall it again like this: I found al the packages related to postgres: $ dpkg -l | grep postgres Them I removed all the packages and related Source I'm not sure whether the error is to do with the lack of a history file, or whether it's some interaction between Unix user and database user that I don't fully

Could aliens colonize Earth without realizing humans are people too? In that case, your HOME variable might be wrong. where can I say psql that it must > >> write .psql_history into the datadir? > >> > > > > psql tries to write there because the home directory of

The female equivalent of "don't break my balls" In a determinant prove xyz = 1 Is it possible to have 3 real numbers that have both their sum and product equal

Browse other questions tagged postgresql ubuntu or ask your own question. Since you're done installing, I doubt you'll ever see the message again. Splitting a line into two Is it bad form to write mysterious proofs without explaining what one intends to do? See also: Bug #32696 - User postgres can't write to /var/lib/postgresql: (Reported on 2006-02-24, Status: Fix Released) https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/32696 share|improve this answer answered Nov 12 '15 at 14:59 rsp 1234 add a

Exaggerated Vs Melodramatic Variables and functions? could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory What exactly is causing this and will this cause me any issues? Update: Here's the content of pg_hba.conf: # Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket have a peek here Browse other questions tagged database postgresql ubuntu-14.04 postgresql-9.3 or ask your own question.

Are zipped EXE files harmless for Linux servers? Is the effect of dollar sign the same as textit? You're not logged in to your system as postgres are you? 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

Seems to be the same problem as bug 32696 which was marked as fixed back in 2006. Remember to restart postgresql service after that change. –krzysiek.ste Mar 12 '15 at 11:38 @krzysiek.ste: reload is good enough, you don't need a restart. Browse other questions tagged postgresql debian or ask your own question. Not the answer you're looking for?

Affecting: postgresql-common (Ubuntu) Filed here by: Todd Decker When: 2014-06-26 Confirmed: 2014-10-09 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Word for fake religious people A Page of Puzzling What is the proper usage of "identically zero"? Exaggerated Vs Melodramatic Who were the red-robed citizens of Jedha City? Seems to be the same problem as bug 32696 which was marked as fixed back in 2006.

This is what I've done: $ sudo su - postgres [email protected]:~$ createdb prescribing [email protected]$ psql postgres=# create user prescribing with password 'mypassword'; CREATE ROLE postgres=# GRANT ALL PRIVILEGES ON DATABASE prescribing That history file is just a list of commands that were executed inside the PSQL interface. Just create the .psql_history file in that directory, and then give the postgres user ownership of the file. Where should a galactic capital be?

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 Libertine and TIPA Sans Serif 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 share|improve this answer answered Jan 7 at 16:19 charlwillia6 112 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up

Four Birds + One more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life /