Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues?

Binary backups are not going to work across major releases so just
installing 8.0 with your old cluster won't work.

You'll need to do a pg_dump of your old setup and then restore on your
new cluster.

Hope this helps,

On Wed, Jul 27, 2005 at 12:27:41AM -0400, Mark Mikulec wrote:
> Hi there,
>
> This may be a stupid question but I feel I should ask it anyway just to be
> sure, since I've had problems in the past.
>
> I currently have a defunct Debian 3.0 system running PostgreSQL 7.4.1, in
> which I am going to do an entire blob backup dump of all the databases in
> hopes to restore them on my new, more secure system running the latest
> OpenBSD, and PgSQL 8.0.
>
> So my question is: Are they any issues that I should be aware up restoring
> on a more recent version of PgSQL, and/or issues using a completely
> different operating system altogether? I have some strange pg language
> mishaps going from 7.2 to 7.4 last backup, although frightening, I overcame
> them with some fiddling.
>
> Thanks in advance,
> Mark
>
> --
> ___________________
> Roses are #FF0000
> Violets are #0000FF,
> All my base
> Are belong to you.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.