Thread: Restarting PostgreSQL

Restarting PostgreSQL

From

"Rojas, Fernando (CIAT)"

Date:

17 July 2006, 15:19:41

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:

LOG: could not create IPv6 socket: Address family not supported by protocol
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 setlocale().
HINT: It looks like you need to initdb or install locale support.

Some help for this.

Thank You

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

Re: Restarting PostgreSQL

From

Tom Lane

Date:

17 July 2006, 17:06:00

"Rojas, Fernando (CIAT)" <f.rojas@cgiar.org> writes:
> 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 setlocale().
> HINT:  It looks like you need to initdb or install locale support.

Like the hint says, you seem to be missing locale support.  Perhaps you
removed the relevant packages?  I'm not sure about RHL8, but on some
Linux distributions the needed files are in glibc-locale.

BTW, RHL8 is really old; you ought to think about updating to a more
modern OS release.

            regards, tom lane

Re: Restarting PostgreSQL

From

"Dilipkumar"

Date:

18 July 2006, 03:58:22

Hi,

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 -----
From: Rojas, Fernando (CIAT)
To: pgsql-admin@postgresql.org
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:
LOG: could not create IPv6 socket: Address family not supported by protocol
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 setlocale().
HINT: It looks like you need to initdb or install locale support.
Some help for this.
Thank You
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