On Thursday, February 26, 2015 at 12:15:59 PM UTC-8, [email protected]
wrote:
>
> I've been trying to get this to work for a while now without any success.
>
> We have an Amazon Redshift database. I want to execute custom SQL queries
> against it, like select count or load files.
>
> The two main approaches I've tried are using the postgres adapter and
> using the sequel-redshift (https://github.com/remind101/sequel-redshift)
> gem. Since I'm mostly going to be running raw SQL against it, I am fine w/
> a postgres adapter, but both of those give me an error about unrecognized
> configuration parameter "standard_conforming_strings"
>
> db = Sequel.connect('redshift://
> admin:mypassw...@mycompany-dw.klasdf8390a.us-east-1.redshift.amazonaws.com:5439/dev
> ')
>
> db.fetch("SELECT COUNT(*) FROM mytable").all
>
> Sequel::DatabaseConnectionError: PG::UndefinedObject: ERROR: unrecognized
> configuration parameter "standard_conforming_strings"
>
> Can someone help me?
>
> Thanks!
>
Sequel currently does not offer specific support for Redshift. Redshift is
based on PostgreSQL 8.0, and the minimum supported PostgreSQL version in
Sequel is 8.2.
You should be able to work around that error:
db = Sequel.connect('redshift://
admin:mypassw...@mycompany-dw.klasdf8390a.us-east-1.redshift.amazonaws.com:5439/dev
?force_standard_strings=f')
Note that there may well be other things that don't work with RedShift.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
