Thanks for the help John. I found the instructions here v. useful for getting the postgres user/ database created in ubuntu: https://help.ubuntu.com/community/PostgreSQL
and pgadmin looks ok though it doesn't play well with Ubuntu Netbook remix, so I too may revert to using Netbeans (which I'd actually forgotten had a db browser!) I also had some problems with a plugin (query_reviewer) directly requiring the mysql adapter so I removed it. Must investigate an alternative for query performance tuning. Luckily, although this is an existing app, there's no data to migrate and very few non-activerecord queries. Thanks, Jamie On Feb 5, 3:14 pm, John McCaffrey <[email protected]> wrote: > The standard setup described on postgresql.org should work for linux or > windows <http://www.postgresql.org/download/windows.html> (mac is a > different story) > > I'm currently in the process of trying to keep a rails app working with > mysql and postgres, in an effort to stay db agnostic, 'heroku ready', and > because I like postgres more for lots of other reasons.. > > If you are converting an existing app, here are some things I've run into:: > > 1. Case sensitivity (mysql is case insensitive, postgres is not) > 2. convert to sql standard functions: use coalesce instead of IFNULL, > case instead of if > 3. Mysql lets you do 'limit 10,10' in postgres you have to do 'limit 10 > offset 10' > 4. string escape syntax is different > > there are similar client/gui tools for postgres. (though, I've recently gone > back to using Netbeans built in query tool, as it saves all my recent > queries and just makes life easier) > > Google for: rails ~move mysql to postgres to see what others have said > about general differences (also, keep searching through this heroku list, as > many people have gone through this) > > One of the better write ups comes from the guys over at the very awesome > real estate sitewww.redfin.com > http://blog.redfin.com/devblog/2008/02/mysql_to_postgres.html > > <http://blog.redfin.com/devblog/2008/02/mysql_to_postgres.html>Best of luck, > and welcome to Heroku! > > -John > > > > > > On Fri, Feb 5, 2010 at 4:56 AM, Jamie Lawrence <[email protected]> wrote: > > I need to move my development from mysql to postgres so I can better > > match the heroku environment. > > > Does anyone have a good tutorial/stack to start with postgres on > > ubuntu and windows? I only ask because sometimes the official packages > > are not the easiest way to get a database setup and postgres is > > frequently described as harder than mysql to setup. > > > I also use the MySQL Query Browser for testing/introspection. Is there > > a similar tool available for postgres? > > > Thanks! > > > Jamie > > > -- > > You received this message because you are subscribed to the Google Groups > > "Heroku" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<heroku%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/heroku?hl=en. > > -- > -John -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
