[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[SOLVED] Re: PostgreSQL 8.0 bug or my own stupidity?



[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 
postgres@zukunft:/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



Reply to: