On Mon, Aug 03, 2009 at 03:45:13PM +0000, Glyn Astill wrote: > > > On 2009-08-03 09:31, Andrew Perrin > > wrote: > > > Greetings all- > > > > > > Running postgresql under debian, my standard apt-get > > upgrade upgraded me > > > from 8.3 to 8.4. As a result, I no longer have access > > to the databases > > > that were created under 8.3. [...] > > > 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
Attachment:
signature.asc
Description: Digital signature