Re: PostgreSQL 8.0 bug or my own stupidity?

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

On (11/07/05 16:57), Tom wrote:
> [11/07/2005 -- 16:41u] Clive Menzies:
> 
> > > Firstly, the su-to-postgres doesn't seem to work.
> > > 
> > > I hope I'm not overlooking something very obvious, or otherwise asking
> > > the wrong questions, but could anyone tell me what I'm doing wrong?
> > 
> > Not really answering your question directly nor being in anyway expert
> > having just installed postgresql for the first time just recently, I did
> > the following as postgres:
> > 
> > $ psql 
> > 
> > and then created created users using SQL.
> 
> The longer this takes, the more I'm getting afraid I'm missing something
> obvious, but what do you mean with "as postgres"? How do you become that
> user...? It's login shell is /bin/false -- if I knew how to issue
> commands in postgres' name, the README.Debian.gz approach (createuser)
> would work too, but that's exactly the problem... *g*

$ su
password

# su postgres
(no passwd required)

Regards

Clive

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