Comments (9)
I have the same problem. Thought it was just me doing something wrong.
from postgresql.
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.
Can't reproduce this on my system (OSX with iTerm)
Is this still a problem?
from postgresql.
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.
@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.
cool @hrstoyanov will read now
from postgresql.
@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.
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.
is this still an issue?
from postgresql.
Related Issues (20)
- Is this repo dead? HOT 27
- When I use psql in the root directory, there is an error HOT 5
- Move us to travis-ci.com ASAP. HOT 12
- run big transaction procedure seem like be blocked HOT 1
- when select (fn_return_record()).* is called, fn_return_record is executed repeatedly HOT 1
- Wrong postgresql_yum_repository_baseurl HOT 3
- New release HOT 3
- Postgis not working. HOT 2
- postgis missing dependencies in RHEL 7.9 HOT 1
- Postgresql 14 support HOT 3
- No package matching 'python-psycopg2' is available HOT 5
- Release new version to ansible galaxy HOT 2
- PostgreSQL 15 support? HOT 6
- Help Wanted! HOT 2
- Postgresql requires restart if a new locale was used
- Problem with defaults/main.yml syntax HOT 1
- Latest Version (v1.15.0) Not Reflected in ansible-galaxy for anxs.postgresql HOT 5
- support PostgreSQL 16 HOT 5
- Postgresql 11 is unavailable since 2023-01-05 HOT 2
- PostgreSQL 16 : Unable to create the XXXXXXXX table (permission denied for schema public HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgresql.