Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u postgres pg_restore -e -C -O latest.tar -d postgres
could not identify current directory: Permission denied
pg_restore: [archiver (db)] connection to database "postgres" failed: FATAL:  role "postgres" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ psql postgres
psql (10.1)
Type "help" for help.

postgres=# \du
                                     List of roles
  Role name   |                         Attributes                         | Member of
--------------+------------------------------------------------------------+-----------
 avikammangla | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=# psql postgres
DROP DATABASE bookbrainz
psql
psql postgres
DROP DATABASE bookbrainz;^Z
[2]+  Stopped                 psql postgres
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u postgres pg_restore -e -C -O latest.tar -d avikammangla
could not identify current directory: Permission denied
pg_restore: [archiver (db)] connection to database "avikammangla" failed: FATAL:  role "postgres" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u psql pg_restore -e -C -O latest.tar -d avikammangla
sudo: unknown user: psql
sudo: unable to initialize policy plugin
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u avikammangla pg_restore -e -C -O latest.tar -d psql
pg_restore: [archiver (db)] connection to database "psql" failed: FATAL:  database "psql" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u avikammangla pg_restore -e -C -O latest.tar -d avikammangla
pg_restore: [archiver (db)] connection to database "avikammangla" failed: FATAL:  database "avikammangla" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u avikammangla pg_restore -e -C -O latest.tar -d bookbrainz
pg_restore: [archiver (db)] connection to database "bookbrainz" failed: FATAL:  database "bookbrainz" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ psql postgres
psql (10.1)
Type "help" for help.

postgres=# CREATE DATABASE bookbrainz;
CREATE DATABASE
postgres=# ^Z
[3]+  Stopped                 psql postgres
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u avikammangla pg_restore -e -C -O latest.tar -d bookbrainz
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3254; 1262 16386 DATABASE bookbrainz postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  database "bookbrainz" already exists
    Command was: CREATE DATABASE bookbrainz WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';



Alkas-MacBook-Pro:BookBrainz avikammangla$ psql postgres
psql (10.1)
Type "help" for help.

postgres=# DROP DATABASE bookbrainz;
DROP DATABASE
postgres=# show bookbrainz;
ERROR:  unrecognized configuration parameter "bookbrainz"
postgres=# ^Z
[4]+  Stopped                 psql postgres
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u avikammangla pg_restore -e -C -O latest.tar -d bookbrainz
pg_restore: [archiver (db)] connection to database "bookbrainz" failed: FATAL:  database "bookbrainz" does not exist
Alkas-MacBook-Pro:BookBrainz avikammangla$ sudo -u postgres psql
Password:
could not identify current directory: Permission denied
psql: FATAL:  role "postgres" does not exist





Alkas-MacBook-Pro:~ avikammangla$ sudo -u avikammangla psql
psql: FATAL:  database "avikammangla" does not exist
Alkas-MacBook-Pro:~ avikammangla$ sudo -u postgres psql
Password:
psql: FATAL:  role "postgres" does not exist