Have you tried using Postgres Foreign Data Wrappers? There's a redis fdw that will allow you to use SQL from Postgres and query the keys in Redis.
http://www.postgresql.org/docs/9.4/static/sql-createforeignd...
http://www.postgresql.org/docs/9.4/static/sql-createforeignd...