That's a question I can't really answer. I don't know if there's a way to access your app's Postgres data remotely; I'd guess no, because it seems like a security issue. Most people probably don't actually try to use the same database for development & production, because you're going to be changing your development database back and forth, and you don't want to put anything in your production database that your production code isn't ready to handle yet. Probably best to just recognize that the databases are separate, and simply work out a way to import your data from one to the other -- copying the data, rather than sharing it. Of course, you'd probably not want to copy your development database directly to your production site -- you'd lose whatever data has been generated by your users.
...Paul On Thu, Jan 8, 2009 at 2:50 PM, HazardJ <james.g.haz...@gmail.com> wrote: > > Thanks very much. I confirmed that you are right by getting rid of > the login -- the database is indeed empty of my document content. I > presume that to get local and Heroku to work alike I need to use > Postgres locally? And then git from one to the other? Is there a > simpler way of getting information from sqlite to Postgres? > > > > On Jan 8, 2:22 pm, "Paul Clegg" <dotdotdotp...@gmail.com> wrote: > > The database on the Heroku side is not the same as what you use on your > > local development, regardless of whether or not your sqlite database is > > checked in or not (it probably shouldn't be). Heroku uses a Postgres > > database, which will, by definition, be separate and different than your > > local development Sqlite database. So it's probably failing because your > > login data doesn't exist on the Heroku side of things. > > > > ...Paul > > > > On Thu, Jan 8, 2009 at 12:55 PM, HazardJ <james.g.haz...@gmail.com> > wrote: > > > > > Hi everyone, > > > > > Heroku is really great. So good that I was able to upload and get my > > > application working, though I'm very, very inexperienced. Bravo. > > > I've got a problem that escapes me -- when I reinstalled the app > > > (tarballed upload) my login _within_the_app (SessionsController) won't > > > let me log in anymore. It doesn't like any of the user / password > > > combinations. > > > The /session page comes up but I go into a samsara of login where it > > > gently declines to accept any of my user/password combinations. > > > As I was uploading the many different times, I did get some kind of > > > error a few times. But others were smooth, including the most > > > recent. > > > > > Tests I've done so far: > > > I've checked the original on my computer (0.0.0.0:3000). It works > > > fine. > > > I've tarballed in tar.gz (both with log and tmp and without) and > > > in .zip any number of times. No luck. > > > I'm used to making mistakes and have tried it over and again. > > > The files seem to all be there, including the sqlite3 file. > > > > > Any thoughts? > > > Thanks, James > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
