Re: Problem while OS-Update

From: Heiko Pohl <Heiko(dot)Pohl(at)VR-Web(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem while OS-Update
Date: 2004-06-22 06:32:57
Message-ID: 40D7D299.5020604@VR-Web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>Heiko Pohl <Heiko(dot)Pohl(at)VR-Web(dot)de> writes:
>
>
>>Thank You, I installed now the 7.2.4-Version and it works. But how do I
>>reach my Data? My 7.2.-installation is now in /usr/local/pgsql/ , my
>>data - also 7.2 - are in /usr/lib/pgsql.old/data/ ...??
>>
>>
>
>Point the postmaster to that data directory with PGDATA or -D switch.
>
> regards, tom lane
>
I tried the following:

-bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql.old/data
FATAL 2: The database cluster was initialized with LC_COLLATE
'de_DE.UTF-8' and
LC_CTYPE 'de_DE.UTF-8', but the server was compiled without
locale support.
It looks like you need to initdb or recompile.
-bash-2.05b$

Then:

-bash-2.05b$ /usr/local/pgsql/bin/initdb -D /var/lib/pgsql.old/data/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

initdb: The directory /var/lib/pgsql.old/data/ exists but is not empty.
If you want to create a new database system, either remove or empty
the directory /var/lib/pgsql.old/data/ or run initdb with
an argument other than /var/lib/pgsql.old/data/.
-bash-2.05b$

How can I recompile? Or is there another possibility?

Heiko

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kuti Attila 2004-06-22 07:45:40 PGplSql: Relation 44451 does not exist
Previous Message Dennis Gearon 2004-06-22 05:42:40 Re: who can run utility - pg_controldata ?