Public bug reported:
Unable to write to history log. Seems to be the same problem as bug
32696 which was marked as fixed back in 2006. But, it happens to me too
after straight postgress installation on an Ubuntu 14.04 Amazon EC2
instance.
Steps taken to install:
<Stand up EC2 instance>
$ sudo apt-get install postgresql postgresql-contrib
$ sudo apt-get install pgadmin3
Problem occurs:
ubuntu@ip-172-31-20-201:~$ sudo -u postgres psql postgres
psql (9.3.4)
Type "help" for help.
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
<ctrl-d>
Listing of /var/lib/postgresql directory:
ubuntu@ip-172-31-20-201:~$ ls -al /var/lib/postgresql
total 16
drwxr-xr-x 3 postgres postgres 4096 Jun 26 14:58 .
drwxr-xr-x 41 root root 4096 Jun 26 14:54 ..
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
ubuntu@ip-172-31-20-201:~$ lsb_release -rd
Description: Ubuntu 14.04 LTS
Release: 14.04
ubuntu@ip-172-31-20-201:~$ apt-cache policy postgresql
postgresql:
Installed: 9.3+154
Candidate: 9.3+154
Version table:
*** 9.3+154 0
500 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty/main amd64
Packages
100 /var/lib/dpkg/status
** Affects: postgresql-common (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-common in Ubuntu.
https://bugs.launchpad.net/bugs/1334714
Title:
User postgres can't write to /var/lib/postgresql
Status in “postgresql-common” package in Ubuntu:
New
Bug description:
Unable to write to history log. Seems to be the same problem as bug
32696 which was marked as fixed back in 2006. But, it happens to me
too after straight postgress installation on an Ubuntu 14.04 Amazon
EC2 instance.
Steps taken to install:
<Stand up EC2 instance>
$ sudo apt-get install postgresql postgresql-contrib
$ sudo apt-get install pgadmin3
Problem occurs:
ubuntu@ip-172-31-20-201:~$ sudo -u postgres psql postgres
psql (9.3.4)
Type "help" for help.
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
<ctrl-d>
Listing of /var/lib/postgresql directory:
ubuntu@ip-172-31-20-201:~$ ls -al /var/lib/postgresql
total 16
drwxr-xr-x 3 postgres postgres 4096 Jun 26 14:58 .
drwxr-xr-x 41 root root 4096 Jun 26 14:54 ..
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
ubuntu@ip-172-31-20-201:~$ lsb_release -rd
Description: Ubuntu 14.04 LTS
Release: 14.04
ubuntu@ip-172-31-20-201:~$ apt-cache policy postgresql
postgresql:
Installed: 9.3+154
Candidate: 9.3+154
Version table:
*** 9.3+154 0
500 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty/main amd64
Packages
100 /var/lib/dpkg/status
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1334714/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
