Re: Postgresql v 8.0.1-3 problems - Mailing list pgsql-novice

From
Subject Re: Postgresql v 8.0.1-3 problems
Date
Msg-id 20051221174010.66118.qmail@web33301.mail.mud.yahoo.com
Whole thread Raw
In response to Postgresql v 8.0.1-3 problems  (Miguel <migabolinux@yahoo.com>)
List pgsql-novice
--- Miguel <migabolinux@yahoo.com> wrote:

> I have used Postgresql v.7.3 under Fedora  v.1.0
> working fine all the time but after I have  made
> upgrade to Fedora 4,  when  I  try init my
> postgresql
> using the command line :
> service postgresql start
> I couldn't start my database, an error message
> appears
> as follow :
>
> > Was an old version of the format of the data base.
>
> It needs to update the data format before using
> PostgreSQL.  To
> see/usr/share/doc/postgresql-8.0.3/README.rpm-dist
> for
> more information.
>
> Please I hope for help to me . Thanks

Miguel, it sounds like pgsql was updated between FC1
and FC4.

as i understand it, the proper way to do this is to
dump the db under 7.3 and then restore it to 8.0.3.

based on the error message, it doesn't seem you can
just update the db without updating the data format
via dump/retore.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: transfer database from Linux to Windows
Next
From: "Johannes Brügmann"
Date:
Subject: Re: plpgsql function returning SETOF