Re: [GENERAL] Revoke - database does not exist

2014-05-01 Thread David G Johnston
Prashanth Kumar wrote > Hi, > > Do not seem to figure out what is wrong here. Why am I getting database > does not exist. I just created the database and am able to connect to it > as "postgres" user. > I am trying to restrict "testuser" from connecting to "myDB" database. Thomas is likely co

Re: [GENERAL] Revoke - database does not exist

2014-05-01 Thread Tomáš Vondra
I guess you need to quote the identifier, as you use mixed case. I.e. try "myDB" with the double quotes. Tomas Dne 2. 5. 2014 2:49 Prashanth Kumar napsal(a): Hi,Do not seem to figure out what is wrong here. Why am I getting database does not exist.  I just created the database and am able to co

[GENERAL] Revoke - database does not exist

2014-05-01 Thread Prashanth Kumar
Hi, Do not seem to figure out what is wrong here. Why am I getting database does not exist. I just created the database and am able to connect to it as "postgres" user. I am trying to restrict "testuser" from connecting to "myDB" database. Thanks in advance. postgres@ulinux3:~$ createuser