Locale breaks psql

From: abdulrahman Alotaibi <adminq80(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Locale breaks psql
Date: 2014-12-03 07:52:20
Message-ID: 547EC134.4070208@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello all,

I am using PostgreSQL 9.3.5 on Ubuntu Trusty-64. My machine has LC_* set
to en_GB.UTF-8 and I used the attached VagrantFile to create the machine
and provision using Ansible. Postgres was installed on seven other
machines and kept breaking on two machines. After checking for two days,
I found that my colleague's machine had locale set to en_AU.UTF-8 and my
machine had locale set to en_GB.UTF-8. I changed both machines to use
en_US.UTF-8 as a default locale and it worked.

The error I was getting when I ran psql after switching to postgres user
was "Server: No such file or directory found" and couldn't connect to
socket /var/Pg.5432.
Sorry for not having the exact output.

Sincerely,
Abdulrahman Alotaibi

Attachment Content-Type Size
ansible_deployment.yml application/x-yaml 936 bytes
Vagrantfile text/plain 381 bytes

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2014-12-03 10:55:40 Re: BUG #11949: pg_basebackup creates defective tar file
Previous Message Ed Avis 2014-12-03 03:48:45 Re: BUG #11986: psql uses pager inside Emacs shell buffer (not a terminal)