Thread: Problem Starting Postgresql after upgrade from SuSE8.1 to SuSE 8.2

Problem Starting Postgresql after upgrade from SuSE8.1 to SuSE 8.2

From
pawlicki@mailandnews.com (John Pawlicki)
Date:
I upgrade to SuSE 8.2 and it upgraded Postgresql from 7.2 to 7.3.2. I
use a script file to start Postgresql, this is the contents.

#!/bin/sh
/usr/bin/postmaster -i -D /usr/share/pgsql/data


And now this is what I get:

john@linux:~> ./sql
FATAL:  The data directory was initialized by PostgreSQL version 7.2,
which is not compatible with this version 7.3.2.
john@linux:~>

My question is, "What to do now to get access to my postgresql data
files? I can correct this?"

Thanks for your help

John

Re: Problem Starting Postgresql after upgrade from SuSE8.1 to SuSE 8.2

From
Doug McNaught
Date:
pawlicki@mailandnews.com (John Pawlicki) writes:

> I upgrade to SuSE 8.2 and it upgraded Postgresql from 7.2 to 7.3.2. I
> use a script file to start Postgresql, this is the contents.
>
> #!/bin/sh
> /usr/bin/postmaster -i -D /usr/share/pgsql/data
>
>
> And now this is what I get:
>
> john@linux:~> ./sql
> FATAL:  The data directory was initialized by PostgreSQL version 7.2,
> which is not compatible with this version 7.3.2.
> john@linux:~>
>
> My question is, "What to do now to get access to my postgresql data
> files? I can correct this?"

Best thing to do is download the latest 7.2 version (7.2.3?), compile
and install it in a separate location.  Start it up with PGDATA set
to you /usr/share/pgsql/data and use pg_dump to dump out your
databases.  You can then 'initdb' your data area and start up 7.3,
then restore your databases.

Make sure to save off a copy of $PGDATA before you run 'initdb'...

-Doug

Re: Problem Starting Postgresql after upgrade from SuSE8.1 to SuSE 8.2

From
Wolfgang Kueter
Date:
John Pawlicki wrote:

> I upgrade to SuSE 8.2 and it upgraded Postgresql from 7.2 to 7.3.2.

You should have RTFM before doing that.

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=migration.html

Hopefully you have backups to restore from.

Wolfgang
--
A foreign body and a foreign mind
never welcome in the land of the blind
Peter Gabriel, Not one of us, 1980