Didn't work even with `~/.pgpass` Figured out that, one can set the `PGPASSWORD` environment variable and it works. Pull request coming soon.