Anyone know how to enable the citext extension on Heroku?
Sent with Sparrow (http://www.sparrowmailapp.com/?sig) 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] For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en
