On (11/07/05 18:42), Tom wrote: > [11/07/2005 -- 18:13u] Clive Menzies: > > > > When I try that, I get this: > > > > > > [17:56:53 tom ~] su > > > Password: > > > [root: /home/tom] su postgres > > > [root: /home/tom] psql > > > psql: FATAL: database "root" does not exist > > > > > > Thanks, > > > Tom > > > > Try: > > > > $ psql Template1 > > > > or > > > > $ psql test > > That didn't work either... With Template1, I got an error about the > database (that would be "template1" instead), but otherwise, there were > errors about user "root" being unknown. > > In the meantime, though, I received a mail from the package maintainer, > in which he suggested to use "su -s /bin/bash postgres" instead of just > plain "su postgres", and indeed, that seems to have done the trick: > > [root: /home/tom] su -s /bin/bash postgres > [EMAIL PROTECTED]:/home/tom$ createuser -A -D tom > CREATE USER > > Obviously, I'm left wondering why "-s /bin/bash" was not the default > (I've never changed anything about login procedures on my machine). > > Anyway, let's hope this trivial problem's solution can be found by > others in similar situations, then. :-) > > Thank you all for your help,
No problem. What is weird (mind you I'm using 7.4.7-6sarge1) is that when I do: [EMAIL PROTECTED]:~$ su Password: Zeus:/home/clive# su postgres I get: [EMAIL PROTECTED]:/home/clive$ Go figure ;) Anyway, glad it's sorted. Its worth having a look at pgadmin3 which is quite user friendly for interfacing with the data base and dealing with privileges. Regards Clive -- www.clivemenzies.co.uk ... ...strategies for business -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
