Re: Help with postgresql upgrade

2009-08-03 Thread Andrew Perrin
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, Yes, I'm painfully aware of the irony! --

Re: Help with postgresql upgrade

2009-08-03 Thread Glyn Astill
> From: Andrew Sackville-West > > > > 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 > > > | bzip2 -c | dd of=/dev/nst0 > obs=512 > > > conv=sync > > > > > > > > A guess, corre

Re: Help with postgresql upgrade

2009-08-03 Thread Andrew Sackville-West
On Mon, Aug 03, 2009 at 03:45:13PM +, 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 dat

Re: Help with postgresql upgrade

2009-08-03 Thread Glyn Astill
--- On Mon, 3/8/09, Ron Johnson wrote: > From: Ron Johnson > Subject: Re: Help with postgresql upgrade > To: debian-user@lists.debian.org > Date: Monday, 3 August, 2009, 4:14 PM > On 2009-08-03 09:31, Andrew Perrin > wrote: > > Greetings all- > > > >

Re: Help with postgresql upgrade

2009-08-03 Thread Suno Ano
- first you install the newest version of pg - then drop it is cluster, not the .deb - upgrade the old cluster i.e. databases to the newest version of your pg installation see /usr/share/doc/postgresql-8.4/README.Debian.gz pgp4x9FWFxT0o.pgp Description: PGP signature

Re: Help with postgresql upgrade

2009-08-03 Thread Ron Johnson
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. Typically I would use pg_upgradecluster to fix this problem; howev