Postgres projects require the following configuration settings:
[name].[id].[region].redshift.amazonaws.com if you are using AWS.5432 )Dataform validates the compiled script you are editing against Postgres in real time. It will let you know if the query is valid (or won’t run) before having to run it.
If you are using Dataform web and are having trouble connecting to Postgres, please reach out to us by using the intercom messenger at the bottom right.
If you have other questions related to Postgres, you can join our slack community and ask question on the #Postgres channel.