Greetings,
I'm attempting to set up a django project using amazon redshift as the database backend. I started a fresh 1.6.5 project and set up the database portion of settings.py to use the redshift cluster. With just the default apps (admin, auth, contenttypes, sessions, messages, and staticfiles), I ran syncdb and got this: https://dpaste.de/y98N. Compared to vanilla postgre, redshift doesn't support some things, including some constraints, which is what's making syncdb blow up.
What worries me in that backtrace is, the table creation sql that has the offending constraint in it is being generated in commands/syncdb.py, so that's before we even get to the postgresql_psycopg2 backend code, right? So hacking on the postgres backend to make it jive with redshift wouldn't help, here. (Correct me if I'm wrong!)
Anyway, what wisdom can you share? What's the best way to approach this? Is trying to get this to work even a good idea? Any guidance would be greatly appreciated.
Thanks!
jpk
--
john p. kiffmeyer
-- I'm attempting to set up a django project using amazon redshift as the database backend. I started a fresh 1.6.5 project and set up the database portion of settings.py to use the redshift cluster. With just the default apps (admin, auth, contenttypes, sessions, messages, and staticfiles), I ran syncdb and got this: https://dpaste.de/y98N. Compared to vanilla postgre, redshift doesn't support some things, including some constraints, which is what's making syncdb blow up.
What worries me in that backtrace is, the table creation sql that has the offending constraint in it is being generated in commands/syncdb.py, so that's before we even get to the postgresql_psycopg2 backend code, right? So hacking on the postgres backend to make it jive with redshift wouldn't help, here. (Correct me if I'm wrong!)
Anyway, what wisdom can you share? What's the best way to approach this? Is trying to get this to work even a good idea? Any guidance would be greatly appreciated.
Thanks!
jpk
john p. kiffmeyer
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEQ4iqWJWH7s01osREW3j%3Dt%2BZ5tPQU8_08mtn-WWUF0a5gOAeA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment