SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 06:56 AM
| ||||
| ||||
 pgdump from 8.0.4 not valid for import into 8.1.0 ? In pgAdminIII linked to 8.0.4 server did a backup of all databased. Chose "plain" and saved to disk. uninstalled 8.0.4 installed 8.1.0 create database in pgAdminIII v1.4 restore ---- reports as not a valid archive. Obviously this is not what I expect. Some older backups from a 7.4.? server on a Redhat machine will restore. Please ? why is what I have done failed. thanks Richard ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings      |
|
04-09-2008, 06:56 AM
| |||
| |||
| Re: pgdump from 8.0.4 not valid for import into 8.1.0 Richard Sydney-Smith wrote: > ? In pgAdminIII linked to 8.0.4 server did a backup of all databased. > Chose "plain" and saved to disk. > uninstalled 8.0.4 > installed 8.1.0 > > create database in pgAdminIII v1.4 > restore > ---- reports as not a valid archive. > > Obviously this is not what I expect. > Some older backups from a 7.4.? server on a Redhat machine will restore. I'd guess it's expecting the "custom" archive format which lets you pick and choose what to restore. Someone more knowledgable will pop up and say for certain shortly. You should be able to feed a "plain" backup to psql or to pg_restore though. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
|
04-09-2008, 06:58 AM
| ||||
| ||||
| Re: pgdump from 8.0.4 not valid for import into 8.1.0 Thanks Richard. Backup as compressed worked. Richard Huxton wrote: > Richard Sydney-Smith wrote: > >> ? In pgAdminIII linked to 8.0.4 server did a backup of all databased. >> Chose "plain" and saved to disk. >> uninstalled 8.0.4 >> installed 8.1.0 >> >> create database in pgAdminIII v1.4 >> restore >> ---- reports as not a valid archive. >> >> Obviously this is not what I expect. >> Some older backups from a 7.4.? server on a Redhat machine will restore. > > > I'd guess it's expecting the "custom" archive format which lets you > pick and choose what to restore. Someone more knowledgable will pop up > and say for certain shortly. > > You should be able to feed a "plain" backup to psql or to pg_restore > though. > > -- > Richard Huxton > Archonet Ltd > > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
