2 problems of my postgresql

Started by blackjadelinover 19 years ago2 messagesgeneral
Jump to latest
#1blackjadelin
blackjadelin@gmail.com

see my operations first:
[root@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?

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?

#2Albe Laurenz
all@adv.magwien.gv.at
In reply to: blackjadelin (#1)
Re: 2 problems of my postgresql

zenith siea wrote:

see my operations first:
[root@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