When installing standalone data warehouse for PostgreSQL database (deployment scenario First server installation with standalone data warehouse database ) the production database has to be configured to allow inbound connection from data warehouse database server.
PostgreSQL configuration
In PostgreSQL installation folder add the following line to the data/pg_hba.conf file where data_warehouse_ip without is the IP address of the data warehouse database.
host all all <data_warehouse_ip>/32 md5
You can read more about file structure and configuration options in PostgreSQL documentation article The pg_hba.conf File .