The existing features (in psql) that work with any Postgres fork (like Redshift) are entirely because it is a fork of Postgres. Since I use psql heavily at work, last week I decided to begin maintaining a branch of Postgres that better supports (Postgres forks, but initially) Redshift.
The 'redshift' branch of this Official Postgres Repository clone, is aimed at supporting Redshift in many ways:
- Support Redshift related artifacts
- Redshift specific SQL Commands / variations
- Redshift Libraries
- Support AWS specific artifacts
- For e.g. AWS Regions
The idea is:
- Maintain this branch for the long-term
- At least as long as I have an accessible Redshift cluster
- Down the line look at whether other Postgres forks (for e.g. RDS Postgres) need such special attention
- Although nothing much stands out yet
- Change the default port to 5439 (or whatever the flavour supports)
- ...with an evil grin ;)
- Further, as of now, I don't expect to remove 'Unsupported Postgres features'
- Additionally, as far as possible:
- Keep submitting Postgres related patches back to Postgres master
- Keep this branch up to date with Postgres master
Let me know if you find anything that needs inclusion, or if I missed something.