Can't upgrade from 7.0 to 7.1. Script failure.

From: Antonio Gennarini <antonio(at)sunstone(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't upgrade from 7.0 to 7.1. Script failure.
Date: 2002-02-13 22:40:01
Message-ID: 20020213224001.C20075@geolandia.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I just updated from versione 7.0.3-8 to 7.1.3-2 on my RH7.1. When I tried to '/etc/rc.d/init/postgres start' I got the warning that the DB format belonged to a old version and so I had to updated the data. So I read the /usr/share/doc/postgresql-7.1.3/README.rpm-dist and followed all the steps in the UPDATE section. However as I ran the 'postgresql-dump -t /var/lib/pgsql/backup/db.bak -p /var/lib/pgsql/backup/old -d' command I got the message telling me that:

--------------------------------------------------------------------------------------
[root(at)gaia backup]# su postgres
bash-2.04$ postgresql-dump -t /var/lib/pgsql/backup/db.bak -p /var/lib/pgsql/backup/old -d
/usr/bin/postgresql-dump: [: /var/lib/pgsql/backup/db.bak: unary operator expected
/usr/bin/postgresql-dump: [: /var/lib/pgsql/backup: unary operator expected
/usr/bin/postgresql-dump: [: /var/lib/pgsql: unary operator expected
/usr/bin/postgresql-dump: [: /var/lib: unary operator expected
/usr/bin/postgresql-dump: [: /var: unary operator expected
The PostgreSQL database format has not changed; there is
no need to do a dump and restore with this script.
ASCII dump file /var/lib/pgsql/backup/db.bak does not exist.
bash-2.04$
--------------------------------------------------------------------------------------

However when I try launching the postmaster I still get the message:

--------------------------------------------------------------------------------------
[root(at)gaia backup]# /etc/rc.d/init.d/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-7.1.3/README.rpm-dist for more information.
[root(at)gaia backup]#
--------------------------------------------------------------------------------------

Can someone please help me out with this problem.

Thanks
--
Antonio Gennarini
Crecchio, CH - ITALY
-----------------------------------
Earth Science student at University "G. D'Annunzio".
Join th GNU generation, start from LINUX.

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Anto 2002-02-13 22:45:16 Re: insert within pl/pgsql procedures: NOVICE question ?
Previous Message Stephan Szabo 2002-02-13 22:25:10 Re: insert within pl/pgsql procedures: NOVICE question ?