uot; does not exist
postgres=# \q
postgres@ulinux3:~$ psql myDB
psql (9.3.4)
Type "help" for help.
myDB=# REVOKE ALL PRIVILEGES ON DATABASE myDB FROM testuser;
ERROR: database "mydb" does not exist
--Prashanth Kumar
should have given the full output earlier
pkumar@ulinux1:~$ sudo su - postgres[sudo] password for pkumar:
postgres@ulinux3:~$ createdb authDBpostgres@ulinux3:~$ createuser -P -l
authuserEnter password for new role: Enter it again: Shall the new role be a
superuser? (y/n) ypostgres@ulinux3:~$ ps
Here is what i did on a Ubuntu linux server. I had installed postgres using
apt-get install postgres.
pkumar@ulinux1:~$ sudo su - postgres[sudo] password for pkumar:
postgres@ulinux3:~$ createdb authDBpostgres@ulinux3:~$ createuser -P -l authuser
You have to sudo into postgres or fix your clas
