X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EAB3C9F9F73 for ; Tue, 18 Jul 2006 00:58:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 10349-05 for ; Tue, 18 Jul 2006 00:58:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sifyelnet.sify.net (elneti.sifycorp.com [202.144.77.54]) by postgresql.org (Postfix) with ESMTP id 113219F9F27 for ; Tue, 18 Jul 2006 00:58:07 -0300 (ADT) X-QHPSI: clean Received: (sifymail 23566 invoked by uid 508); 18 Jul 2006 09:28:01 +0530 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=corporate; d=sifycorp.com; b=gWxPdeD8M7nRIx8Qpr8Sj+U12q3tv8wTipa+5y5rhUpbWQ9+NgAELN5AYpC0HaBn ; Received: from ::ffff:210.210.122.77 (HELO sifydba) (dilipkumar_parikh@sifycorp.com@::ffff:210.210.122.77) by 10.1.8.60 with ESMTPA; 18 Jul 2006 09:28:01 +0530 Message-ID: <004401c6aa1d$03e942f0$4d7ad2d2@sifydba> From: "Dilipkumar" To: "Rojas, Fernando \(CIAT\)" , References: Subject: Re: Restarting PostgreSQL Date: Tue, 18 Jul 2006 09:18:22 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0041_01C6AA4B.1D985730" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/151 X-Sequence-Number: 22397 This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C6AA4B.1D985730 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Restarting PostgreSQLHi, If u have all your data's not try to start initdb just try using = /usr/local/pgsql/bin/pg_ctl -D /usr/local/psql/data start Thanks & Regards Dilipkumar ----- Original Message -----=20 From: Rojas, Fernando (CIAT)=20 To: pgsql-admin@postgresql.org=20 Sent: Monday, July 17, 2006 8:25 PM Subject: [ADMIN] Restarting PostgreSQL Im working with LINUX RH 8.x ((Red Hat Linux 8.0 3.2-7); I restart my = machine but when I'm trying start or restart PosgreSQl (8.0.7) Im getting this in the log file:=20 LOG: could not create IPv6 socket: Address family not supported by = protocol=20 FATAL: database files are incompatible with operating system=20 DETAIL: The database cluster was initialized with LC_COLLATE = "en_US.UTF-8", which is not recognized by setlocale().=20 HINT: It looks like you need to initdb or install locale support.=20 Some help for this.=20 Thank You=20 FERNANDO ROJAS=20 Ingeniero de Sistemas y Computaci=F3n=20 Unidad de Sistemas de Informaci=F3n=20 Centro Internacional de Agricultura Tropical (CIAT)=20 E-mail: frojas@cgiar.org=20 Phone:(57-2)445-01-00 Ext 3647=20 ********** DISCLAIMER ********** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at admin@sifycorp.com Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in ------=_NextPart_000_0041_01C6AA4B.1D985730 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Restarting PostgreSQL
Hi,
 
If u have all your data's not try = to start=20 initdb just try using /usr/local/pgsql/bin/pg_ctl -D = /usr/local/psql/data=20 start
 
 
Thanks & Regards
Dilipkumar
----- Original Message -----
From:=20 Rojas, = Fernando=20 (CIAT)
Sent: Monday, July 17, 2006 = 8:25 PM
Subject: [ADMIN] Restarting=20 PostgreSQL

Im working with LINUX  RH 8.x = ((Red Hat Linux=20 8.0 3.2-7); I restart my machine but when I'm trying start or restart=20 PosgreSQl (8.0.7)

Im getting this in the log file: =

LOG:  could not create IPv6 = socket: Address=20 family not supported by protocol
FATAL:  database files are incompatible with operating=20 system
DETAIL:  The = database cluster=20 was initialized with LC_COLLATE "en_US.UTF-8", which is not recognized = by=20 setlocale().
HINT:  It = looks like you=20 need to initdb or install locale support.

Some help for this.

Thank You

FERNANDO ROJAS
Ingeniero de Sistemas y Computaci=F3n
Unidad de Sistemas de Informaci=F3n
Centro Internacional de Agricultura Tropical (CIAT) =
E-mail: frojas@cgiar.org
Phone:(57-2)445-01-00 Ext 3647 =

------=_NextPart_000_0041_01C6AA4B.1D985730--