Amazon Redshift
export PREST_VERSION=2
DATABASE_URL=postgresql://localhost:5432/postgres?OpenSourceSubProtocolOverride=trueLast updated
Analyze all of your data with the fastest and most widely used cloud data warehouse.
Amazon Redshift is based on PostgreSQL. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. read more
Amazon Redshift is compatible with postgresql just use the ODBC connection in the environment variable DATABASE_URL with the parameter OpenSourceSubProtocolOverride to make pREST connect to the database.
export PREST_VERSION=2
DATABASE_URL=postgresql://localhost:5432/postgres?OpenSourceSubProtocolOverride=truev2 notes: set
PREST_VERSION=2for v2 deployments. The deprecatedPREST_SSL_*variables were removed in v2 — usePREST_PG_SSL_*instead. When JWT enforcement is enabled, configure JWT (PREST_JWT_KEY,PREST_JWT_JWKS, orPREST_JWT_WELLKNOWNURL) explicitly — or expect JWT to be auto-disabled with a warning in v2.0.0. The v2.0.0-rc6 tagged binary refuses to start without verification material. See Upgrading to v2.
Last updated