ankane/pdscan

Redshift Support?

Closed this issue · 14 comments

khanson615 commented

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?

ankane commented

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?

khanson615 commented

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?

ankane commented

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.

khanson615 commented

Awesome! Thank you very much Andrew!

khanson615 commented

Will that update make it into the Linux-specific package?

ankane commented

Not until the next release (don't have a timeline).

khanson615 commented

Is there a way that I could compile it myself?

ankane commented

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
ankane commented

Did you have a chance to try it?

khanson615 commented
khanson615 commented

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?

khanson615 commented

Hi Andrew!

Sorry to be a bother, but any update on this?

Kind regards,
Ken

ankane commented

@khanson615 Not sure how I can help any further. Make sure you're using the binary built from source.

ankane commented

Cleaning up issues