Re: problems with starting postpostmaster

From: John fabiani <jfabiani(at)yolo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: problems with starting postpostmaster
Date: 2001-11-05 16:25:42
Message-ID: j8zF7.66036$DT1.2885688@sjcpnn01.usenetserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Baker wrote:

> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_005C_01C162D1.FB610150
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi.
>
> I currently had a client move from linux 7.1 to 7.2, at this point
> postgres=
> stopped working. I attempted to install the new rpms, but had many
> depend=
> ency failures. I attempted to start the postmaster via pg_ctl, but am
> gett= ing the following error:
>
> bash-2.05$ FATAL 2: database was initialized with LC_COLLATE
> 'en_U=
> S',
> which is not recognized by setlocale().
> looks like you need to initdb.
>
> Does this error reflect that I need to update to rpms that are specific to
> =
> 7.2 or is there some other problem. If I run an initdb I can then start
> th= e postmaster, I can not however point to the data that I really need.
>
> Help!
>
> Thank you very much.
>
> -Mike Baker
>
> ------=_NextPart_000_005C_01C162D1.FB610150
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4522.1800"
> name=3DGENERATOR> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hi.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>I currently had a client move from linux
> 7= .1 to=20
> 7.2, at this point postgres stopped working.&nbsp; I attempted to install
> t= he=20
> new rpms, but had many dependency failures.&nbsp; I attempted to start
> the= =20
> postmaster via pg_ctl, but am getting the following error:</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial
> size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= =20
> bash-2.05$ FATAL 2:&nbsp; database was initialized with LC_COLLATE=20
> 'en_US',<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; which is not
> recogni= zed=20
> by setlocale().<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; looks like
> yo= u=20
> need to initdb.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Does this error reflect that I need to
> upd= ate to=20
> rpms that are specific to 7.2 or is there some other problem.&nbsp; If I
> ru= n an=20
> initdb I can then start the postmaster, I can not however point to the
> data=
> that=20
> I really need.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Help!</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Thank you very much.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>-Mike Baker</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_005C_01C162D1.FB610150--
>
>
pg_dump first and then bring it back in. RH 7.2 uses 7.1.3
John

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-11-06 17:07:09 Re: Perfomance problems
Previous Message Ferdinand Smit 2001-11-05 15:36:29 Re: The patch-mailingslist