1. Self Hosted - bring your own Postgres/Redshift
2. Segment Managed - we give you a redshift endpoint (on our business tier)
The two options are described here: https://segment.com/blog/introducing-segment-warehouses-reds... and here's where you contact us regarding the hosted redshift: https://segment.com/contact/redshift