On Mon, Jul 11, 2005 at 04:57:29PM +0200, 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* I think you have two options here: createuser -U postgres youruser Or psql -U postgres template1 And then: CREATE USER youruser; (The -U option allows you to connect as another user) Tim > > Thanks though, > Tom > > -- > keys: http://tmp.verbreyt.be/files/ (abwaerts.asc & verbreyt.asc) > --- > np: Kirlian Camera - The Limit > > > -- > To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org > with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org > --
Attachment:
signature.asc
Description: Digital signature