`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]> 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]> 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]> 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] > 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 > > > -- > 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 > > > -- > 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 > > > > -- > 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 -- 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
