pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Panic 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>
  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 18:23  Andrew Sullivan <ajs@crankycanuck.ca>
  parent: Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
  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-22 02:22  Robert Treat <xzilla@users.sourceforge.net>
  parent: Andrew Sullivan <ajs@crankycanuck.ca>
  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-22 22:54  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Marco Gaiani <mgaiani@fundacite.arg.gov.ve>
  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