Skip to content

Instantly share code, notes, and snippets.

@mandalm

mandalm/install.txt

Forked from pingles/install.txt
Created July 27, 2016 17:27
Show Gist options
  • Save mandalm/c3bf561968287f61dc2ae0b07484a5ea to your computer and use it in GitHub Desktop.
Save mandalm/c3bf561968287f61dc2ae0b07484a5ea to your computer and use it in GitHub Desktop.
Download ZIP
Raw
install.txt
$ brew install unixodbc
$ brew tap pingles/homebrew-psqlodbc
$ brew install psqlodbc
# can now check the connection...
$ isql -v redshiftodbc
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
Raw
odbc.ini
[redshiftodbc]
Driver = PostgreSQL
ServerName = some-cluster.something.eu-west-1.redshift.amazonaws.com
Port = 5439
Database = data
Username = dbuser
Password = dbpass
Debug = 0
Autocommit = 1
Raw
odbcinst.ini
[PostgreSQL]
Description = PostgreSQL
Driver = /usr/local/lib/psqlodbcw.so
Debug = 0
CommLog = 1
UsageCount = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment