Giter VIP home page Giter VIP logo

Comments (9)

 avatar commented on June 2, 2024

I have the same problem. Thought it was just me doing something wrong.

from postgresql.

safqwf avatar safqwf commented on June 2, 2024

The issue created by locales sent via ssh connection.
On your host comment out SendEnv LANG LC_* in /etc/ssh/ssh_config
or
on the guest machine add

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

in /etc/bash.bashrc to apply this rule to all users.

from postgresql.

soupdiver avatar soupdiver commented on June 2, 2024

Can't reproduce this on my system (OSX with iTerm)

Is this still a problem?

from postgresql.

farridav avatar farridav commented on June 2, 2024

Also unable to reproduce on lubuntu with LXTerminal .. though I do remember having to add this line in to get travis builds working .. though if its to do with values sent in the SSH connection its probably unrelated.. @hrstoyanov seems to have a way to reproduce using docker in #108 .. but not yet had time to try and reproduce..

from postgresql.

hrstoyanov avatar hrstoyanov commented on June 2, 2024

@farridav, see this
sous-chefs/postgresql#108

Problem is caused by locale settings (PostgreSQL initdb cannot init cluster because of locale settings misconfiguration or locales were set within same ssh session and weren't reloaded). Once you set proper LANG variable, recipe will work with no problem. You can do it by putting line like this just before including postgresql::server recipe :

from postgresql.

farridav avatar farridav commented on June 2, 2024

cool @hrstoyanov will read now

from postgresql.

hrstoyanov avatar hrstoyanov commented on June 2, 2024

@farridav,
When you check out this Chef thread: sous-chefs/postgresql#147
it sounds like Derbian apt Postgres cluster installation fails when the locales are not set up in some strange way. Seems like corner cases error in the apt perl script. This is why it is hard to reproduce, but with the Docker file you should see the issue easily. Also, notice that SSH can override some env variables.

Is there any way to skip the cluster configuration with this role? I do not need it anyway and it is causing the issue.

Thanks.

from postgresql.

safqwf avatar safqwf commented on June 2, 2024

set your host's locales for example to Hebrew-Israel he_IL.UTF-8, then try to reproduce the issue. This happens also with other locales, but I don't have any specific list. The host's ssh client sends locales to the guest machine, so the guest machine will be configured to the same locale. But for some reason guest machine is not aware or doesn't support some unique locales and it raises that error.

from postgresql.

aoyawale avatar aoyawale commented on June 2, 2024

is this still an issue?

from postgresql.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.