pgsql: restoring a db is not so straight forward By Ricardo MallaOctober 12, 2021uncategorized winning command psql -Uemail_warehouse emails < /home/warehouse_2021-10-12-15.19.54.sql you need to edit pg_hba.conf #local all all peer local all all md5 otherwise you will get an authentication error