Tag: database

pg_restore: [archiver (db)] connection to database “dvdrental” failed: FATAL: Peer authentication failed for user “postgres”

I wanted to learn postgresql operations on real database. So, I was following online tutorial where I downloaded a sample database ‘dvdrental.tar’ and got the error ‘ FATAL: Peer authentication failed for user “postgres” ‘ while loading into postgresql. I created a new database in postgresql using the following command. $ sudo -u postgres psql postgres=# CREATE DATABASE dvdrental; postgres=# \list List of… Read more →

Floating Social Media Icons Powered by Acurax Blog Designing Company