Loading the sample data sets -- Linux

TrainingByPackt / SQL-for-Data-Analytics

Perform fast and efficient data analysis with the power of SQL

MIT License

263 stars 432 forks source link

Loading the sample data sets -- Linux #8

Open paulionel opened 2 years ago

paulionel commented 2 years ago

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"

Patriciopompone commented 2 years ago

Had the same issue, no response? Thanks.

Patriciopompone commented 2 years ago

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"

dat-linux commented 1 year ago

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