postgres in vagrant(ubuntu14.04)

Question

I tried to create simple dev environment with vagrant but fall in problem with postgres.

My Vagrantfile is simple:

# -*- mode: ruby -*-
# vi: set ft=ruby :

# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
VAGRANTFILE_API_VERSION = "2"

Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
  config.vm.box = "ubuntu/trusty64"
  config.vm.network "forwarded_port", guest: 8000, host: 8000
  config.vm.network :public_network

  config.vm.provision "ansible" do |ansible|
    ansible.playbook = "playbook.yml"
  end
end

and I use ansible for provision:

- name: Configure development machine
  hosts: all
  sudo: True
  tasks:
    - name: install postgres
      apt: name={{ item }} update_cache=yes
      with_items:
        - postgresql 
        - postgresql-contrib

but something goes wrong and postgres installs incorrect

When I ssh to VM and I see strange things:

 $ /etc/init.d/postgresql start
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LC_TIME = "uk_UA.UTF-8",
        LC_MONETARY = "uk_UA.UTF-8",
        LC_ADDRESS = "uk_UA.UTF-8",
        LC_TELEPHONE = "uk_UA.UTF-8",
        LC_NAME = "uk_UA.UTF-8",
        LC_MEASUREMENT = "uk_UA.UTF-8",
        LC_IDENTIFICATION = "uk_UA.UTF-8",
        LC_NUMERIC = "uk_UA.UTF-8",
        LC_PAPER = "uk_UA.UTF-8",
        LANG = "en_US.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting

and there is no /etc/postgresql directory(but /etc/postgresql-common is present) Any thoughts?

Github repo

Answer 1

you can solve this issue logging in the ubuntu machine and reconfiguring locales with the following command:

dpkg-reconfigure locales

and choose the locale you want.

After solving locale issue, you probably want to initialize the cluster and structure of postgres using:

/etc/init.d/postgresql start

You should after that, configure it properly. I'm using version 9.3 of postgres, so the path of the configuration is

/etc/postgresql/9.3/main

Cheers

LEslie

Answer 2

Add the following lines to shell startup file

LANGUAGE=en_US.UTF-8
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

And then run (with root privileges)

locale-gen en_US.UTF-8
dpkg-reconfigure locales