pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPanic involving a LC_COLLATE issue
4+ messages / 4 participants
[nested] [flat]
* Panic involving a LC_COLLATE issue
@ 2004-02-20 17:45 Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
2004-02-20 18:23 ` Re: Panic involving a LC_COLLATE issue Andrew Sullivan <ajs@crankycanuck.ca>
2004-02-22 22:54 ` Re: Panic involving a LC_COLLATE issue Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Marco Gaiani @ 2004-02-20 17:45 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I have experienced a distressing problem lately with my hosting provider
(they run RedHat), they had to downgrade their version of Postgresql
from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing
a pg_dump of my databases they copied the data directory somewhere else
as data_old and went on with the downgrade of Postgres. They have not
been able to restore my databases but sent me a copy of the data directory.
I have tried to mount it with Mandrake 9.2 and Postgres 7.3.3 but I get
this error:
DEBUG: FindExec: searching PATH ...
DEBUG: ValidateBinary: can't stat "/bin/postgres"
DEBUG: FindExec: found "/usr/bin/postgres" using PATH
DEBUG: invoking IpcMemoryCreate(size=983040)
PANIC: The database cluster was initialized with LC_COLLATE
'en_US.iso885915',
which is not recognized by setlocale().
It looks like you need to initdb.
Aborted
Any ideas on how to solve this, desesperatly yours
--
Marco Gaiani
Unidad de Promoción y Relaciones
FUNDACITE ARAGUA
mailto: magaiani@fundacite.arg.gov.ve
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Panic involving a LC_COLLATE issue
2004-02-20 17:45 Panic involving a LC_COLLATE issue Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
@ 2004-02-20 18:23 ` Andrew Sullivan <ajs@crankycanuck.ca>
2004-02-22 02:22 ` Re: Panic involving a LC_COLLATE issue Robert Treat <xzilla@users.sourceforge.net>
1 sibling, 1 reply; 4+ messages in thread
From: Andrew Sullivan @ 2004-02-20 18:23 UTC (permalink / raw)
To: pgsql-admin
On Fri, Feb 20, 2004 at 01:45:40PM -0400, Marco Gaiani wrote:
> Hi all,
>
> I have experienced a distressing problem lately with my hosting provider
> (they run RedHat), they had to downgrade their version of Postgresql
> from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing
First, this sounds pretty dodgy to me. I have a feeling that they're
overlooking some other problem. But that won't help you.
> a pg_dump of my databases they copied the data directory somewhere else
> as data_old and went on with the downgrade of Postgres. They have not
> been able to restore my databases but sent me a copy of the data directory.
This is ok -- the binaries are compatible across major versions, so a
7.3.3 tree should work with 7.3.x
> 'en_US.iso885915',
> which is not recognized by setlocale().
> It looks like you need to initdb.
> Aborted
You need the locale support offered by the Red Hat system. Seems you
need ISO 8859-15. My bet is either that Mandrake's locale doesn't
support that, you don't have the right libs, or the binary you've
installed wasn't compiled with the right support. Can you actually
set your LANG to iso885915?
A
--
Andrew Sullivan | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Panic involving a LC_COLLATE issue
2004-02-20 17:45 Panic involving a LC_COLLATE issue Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
2004-02-20 18:23 ` Re: Panic involving a LC_COLLATE issue Andrew Sullivan <ajs@crankycanuck.ca>
@ 2004-02-22 02:22 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Treat @ 2004-02-22 02:22 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin; +Cc: Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
On Friday 20 February 2004 13:23, Andrew Sullivan wrote:
> On Fri, Feb 20, 2004 at 01:45:40PM -0400, Marco Gaiani wrote:
> > Hi all,
> >
> > I have experienced a distressing problem lately with my hosting provider
> > (they run RedHat), they had to downgrade their version of Postgresql
> > from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing
>
> First, this sounds pretty dodgy to me. I have a feeling that they're
> overlooking some other problem. But that won't help you.
>
On top of this, there is a fairly ciritcal bug in 7.3.3 that can cause server
start up failure. It's a corner case, but still a pretty serious one. You
should talk to your webhost about getting on 7.3.5 asap.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Panic involving a LC_COLLATE issue
2004-02-20 17:45 Panic involving a LC_COLLATE issue Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
@ 2004-02-22 22:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-02-22 22:54 UTC (permalink / raw)
To: Marco Gaiani <mgaiani@fundacite.arg.gov.ve>; +Cc: pgsql-admin
Marco Gaiani <mgaiani@fundacite.arg.gov.ve> writes:
> I have experienced a distressing problem lately with my hosting provider
> (they run RedHat), they had to downgrade their version of Postgresql
> from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly.
You should ask them why they've not reported their problems. I've not
heard from anyone else that 7.3.4 is less stable than 7.3.3.
> PANIC: The database cluster was initialized with LC_COLLATE
> 'en_US.iso885915',
> which is not recognized by setlocale().
> It looks like you need to initdb.
I think it should be possible to get the localedef source file for this
locale and build the necessary locale support on your Mandrake system.
I don't know exactly where to look for the locale source, though.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-02-22 22:54 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-20 17:45 Panic involving a LC_COLLATE issue Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
2004-02-20 18:23 ` Andrew Sullivan <ajs@crankycanuck.ca>
2004-02-22 02:22 ` Robert Treat <xzilla@users.sourceforge.net>
2004-02-22 22:54 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox