Re: PostgreSQL 8.0 bug or my own stupidity?

[Clive Menzies <clive@clivemenzies.co.uk>]

On (11/07/05 17:59), Tom wrote:
> [11/07/2005 -- 17:10u] Clive Menzies:
> 
> <cut>
> 
> > > > I did the following as postgres:
> > > > 
> > > > $ psql 
> > > > 
> > > > and then created created users using SQL.
> > >
> > > what do you mean with "as postgres"?
> 
> <cut>
> 
> > $ su
> > password
> > 
> > # su postgres
> > (no passwd required)
> 
> 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

Regards

Clive

-- 
www.clivemenzies.co.uk ...
...strategies for business