#3 Loading facts may prompt for password

[J Gunderson]

The Postgresql loader does not allow passwords to be supplied. So when you run ETL, the Spoon console may prompt for a password. To avoid this, you must configure Postgresql to trust the connection from Spoon. To set up trusted authentication, change the pg_hba.conf file (on Linux: [postgresql]/main/pg_hba.conf, on Windows: [postgresql]/data/pg_hba.conf).
Typically, the best solution is to trust local connections. You can do this by changing the ‘md5’ method to ‘trust’ in the local connections:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 trust