Configuring PostgreSQL for remote database connection

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.