From: | "Geoff Ellingwood" <neppyman(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trouble running PostgreSQL server / Server must be started under certain locale. |
Date: | 2007-12-19 12:57:43 |
Message-ID: | 36ec84a90712190457n78ae03e1m3c8a5301b26ddb07@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm in the process of getting Subversion and Trac running on my development
machine. So far, the installation process has gone fairly smoothly, until I
had to install the Subversion bindings for Python. Because I run Ubuntu,
and Ubuntu did not have the latest bindings in its repositories, I had to
get it from the Debian archives instead. Well, after doing this, the
PostgreSQL server is now refusing to start.
The following error message is given:
neppyman(at)loki:~$ sudo /etc/init.d/postgresql-8.1 start
* Starting PostgreSQL 8.1 database server
* Error: The server must be started under the locale en_US.UTF-8 which does
not exist any more.
Checking my locales tels me...
neppyman(at)loki:~$ locale -a
(snip)
en_US.utf8
Obviously there's a mismatch there, but I'm still learning Linux, so I don't
really know how to fix it. I've tried uninstalling and reinstalling the
locales package, but that didn't help.
Any help would be appreciated; I have quite a bit of data in my 8.1 cluster
(active phpBB, etc.), and while I could upgrade to 8.2 or even the 8.3 beta,
I don't know how I would be able to migrate a database if the postmaster
process is unable to start.
-- Geoff
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-12-19 13:26:11 | Re: foreign key constraint, planner ignore index. |
Previous Message | Gordon | 2007-12-19 11:32:03 | Postgres from PHP in Leopard |