[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: