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 : [EMAIL PROTECTED]
COMMENT : ~~~~ insert your favourite signature comment here ~~~~
PGP :
http://search.keyserver.net:11371/pks/lookup?op=vindex&search=adam%40dynamicinteraction.co.uk
signature.asc
Description: This is a digitally signed message part
