Ubuntu – PostgreSQL didn’t install on Ubuntu 11.04

postgresqlUbuntuubuntu-11.04

On a new copy of Ubuntu 11.04 server I am trying to install PostgreSQL server by apt-get install postgresql. But in the end of installation log I saw:

Error: could not create default cluster. Please create it manually with

  pg_createcluster 8.4 main --start

When I ran this command I saw this message:

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US:en",
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Error: The locale requested by the environment is invalid.

And no PostgreSQL server started 🙁

What I need to do to become happy on this?

Best Answer

The accepted answer didn't help me; if there are others like me please read below.

I traced the problem to pg_upgradecluster explicitly unsetting LC_ALL. This made Perl fail whichever way I was playing with the other environment variables.

So what I did is that I simply commented line 352 in /usr/bin/pg_upgradecluster:

#delete $ENV{'LC_ALL'};

This did the trick. Of course, this will only work if you're an average Joe with en_US.UTF-8 in all clusters and don't use any fancy encodings that you need to preserve.

Related Solutions

Ubuntu – Installing postgresql 8.4 on ubuntu 9.10 error

Solved, followed this link https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/235379 answer #15 and it started

PostgreSQL – Default Superuser Username/Password After New Install

CAUTION The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be DANGEROUS!

This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system.

What you should do is follow Chris James's answer:

sudo -u postgres psql postgres

# \password postgres

Enter new password:

To explain it a little bit. There are usually two default ways to login to PostgreSQL server:

By running the "psql" command as a UNIX user (so-called IDENT/PEER authentication), e.g.: sudo -u postgres psql. Note that sudo -u does NOT unlock the UNIX user.
by TCP/IP connection using PostgreSQL's own managed username/password (so-called TCP authentication) (i.e., NOT the UNIX password).

So you never want to set the password for UNIX account "postgres". Leave it locked as it is by default.

Of course things can change if you configure it differently from the default setting. For example, one could sync the PostgreSQL password with UNIX password and only allow local logins. That would be beyond the scope of this question.

Best Answer

Related Solutions

Ubuntu – Installing postgresql 8.4 on ubuntu 9.10 error

PostgreSQL – Default Superuser Username/Password After New Install

Related Topic