pgsql: restoring a db is not so straight forward

 

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

Leave a Reply

Your email address will not be published.