On Mon, 2002-11-18 at 08:50, anthony baldwin wrote: > > > >su > >su postgres > >createuser <username> > > > >Dave Cook > > > > > Tried that...no luck. Others have suggested that there is no password, as well. but the terminal asks forone and if I simply press enter without giving one, I get > the "incorrect password" message. [allena28@zero allena28]$ su postgres Password: su: incorrect password ^---- implies you are trying "su postgres" as a regular user rather than as root. [root@zero allena28]# su postgres bash-2.05b$ When you are the "root" user, it does not matter what the password is however if you change the postgres password. [root@zero allena28]# more /etc/shadow | grep postgres postgres:!!:11967:::::: ^---- postgres user has no password postgres:$1$CnCADi8B$FjUCgDJKnJ.10gMctOWjK1:12009:0:99999:7::: ^---- postgres user has a password [root@zero allena28]# passwd postgres then you should be able to login with (normal practice is for root to su to a different user), but if you can't get that to work - this might be easier. [root@zero allena28]# ssh localhost -lpostgres -- NAME : Adam Allen. EMAIL : adam@dynamicinteraction.co.uk COMMENT : ~~~~ insert your favourite signature comment here ~~~~ PGP : http://search.keyserver.net:11371/pks/lookup?op=vindex&search=adam%40dynamicinteraction.co.uk
Attachment:
signature.asc
Description: This is a digitally signed message part
