On Sun, 2003-02-02 at 05:27, Cameron Hutchison wrote: > Once upon a time Kevin Coyner said... > > > > As I dig through the docs, I find that I need to su postgres in order to > > create other users. Problem is that if I su postgres, I get queried for > > a password. I've tried the obvious, including nothing, but haven't got > > in as postgres yet. > > su to root first. Then when you su to postgres, you wont need to enter a > password.
Once you are root, do "su - postgres" rather than just "su postgres"; this sets you up as for a direct login by postgres. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Love not the world, neither the things that are in the world. If any man love the world, the love of the Father is not in him...And the world passeth away, and the lust thereof; but he that doeth the will of God abideth for ever." I John 2:15,17 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]