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

Could Not Save History To File Postgres

I'm open to suggestions how to improve that, though. :) Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Information forwarded to [email protected]: Bug#357400; Package postgresql-common. 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 It also has the correct /etc/passwd entry. have a peek at this web-site

It also > has the correct /etc/passwd entry. Sign in Maikel Zweerink / WhatsSpy-Public Go to a project Toggle navigation Toggle navigation pinning Projects Groups Snippets Help Project Activity Repository Graphs Issues 2 Wiki Network Create a new issue 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 Report a bug This report contains Public information Edit Everyone can see this information. http://dba.stackexchange.com/questions/68705/could-not-save-history-to-file-var-lib-postgresql-psql-history-no-such-file

That history file is just a list of commands that were executed inside the PSQL interface. If both paths are on the same partition, then the cluster should have been moved to the new path. > > > [email protected]:/$ ls /var/lib/post* -d > > > /var/lib/postgrsql > This is with PostgreSQL 9.4.5 on Linux (Arch/Manjaro), installed from the package manager. Message #30 received at [email protected] (full text, mbox, reply): From: Martin Pitt To: Jon Webster , [email protected] Subject: Re: Bug#357400: Asterisk bugs Date: Sun, 19 Mar 2006 18:37:01 +0100 [Message

I gave up trying to fix it using a .psqlrc file.Thanks,DavidPS Thank you SO MUCH for such an absolutely incredible database! 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 Changed Bug title. Full text and rfc822 format available.

Request was from Martin Pitt to [email protected] Full text and rfc822 format available. Right, that change is done by the transitional 'postgresql' package, not by postgresql-common. No, it's not, thanks for you report. :) > [email protected]:/$ ls /var/lib/post* -d > /var/lib/postgrsql Now, *that* looks wrng :) So, to be honest, I'm not sure what happened here. 'postgrsql'

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? If both paths are on the same partition, then the cluster should > have been moved to the new path. Full text and rfc822 format available. drwxr-xr-x 42 root root 4096 Feb 24 10:45 ..

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 http://stackoverflow.com/questions/32278023/postgresql-installation-failed-on-ubuntu-14-04 Is scroll within a card good or bad? (In desktop) What does the author want to convey by ending his letter with »Tschüssikowsky«? But, it happens to me too after straight postgress installation on an Ubuntu 14.04 Amazon EC2 instance. Bug reassigned from package `postgresql' to `postgresql'.

Acknowledgement sent to Martin Pitt : Extra info received and forwarded to list. http://strobelfilms.com/could-not/could-not-save-history-to-file.html 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 Acknowledgement sent to "Jon Webster" : Extra info received and forwarded to list. 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

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 Do you have an > > idea how this directory could have been misnamed? > > > > The most likely place is postgresql/sarge. Full text and rfc822 format available. Source Word for fake religious people Crazy 8s Code Golf Help, my office wants infinite branch merges as policy; what other options do we have?

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 It should have read: Postgresql bug > -----Original Message----- > From: Martin Pitt [mailto:[email protected]] > Sent: Saturday, March 18, 2006 8:20 AM > To: Jon Webster > Cc: [email protected] > Subject: Explain it to me like I'm a physics grad: Greenhouse Effect Is the form "double Dutch" still used?

You need to download and install the real GNU Readline, having eliminated the readline > whatever symlink.

template=# \q could not save history to file "/var/lib/postgres/.psql_history": No such file or directory [email protected]:/$ ls /var/lib/post* -d /var/lib/postgrsql [email protected]:/$ grep postgres /etc/passwd postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh [email protected]:/$ Information forwarded to [email protected]: Bug#357400; Package If you are planning on using that user interactively (not advised at all), then you'll have to set its HOME directory to some valid folder. postgres=# \q could not save history to file "/home/postgres/.psql_history": No such file or directory I have no idea what is happening. 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

Message #25 received at [email protected] (full text, mbox, reply): From: "Jon Webster" To: <[email protected]> Subject: RE: Bug#357400: Asterisk bugs Date: Sat, 18 Mar 2006 11:03:24 -0500 I just noticed the 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 Information forwarded to [email protected]: Bug#357400; Package postgresql-common. have a peek here Request was from Debbugs Internal Request to [email protected] (Sun, 24 Jun 2007 07:49:29 GMT) Full text and rfc822 format available.

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 Key binding in PostGreSQL Compiling under Solaris 8 Problem with host connection jdbc, use of nested ResultSet loops.(longish, interesting I hope) 7.0 psql, readline and history. Exaggerated Vs Melodramatic How to find punctures in inner tubes? Since the messageis benign I'll just ignore it (like Jerry Levan does :)Thanks,DavidOn 4/24/06 1:59 PM, "Martijn van Oosterhout" wrote:On Sun, Apr 23, 2006 at 09:33:40PM -0400, David F.

It probably went through the > transitional package as intended. Thanks for the tip on there being no real difference in the two paths (i.e., I'm not a Unix guy). It probably went through the transitional package as intended. > > Reinstalling postgresql-common did not correct the entry. > > Right, that change is done by the transitional 'postgresql' package, > 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

Regex with sed command to parse json text What are these boxes mounted inline on each of the 3 phase wires of a high voltage power line in Miami? Acknowledgement sent to "Jon Webster" : New Bug report received and forwarded. 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. > >> be killed in the war vs be killed by the war Is it bad form to write mysterious proofs without explaining what one intends to do?

Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates? [signature.asc (application/pgp-signature, inline)] Information forwarded to [email protected], where can I say psql that it must > >> write .psql_history into the datadir? > >> > > > > psql tries to write there because the home directory of But, it happens to me too after straight postgress installation on an Ubuntu 14.04 Amazon EC2 instance. If /var/lib/postgres is a separate partition (or, more precisely, on a different partition than /var/lib/postgresql), then the upgrade will not move the installation, since the dedicated partition should be kept.

Reply sent to Martin Pitt : You have taken responsibility. Installing/upgrading the current postgresql 7.5.16 package should help, though; does it? > This may be the correct behavior, but incase it's not, you've been > warned :). Right. 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

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. Have a nice day, -- Martijn van Oosterhout http://svana.org/kleptog/ Martijn van Oosterhout at Apr 24, 2006 at 6:50 pm ⇧ On Sun, Apr 23, 2006 at 09:33:40PM -0400, David F. 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