[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, Tom -- keys: http://tmp.verbreyt.be/files/ (abwaerts.asc & verbreyt.asc) --- np: Ah Cama-Sotz - Religion -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]