Re: Help with postgresql upgrade

[Glyn Astill <glynastill@yahoo.co.uk>]

> From: Andrew Sackville-West <andrew@farwestbilliards.com>

> > > > 2.) Can someone help with the restore
> process from
> > > tape? The command my
> > > > script uses to write the backups to tape
> is:
> > > >         pg_dump -F t
> > > <databasename> | bzip2 -c | dd of=/dev/nst0
> obs=512
> > > conv=sync
> > > > 
> > 
> > A guess, correct me if I'm wrong;
> > 
> > dd if=/dev/nst0 | bzip2 -d -c | pg_restore -U
> <username> -C -F t -d <database name>
> > 
> 
> just to be annoying and point out the obvious, a backup is
> not a
> backup if you don't know how to restore from it...
> 
> A
> 

Aye, and you should be restoring it periodically to validate it - all my systems restore daily and validate the data,