Peter, I do like the simplicity of a bundled app. Maybe I'm missing something or remnants of previous setups are mucking things up, but I can't connect to the postgres instance. At least I assume it's best to connect and create a user and database. I added the path to my bash profile as given by the app document. I check the psql location with 'which psql' and it points to the postgres app as expected.
This is getting a little OT so feel free to email me directly if you think it's appropriate. joshcoffman at gmail. example commands: MacBookPro1:~ josh$ createuser waypost Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n createuser: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"? MacBookPro1:~ josh$ psql -h localhost psql: invalid connection option "client_encoding" -josh On Wednesday, April 25, 2012 at 4:59 PM, Peter van Hardenberg wrote: > The app really makes life simple. You download the app. When you want > to run Postgres, you open the app. It puts an icon in the menubar > showing the database is running. When you quit, it goes away. > > -p > > On Wed, Apr 25, 2012 at 4:30 PM, josh coffman <[email protected] > (mailto:[email protected])> wrote: > > Peter, > > > > I laughed at the analogy for running ruby 1.8.6 / 1.9.3, and its a fair > > point. I've installed and removed postgres locally a couple times using > > homebrew. I guess I should do it again, but I'll check out your app too. > > Thanks. > > > > -j > > > > > > Sent with Sparrow > > > > On Wednesday, April 25, 2012 at 4:19 PM, Peter van Hardenberg wrote: > > > > Hi Josh, > > > > you should never run SQLite locally and Postgres in production. That'd > > be like running Ruby 1.8.6 in development and 1.9.3 in production... > > only worse. > > > > Postgres has historically kind of been a pain to install if you're on > > Mac, but we just released a beta version of http://postgresapp.com > > which might make your life much easier. Check it out and let us know > > if you have any problems. > > > > -p > > > > On Wed, Apr 25, 2012 at 4:16 PM, josh coffman <[email protected] > > (mailto:[email protected])> wrote: > > > > Hi, > > > > I've realized I need to change a column type to citext on heroku, and I > > would like everything to keep working using sqlite locally. Is there a way > > to do that with a migration, or will I have to use a manual sql ALTER query. > > > > Thanks, > > Josh > > > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Heroku" group. > > > > To unsubscribe from this group, send email to > > [email protected] > > (mailto:[email protected]) > > For more options, visit this group at > > http://groups.google.com/group/heroku?hl=en_US?hl=en > > > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Heroku" group. > > > > To unsubscribe from this group, send email to > > [email protected] > > (mailto:[email protected]) > > For more options, visit this group at > > http://groups.google.com/group/heroku?hl=en_US?hl=en > > > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Heroku" group. > > > > To unsubscribe from this group, send email to > > [email protected] > > (mailto:[email protected]) > > For more options, visit this group at > > http://groups.google.com/group/heroku?hl=en_US?hl=en > > > > > -- > You received this message because you are subscribed to the Google > Groups "Heroku" group. > > To unsubscribe from this group, send email to > [email protected] > (mailto:[email protected]) > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en_US?hl=en > > -- You received this message because you are subscribed to the Google Groups "Heroku" group. 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_US?hl=en
