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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
