tag:blogger.com,1999:blog-7856654040597600335.post3694791641967389824..comments2024-03-29T00:35:02.442-07:00Comments on Application Development with Lex Sheehan: Upgrade from PostgreSQL 9.2.4 to 9.3.1 on OSX 10.9 and Centos 6.5Application Development with Lex Sheehanhttp://www.blogger.com/profile/08077799892181617965noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7856654040597600335.post-39800014018847532802014-04-29T04:51:50.706-07:002014-04-29T04:51:50.706-07:00This comment has been removed by the author.railsguage48https://www.blogger.com/profile/10852601171189630894noreply@blogger.comtag:blogger.com,1999:blog-7856654040597600335.post-77844077538564463752014-04-26T16:51:30.291-07:002014-04-26T16:51:30.291-07:00This comment has been removed by the author.railsguage48https://www.blogger.com/profile/10852601171189630894noreply@blogger.comtag:blogger.com,1999:blog-7856654040597600335.post-23614420701298501842014-03-07T10:41:57.706-08:002014-03-07T10:41:57.706-08:00In order for the pg_upgrade command to work, it mu...In order for the pg_upgrade command to work, it must have access to both (versions of PG) bin directories. <br /><br />So, if the older version of PG got deleted somehow, just install that old version, too.<br /><br />$ brew info postgresql # << to see what versions are installed locally<br /><br />$ brew which postgresql #<< to see which version is active<br /><br />$ brew versions postgresql #<< to make sure old version is available<br /><br />For the example in this post... Among other lines, you'll see:<br />. . .<br />9.2.4 git checkout e3ac215 Library/Formula/postgresql.rb<br />. . .<br /><br />Install 9.2.4 and return state of PG to current version:<br /><br />$ cd $( brew --prefix ) #<< go to brew home directory<br />$ git checkout e3ac215 Library/Formula/postgresql.rb<br />$ brew install postgresql #<< install old version<br />$ git checkout -- Library/Formula/postgresql.rb #<< reinstall latest PG version<br />$ brew switch postgresql 9.3.1 #<< assuming PG 9.3.1 is the latest version<br /><br />Now, you should have 9.2.4 installed (as well as the latest 9.3.1 version) and you should be able to run the pg_upgrade command.<br /><br />Good luck!Application Development with Lex Sheehanhttps://www.blogger.com/profile/08077799892181617965noreply@blogger.comtag:blogger.com,1999:blog-7856654040597600335.post-71499680175003254412014-03-06T08:06:30.491-08:002014-03-06T08:06:30.491-08:00http://serverfault.com/questions/580273/osx-maveri...http://serverfault.com/questions/580273/osx-mavericks-installed-no-more-postgresqljgrannashttps://www.blogger.com/profile/12192533890525820310noreply@blogger.comtag:blogger.com,1999:blog-7856654040597600335.post-67256798309682775132014-03-06T08:05:29.626-08:002014-03-06T08:05:29.626-08:00What if i have no old version of Postgres in my /C...What if i have no old version of Postgres in my /Cellar folder? I have the new 9.3.3 version folder in the Cellar, but for some reason no 9.2.4<br /><br />I had 9.2.4 previously, but cannot find my binaries folder for it to run the pg_upgrade command on my data.jgrannashttps://www.blogger.com/profile/12192533890525820310noreply@blogger.com