I go into configuring postgres for my automation book. You can also check out the source code to see how my script set ups postgres.<p><a href="http://www.amazon.com/Deploy-Rails-BlueBook-2014-Edition-ebook/dp/B00GZ9SNKY" rel="nofollow">http://www.amazon.com/Deploy-Rails-BlueBook-2014-Edition-ebo...</a><p><a href="https://github.com/jbwyatt4/railsbluebook2014/blob/master/cookbooks/deployserver/recipes/dbinstall.rb" rel="nofollow">https://github.com/jbwyatt4/railsbluebook2014/blob/master/co...</a><p>Just remember to login as the postgres user in Linux.
For SQL in general SQLZoo is a horrible looking website, but if you go through the tracks you will actually learn a bit.<p>If you're having issues with using postgresql with Rails and heroku (judging from post below), then you're really asking how use those three things together. In this case there are plenty of examples of all the things that can go wrong and how to fix them on stack overflow. If you'd like to send me the errors you're getting and other details of why it's breaking I'd be glad to field a couple emails (contact in profile).
Newbie in what sense?<p>Are you an experienced database administrator looking at postgreSQL for a new project?<p>Are you an experienced programmer, coming to postgreSQL as an option for your first project with three tiered architecture?<p>Are you new to programming and want to learn to database?<p>Are you new to databases and expect them to be pretty much like word processors and spreadsheets?
<a href="http://use-the-index-luke.com/" rel="nofollow">http://use-the-index-luke.com/</a> helps when you deal with performance issues. The examples can be altered for your particular SQL server including postgres.