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.