PostgreSQL: Connection to database failed: FATAL: no pg hba.conf entry for host local

From FVue
Jump to: navigation, search


pg_dump: [archiver (db)] connection to database "<DATABASE>" failed: FATAL: no pg_hba.conf entry for host "[local]", user "USER", database "DATABASE", SSL off


1. Added -h argument to pg_dump

2. Created remote ~/.pgpass file containing (replace USER & PASSWORD):


See also
Blog which helped me with the -h


blog comments powered by Disqus