version() shows it's on 8.3. So I have to wait and hope for some good news tomorrow?
Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Thursday, April 26, 2012 at 12:41 PM, Peter van Hardenberg wrote: > `create extension citext` > > only available on 9.1 databases but not on the beta > heroku-shared-postgresql addon which is a serious bummer. > > watch http://postgres.heroku.com/blog tomorrow-ish though. > > -p > > On Thu, Apr 26, 2012 at 12:36 PM, josh coffman <[email protected] > (mailto:[email protected])> wrote: > > Anyone know how to enable the citext extension on Heroku? > > > > > > Sent with Sparrow > > > > On Wednesday, April 25, 2012 at 10:49 PM, josh coffman wrote: > > > > 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] > > (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
