← Back to team overview

desktop-packages team mailing list archive

[Bug 1334714] Re: User postgres can't write to /var/lib/postgresql

 

Status changed to 'Confirmed' because the bug affects multiple users.

** Changed in: postgresql-common (Ubuntu)
       Status: New => Confirmed

-- 
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:
  Confirmed

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