Thread: problems with starting postpostmaster

problems with starting postpostmaster

From

"Michael Baker"

Date:

05 November 2001, 13:17:53

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 dependency failures. I attempted to start the postmaster via pg_ctl, but am getting the following error:

        bash-2.05$ FATAL 2: database was initialized with LC_COLLATE 'en_US',
        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 the postmaster, I can not however point to the data that I really need.

Help!

Thank you very much.

-Mike Baker

Re: problems with starting postpostmaster

From

John fabiani

Date:

06 November 2001, 12:20:55

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> </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.  I attempted to install
> t= he=20
> new rpms, but had many dependency failures.  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> </DIV>
> <DIV><FONT face=3DArial
> size=3D2>       = =20
> bash-2.05$ FATAL 2:  database was initialized with LC_COLLATE=20
> 'en_US',<BR>        which is not
> recogni= zed=20
> by setlocale().<BR>        looks like
> yo= u=20
> need to initdb.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </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.  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> </DIV>
> <DIV><FONT face=3DArial size=3D2>Help!</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Thank you very much.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </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

Re: problems with starting postpostmaster

From

John fabiani

Date:

06 November 2001, 13:07:48

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> </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.  I attempted to install
> t= he=20
> new rpms, but had many dependency failures.  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> </DIV>
> <DIV><FONT face=3DArial
> size=3D2>       = =20
> bash-2.05$ FATAL 2:  database was initialized with LC_COLLATE=20
> 'en_US',<BR>        which is not
> recogni= zed=20
> by setlocale().<BR>        looks like
> yo= u=20
> need to initdb.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </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.  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> </DIV>
> <DIV><FONT face=3DArial size=3D2>Help!</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Thank you very much.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </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