search

treasure-data / prestogres

PostgreSQL protocol gateway for Presto distributed SQL query engine
Other
292 stars 61 forks source link

ERROR: schema "prestogres_catalog" does not exist #15

Closed dhararon closed 6 years ago

dhararon commented 10 years ago

Hi, i dont know if i configured some wrong but when i try to make a query return ERROR: schema "prestogres_catalog" does not exist

i have this: EC2 Amazon RDS

| prestogres | --> | POSTGRESQL |

my backend 0 is

backend_hostname0 = 'RDS IP ' # Host name or IP address to connect to for backend 0 backend_port0 = 5432 # Port number for backend 0

the connection is ok, but show this error "ERROR: schema "prestogres_catalog" does not exist" it's a problem in my config?

best, dharwin

frsyuki commented 10 years ago

Are you using Amazon RDS as the PostgreSQL backend? I think it doesn't work because Amazon RDS doesn't allow us to install custom PL/Python functions. Prestogres requires this setup script runs including create language "plpythonu" statement: https://github.com/treasure-data/prestogres/blob/master/pgsql/setup.sql

You can use "prestogres" command as following to setup local PostgreSQL rather than RDS: https://github.com/treasure-data/prestogres#running-servers