I normally write to postgres or redshift, but I thought I'd test out clickhouse. Couldn't get it working. I'm wondering if it's possible to use clickhouse with target-postgres.

I don't see why not, what issue are you hitting?

I'm wondering if it's possible to use clickhouse with target-postgres.

You mean relying on Clickhouse's support for the postgres wire protocol? It's worth trying at least. There's also https://hub.meltano.com/loaders/target-clickhouse.