On 03/24/2010 10:14 AM, Alan Bourke wrote: > "Complaint: Here's the bind the 9.10 upgrade puts postgresql users in: > It apparently erases enough of 8.3 so it can't be started, but not so > much that a non-expert user can tell, either from command line or > boot-up manager, that 8.3 needs to be reinstalled. Also, when attempting > to start 8.3 without a reinstall, there are no error messages to tip the > user off that anything is wrong. In addition, the fact that 8.3 has been > partially removed means that data from 8.3 cannot be accessed and the > data cluster can't be upgraded to the newly installed 8.4. This is an > unnecessary situation that didn't occur in previous version upgrades." > > Of course it's taken me 2 days to find that out. Sigh. >
I found this just in case anyone else is having this problem. http://ubuntuforums.org/showthread.php?t=1335999 BTW, I think the format of installing PostgreSQL 8.4 and assigning it port 5433 right next to PostgreSQL 8.3 on port 5432 is to allow you to do a backup of your databases in 8.3 using the "dumpall" command, and then restoring the dump to PostgreSQL 8.4. This is necessary between major upgrades to re-calibrate your data. In order to do this easily, it's a good idea to have your PostgreSQL ".bash_profile" file in place, so it's not necessary to constantly have to re-enter the PostgreSQL "postgres" super user password. The dumpall and restore of the dumpall is done using super user postgres. This is the way my PostgreSQL .bash_profile looks. ############ .bash_profile ############ [ -f /etc/profile ] && source /etc/profile ## Path to databases PGDATA=/var/lib/pgsql/data ## Paths used by PostgreSQL "postgres" user and stored in "postgres" enviroment variable PATH=$PATH:$HOME/bin ## the PostgreSQL "postgres" super user password PGPASSWORD=PassWord-For-posgres export PGDATA PATH PGPASSWORD ############### End of .bash_profile ############## The .bash_profile file should be located in the home directory of the Ubuntu "postgres" user. Remember the ubuntu "postgres" user and the PostgreSQL "postgres" user are two completely different things. http://www.smvfp.com/pgsqlhtml/backup.html Regards, LelandJ _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
