I am getting this error while restoring data from the dump file.
nishant@nishant-Lenovo-G50-70:~/Documents$ psql sortation_gor1 < dump.sql
psql: FATAL: role "nishant" does not exist
I have followed the Postgress Ubuntu Documentation But when I am trying to restore the database I am getting this error. Any IDea. ?
The I did it with the
psql -U postgres -d d1atabase_name -f dump.sql