pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error starting backend
7+ messages / 5 participants
[nested] [flat]

* Error starting backend
@ 2003-05-26 17:41  jason <jason@theleehouse.net>
  0 siblings, 1 reply; 7+ messages in thread

From: jason @ 2003-05-26 17:41 UTC (permalink / raw)
  To: pgsql-admin

I had a hard drive die on me.  In rebuilding my system, I found out that my
backup process wasn't working correctly, so I don't have any dumps that I can
just load into the new setup.  I was able, however, to save the data directory
from the old drive.  If I try to start the backend up with that data dir,
though, I get this error:

PANIC:  The database cluster was initialized with LC_COLLATE 'en_US.UTF-8',
        which is not recognized by setlocale().
        It looks like you need to initdb.

Any idea how I can get around that?  Thanks a lot!

jason



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Error starting backend
@ 2003-05-29 14:48  Jason Lee <jason@theleehouse.net>
  parent: jason <jason@theleehouse.net>
  0 siblings, 2 replies; 7+ messages in thread

From: Jason Lee @ 2003-05-29 14:48 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

Any thoughts on this?  I'm at a loss on what to try next.  I appreciate any help 
anyone can give. :P

Thanks a lot!

jason wrote:

> I had a hard drive die on me.  In rebuilding my system, I found out that my
> backup process wasn't working correctly, so I don't have any dumps that I can
> just load into the new setup.  I was able, however, to save the data directory
> from the old drive.  If I try to start the backend up with that data dir,
> though, I get this error:
> 
> PANIC:  The database cluster was initialized with LC_COLLATE 'en_US.UTF-8',
>         which is not recognized by setlocale().
>         It looks like you need to initdb.
> 
> Any idea how I can get around that?  Thanks a lot!
> 
> jason
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 


-- 
jason lee
His grace for my shame / His death for my blame / His stripes for my pain
And the pieces fit / His joy for my grief / His hurt my relief
My doubt His belief / And the pieces fit -- Considering Lily




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Error starting backend
@ 2003-05-29 15:20  Robert Treat <xzilla@users.sourceforge.net>
  parent: Jason Lee <jason@theleehouse.net>
  1 sibling, 1 reply; 7+ messages in thread

From: Robert Treat @ 2003-05-29 15:20 UTC (permalink / raw)
  To: Jason Lee <jason@theleehouse.net>; +Cc: pgsql-admin

Hmm... I'm thinking you either have a version mismatch or perhaps
there's an issue with your recovery process. can you initidb a new
location with the proper local settings, then copy over the data dir to
that new location?  If that doesn't work, post the steps you took to
restore. 

Robert Treat

On Thu, 2003-05-29 at 10:48, Jason Lee wrote:
> Any thoughts on this?  I'm at a loss on what to try next.  I appreciate any help 
> anyone can give. :P
> 
> Thanks a lot!
> 
> jason wrote:
> 
> > I had a hard drive die on me.  In rebuilding my system, I found out that my
> > backup process wasn't working correctly, so I don't have any dumps that I can
> > just load into the new setup.  I was able, however, to save the data directory
> > from the old drive.  If I try to start the backend up with that data dir,
> > though, I get this error:
> > 
> > PANIC:  The database cluster was initialized with LC_COLLATE 'en_US.UTF-8',
> >         which is not recognized by setlocale().
> >         It looks like you need to initdb.
> > 
> > Any idea how I can get around that?  Thanks a lot!
> > 
> > jason
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> > http://www.postgresql.org/docs/faqs/FAQ.html
> > 
> > 
> 
> 
> -- 
> jason lee
> His grace for my shame / His death for my blame / His stripes for my pain
> And the pieces fit / His joy for my grief / His hurt my relief
> My doubt His belief / And the pieces fit -- Considering Lily
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Error starting backend
@ 2003-05-29 15:41  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jason Lee <jason@theleehouse.net>
  1 sibling, 0 replies; 7+ messages in thread

From: Tom Lane @ 2003-05-29 15:41 UTC (permalink / raw)
  To: Jason Lee <jason@theleehouse.net>; +Cc: pgsql-admin

Jason Lee <jason@theleehouse.net> writes:
> Any thoughts on this?

>> PANIC:  The database cluster was initialized with LC_COLLATE 'en_US.UTF-8',
>> which is not recognized by setlocale().

Looks to me like you are missing a locale file.  Maybe you omitted
installing some locale packages on your new system?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Error starting backend
@ 2003-05-29 21:14  Jason Lee <jason@theleehouse.net>
  parent: Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 0 replies; 7+ messages in thread

From: Jason Lee @ 2003-05-29 21:14 UTC (permalink / raw)
  To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: pgsql-admin

Robert Treat wrote:

> Hmm... I'm thinking you either have a version mismatch or perhaps
> there's an issue with your recovery process. can you initidb a new
> location with the proper local settings, then copy over the data dir to
> that new location?  If that doesn't work, post the steps you took to
> restore. 

You might have been right about the version problem.  I built an older version 
(7.3) and started the server with that data dir and it worked fine.  Since there 
shouldn't be the need to dump and restore with any 7.3.x version, I'm not sure 
that was the deal.  The data base came off a Red Hat 9 box, and I was trying to 
restore to a Gentoo box.  Once I copied the data dir to a Red Hat 9 box (and 
installed 7.3) everything worked.  <shrug>

Thank you Robert and Tom for taking time to help me. :)

-- 
jason lee
His grace for my shame / His death for my blame / His stripes for my pain
And the pieces fit / His joy for my grief / His hurt my relief
My doubt His belief / And the pieces fit -- Considering Lily




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* FW: Error starting backend
@ 2006-06-14 15:41  Rojas, Fernando (CIAT) <f.rojas@cgiar.org>
  0 siblings, 0 replies; 7+ messages in thread

From: Rojas, Fernando \(CIAT\) @ 2006-06-14 15:41 UTC (permalink / raw)
  To: pgsql-admin

HELLO    I need some help for this...

Thanks

> ______________________________________________ 
> From: 	Rojas, Fernando (CIAT)  
> Sent:	Thursday, June 08, 2006 2:48 PM
> To:	'pgsql-admin@postgresql.org'
> Subject:	FW: Error starting backend
> 
> 
> 
> ______________________________________________ 
> From: 	Rojas, Fernando (CIAT)  
> Sent:	Tuesday, June 06, 2006 12:29 PM
> To:	'pgsql-admin@postgresql.org'
> Cc:	'jason@DOMAIN.HIDDEN'
> Subject:	Error starting backend
> 
> HELLO:
> 
> I have now an error similar to one posted under the subject:
> 
> We had format the DISK and reinstall the SO (Red Hat Linux 8.0 3.2-7); we don't have a pg_dumpall file of support; but we have 
> The copy of the data file that was running ok under (PG-8.0.7).
> We reinstall P.G 8.0.7 and try to start post-master with the database cluster but have this error in the log:
> 
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> 
> When I change the postgresql.conf file changing en_US.UTF-8  by C; the error dissapears but show me this another:
> 
> FATAL:  database files are incompatible with operating system
> DETAIL:  The database cluster was initialized with LC_COLLATE "en_US.UTF-8", which is not recognized by setlo
> cale().
> HINT:  It looks like you need to initdb or install locale support
> 
> When I run:
> 
> Locale obtain this:
> [root@gene4 data]# locale
> LANG=en_US.UTF-8
> LC_CTYPE="en_US.UTF-8"
> LC_NUMERIC="en_US.UTF-8"
> LC_TIME="en_US.UTF-8"
> LC_COLLATE="en_US.UTF-8"
> LC_MONETARY="en_US.UTF-8"
> LC_MESSAGES="en_US.UTF-8"
> LC_PAPER="en_US.UTF-8"
> LC_NAME="en_US.UTF-8"
> LC_ADDRESS="en_US.UTF-8"
> LC_TELEPHONE="en_US.UTF-8"
> LC_MEASUREMENT="en_US.UTF-8"
> LC_IDENTIFICATION="en_US.UTF-8"
> LC_ALL=
> 
> But when I locale - a the result is:
> 
> [root@gene4 data]# locale -a
> C
> POSIX
> en_AU
> en_AU.utf8
> en_BW
> en_BW.utf8
> en_CA
> en_CA.utf8
> en_DK
> en_DK.utf8
> en_GB
> en_GB.iso885915
> en_GB.utf8
> en_HK
> en_HK.utf8
> en_IE
> en_IE.utf8
> en_IE.utf8@euro
> en_IE@euro
> en_IN
> en_NZ
> en_NZ.utf8
> en_PH
> en_PH.utf8
> en_SG
> en_SG.utf8
> en_US
> en_US.iso885915
> en_US.utf8
> en_ZA
> en_ZA.utf8
> en_ZW
> en_ZW.utf8
> 
> 
> I don't see en_US.UTF-8 there   why..??
> 
> I have tried doing initdb to an empty cluster  and copying the data folder  but the erros is the same.
> 
> Could you help me to resolve this..
> 
> 
> Thank you very much for your colaboration.
> 
> 
> FERNANDO ROJAS
> Ingeniero de Sistemas y Computación
> Unidad de Sistemas de Información
> Centro Internacional de Agricultura Tropical (CIAT)
> E-mail: frojas@cgiar.org
> Phone:(57-2)445-01-00 Ext 3647
> 

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* FW: Error starting backend
@ 2006-06-14 16:02  Rojas, Fernando (CIAT) <f.rojas@cgiar.org>
  0 siblings, 0 replies; 7+ messages in thread

From: Rojas, Fernando \(CIAT\) @ 2006-06-14 16:02 UTC (permalink / raw)
  To: pgsql-admin



> ______________________________________________ 
> From: 	Rojas, Fernando (CIAT)  
> Sent:	Wednesday, June 14, 2006 10:42 AM
> To:	'pgsql-admin@postgresql.org'
> Subject:	FW: Error starting backend
> 
> HELLO    I need some help for this> ...> 
> 
> Thanks
> 
> ______________________________________________ 
> From: 	Rojas, Fernando (CIAT)  
> Sent:	Thursday, June 08, 2006 2:48 PM
> To:	'pgsql-admin@postgresql.org'
> Subject:	FW: Error starting backend
> 
> 
> 
> ______________________________________________ 
> From: 	Rojas, Fernando (CIAT)  
> Sent:	Tuesday, June 06, 2006 12:29 PM
> To:	'pgsql-admin@postgresql.org'
> Cc:	'jason@DOMAIN.HIDDEN'
> Subject:	Error starting backend
> 
> HELLO:
> 
> I have now an error similar to one posted under the subject:
> 
> We had format the DISK and reinstall the SO (Red Hat Linux 8.0 3.2-7); we don't have a pg_dumpall file of support; but we have 
> The copy of the data file that was running ok under (PG-8.0.7).
> We reinstall P.G 8.0.7 and try to start post-master with the database cluster but have this error in the log:
> 
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
> 
> When I change the postgresql.conf file changing en_US.UTF-8  by C; the error dissapears but show me this another:
> 
> FATAL:  database files are incompatible with operating system
> DETAIL:  The database cluster was initialized with LC_COLLATE "en_US.UTF-8", which is not recognized by setlo
> cale().
> HINT:  It looks like you need to initdb or install locale support
> 
> When I run:
> 
> Locale obtain this:
> [root@gene4 data]# locale
> LANG=en_US.UTF-8
> LC_CTYPE="en_US.UTF-8"
> LC_NUMERIC="en_US.UTF-8"
> LC_TIME="en_US.UTF-8"
> LC_COLLATE="en_US.UTF-8"
> LC_MONETARY="en_US.UTF-8"
> LC_MESSAGES="en_US.UTF-8"
> LC_PAPER="en_US.UTF-8"
> LC_NAME="en_US.UTF-8"
> LC_ADDRESS="en_US.UTF-8"
> LC_TELEPHONE="en_US.UTF-8"
> LC_MEASUREMENT="en_US.UTF-8"
> LC_IDENTIFICATION="en_US.UTF-8"
> LC_ALL=
> 
> But when I locale - a the result is:
> 
> [root@gene4 data]# locale -a
> C
> POSIX
> en_AU
> en_AU.utf8
> en_BW
> en_BW.utf8
> en_CA
> en_CA.utf8
> en_DK
> en_DK.utf8
> en_GB
> en_GB.iso885915
> en_GB.utf8
> en_HK
> en_HK.utf8
> en_IE
> en_IE.utf8
> en_IE.utf8@euro
> en_IE@euro
> en_IN
> en_NZ
> en_NZ.utf8
> en_PH
> en_PH.utf8
> en_SG
> en_SG.utf8
> en_US
> en_US.iso885915
> en_US.utf8
> en_ZA
> en_ZA.utf8
> en_ZW
> en_ZW.utf8
> 
> 
> I don't see en_US.UTF-8 there   why..??
> 
> I have tried doing initdb to an empty cluster  and copying the data folder  but the erros is the same.
> 
> Could you help me to resolve this..
> 
> 
> Thank you very much for your colaboration.
> 
> 
> FERNANDO ROJAS
> Ingeniero de Sistemas y Computación
> Unidad de Sistemas de Información
> Centro Internacional de Agricultura Tropical (CIAT)
> E-mail: frojas@cgiar.org
> Phone:(57-2)445-01-00 Ext 3647
> 

^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2006-06-14 16:02 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-26 17:41 Error starting backend jason <jason@theleehouse.net>
2003-05-29 14:48 ` Jason Lee <jason@theleehouse.net>
2003-05-29 15:20   ` Robert Treat <xzilla@users.sourceforge.net>
2003-05-29 21:14     ` Jason Lee <jason@theleehouse.net>
2003-05-29 15:41   ` Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:41 FW: Error starting backend Rojas, Fernando (CIAT) <f.rojas@cgiar.org>
2006-06-14 16:02 FW: Error starting backend Rojas, Fernando (CIAT) <f.rojas@cgiar.org>

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