Redshift Support?
Closed this issue · 14 comments
Hello,
Thank you for creating this tool, it's great! Do you happen to know if there's anything preventing me from using the postgres functionality against a AWS Redshift database? I tried it last night, and got a permissions error. But I'm not sure why. Do you know of any issues with Redshift specifically?
Hey @khanson615, I haven't tried it with Redshift, but it shouldn't be too hard to support if it doesn't work already. Can you paste the error message?
The error is "pg: relation "pg_extension" does not exist"
Also, is there a way to avoid the sampling feature that only does 10,000 rows? Or a way to specify which tables to target?
Hey @khanson615, just pushed an update for that error. You can get the latest version with:
go get github.com/ankane/pdscan
You can pass a large value to --sample-size
if you want to check all rows (not recommended). There's not a way to exclude tables right now.
Awesome! Thank you very much Andrew!
Will that update make it into the Linux-specific package?
Not until the next release (don't have a timeline).
Is there a way that I could compile it myself?
If you install Go and dep, you can follow the instructions in the Contributing section of the readme. To produce a binary, run:
go build
Did you have a chance to try it?
Hi Andrew,
I had a chance to pull down the latest (I think) code package, and it's still throwing the same error around the "pg_extension" relation. Is it something I'm doing wrong?
Hi Andrew!
Sorry to be a bother, but any update on this?
Kind regards,
Ken
@khanson615 Not sure how I can help any further. Make sure you're using the binary built from source.
Cleaning up issues