Re: [GENERAL] Backup and restore from 7.4.1 to latest, crossing

Mark, > 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 issue

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

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? MarkOn 7/27/05, Martijn van Oosterhout wrote: Binary backups are not

Re: [GENERAL] 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, > >

[GENERAL] Backup and restore from 7.4.1 to latest, crossing platforms... issues?

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