Re: 2 problems of my postgresql

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: "zenith siea *EXTERN*" <blackjadelin(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: 2 problems of my postgresql
Date: 2006-11-23 11:07:02
Message-ID: 52EF20B2E3209443BC37736D00C3C1380B8EF615@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

zenith siea wrote:

> see my operations first:
> [root(at)jhxz postgresql-8.0.8]# su postgres
> bash-2.05b$ initdb -D /usr/local/pgsql/data
> initdb: error while loading shared libraries: libssl.so.4: cannot open
> shared object file: No such file or directory
> bash-2.05b$ service postgresql status
> postmaster stopped
> bash-2.05b$ service postgresql start
>
> An old version of the database format was found.
> You need to upgrade the data format before using PostgreSQL.
> See /usr/share/doc/postgresql-8.0.8/README.rpm-dist for more
> information.
> bash-2.05b$
>
> Question 1:
> error in initting my pgsq database, libssl.so.4, what is it?
> what shall i do?

libssl.so.4 is a shared library that is needed by PostgreSQL.

What you should do:

- Tell us which operating system you have.
- Tell us which version of PostgreSQL you have installed.
- Tell us how you installed it: RPM? From where did you get it?
- Tell us if there was a different version of PostgreSQL on the same
machine before?

For the ssl problem, you need to install OpenSSL.

> Question 2:
> the old version of database format, i have deleted old
> database"/usr/local/pgsql/data",
> but why do pgsq complain about it?
> there are no database in my pgsq now and no database can be updated.
> I have looked into the file
> /usr/share/doc/postgresql-8.0.8/README.rpm-dist
> and found nothing about this quesiton, is it this file the
> right manual?
> what should i do?

Is the environment variable PGDATA set? If yes, to what value?

In /etc/init.d/postgresql, what is the value of the -D option
for postmaster?

There is probably an old database there.

Yours,
Laurenz Albe

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-11-23 11:20:24 Re: URL Decoding
Previous Message Andreas Kretschmer 2006-11-23 10:09:05 Re: log database changes - a design problem?