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.
pg_hba.conf
host all all <data_warehouse_ip>/32 md5You can read more about file structure and configuration options in PostgreSQL documentation article The pg_hba.conf File.