SQL-for-Data-Analytics icon indicating copy to clipboard operation
SQL-for-Data-Analytics copied to clipboard

Loading the sample data sets -- Linux

Open paulionel opened this issue 4 years ago • 3 comments

I have created the data base sqlda but when I try to load it with data using "psql -d sqlda data.dump" it gives me the following error: psql: error: FATAL: Peer authentication failed for user "data.dump"

paulionel avatar Oct 28 '21 16:10 paulionel

Had the same issue, no response? Thanks.

Patriciopompone avatar Mar 17 '22 20:03 Patriciopompone

Maybe this issue is with newer version of postgres (12 in my case). I used this command and worked " psql -U postgres sqlda < data.dump"

Patriciopompone avatar Mar 21 '22 18:03 Patriciopompone

postgres is the worst DB the author could have chosen for this

dat-linux avatar Sep 04 '22 10:09 dat-linux