sql-ledger-users

[SL] Upgrading postgresql - 8.0.8 -> 8.0.9

[Stroller <lin...@my...>]

Hi there,

My distro is offering me upgrades of postgresql and libpq, both from  
versions 8.0.8 to 8.0.9.

I do daily backups of my database using pg_dumpall - which I think is  
completely comprehensive - but I thought I'd check here first to see  
if there're any gotyas to be considered before I risk breaking  
anything. This will be my first postgresql upgrade since going live  
with SL; my distro demands that I uninstall the old version of  
postgresql before installing the new one, so I will be sure to stop  
it from the init scripts first.

Thanks in advance for any pointers of words of encouragement,

Stroller.

Re: [SL] Upgrading postgresql - 8.0.8 -> 8.0.9

[Hamish B. <hw...@be...>]

On Friday 05 January 2007 16:18, Stroller wrote:
> My distro is offering me upgrades of postgresql and libpq, both from
> versions 8.0.8 to 8.0.9.
<snip>
> Thanks in advance for any pointers of words of encouragement,

AAMOI I'm running SL and postgresql-8.0.9-r1 on Gentoo now with no problems, 
but haven't had to do a restore as yet.

Hamish
   
-- 
Sent via KMail 1.9.5, Gentoo 1.12.6, Linux-2.6.18-gentoo-r3

Re: [SL] Upgrading postgresql - 8.0.8 -> 8.0.9

[R P. <arc...@mt...>]

I'd do a pg_dumpall....
I'd also backup any postgresql config files that you customized......pg_hba.conf for example.

I'd also take a look at the upgrade documentation for the version you are upgrading to.
http://www.postgresql.org/docs/8.0/interactive/install-upgrading.html

Also check the docs for the package you are upgrading to.
Sometimes the package for your distribution will do things not shown in the postgresql docs.
For example....the recent Mandriva package tries to automatically backup, upgrade and restore the database. It failed on my machine... 
I had a  backups of the database and all my config files so it wasn't a big problem.

Cheers,
Roy



On Thursday 04 January 2007 9:18 pm, Stroller wrote:
> Hi there,
> 
> My distro is offering me upgrades of postgresql and libpq, both from  
> versions 8.0.8 to 8.0.9.
> 
> I do daily backups of my database using pg_dumpall - which I think is  
> completely comprehensive - but I thought I'd check here first to see  
> if there're any gotyas to be considered before I risk breaking  
> anything. This will be my first postgresql upgrade since going live  
> with SL; my distro demands that I uninstall the old version of  
> postgresql before installing the new one, so I will be sure to stop  
> it from the init scripts first.
> 
> Thanks in advance for any pointers of words of encouragement,
> 
> Stroller.