Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues? - Mailing list pgsql-general

From Mark Mikulec
Subject Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues?
Date
Msg-id 9c3ee1350507270815329c11f1@mail.gmail.com
Whole thread Raw
In response to Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Hi Martjin,

That's what I meant.. I would do my pg_dumps using: pg_dump -U postgres -Ft -b dbname > dbname.tar

And restore them via: pg_restore -O -U postgres -d dbname dbname.tar

That should be cool, yes?

Mark

On 7/27/05, Martijn van Oosterhout <kleptog@svana.org> wrote:
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@svana.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.





--
___________________
Roses are #FF0000
Violets are #0000FF,
All my base
Are belong to you.

pgsql-general by date:

Previous
From: jbduffy@tiscali.co.uk
Date:
Subject: Real vs Float & 32bit vs 64bit CPU Performance Question
Next
From: Ezequiel Tolnay
Date:
Subject: Re: pg_get_serial_sequence and table inheritence