bruce wrote:
hi...
(already posted to the postgres list)
i have a postgres setup with an actual user. i can do a 'psql -Ugforge' and
give the password, and get into the app..
the problem i'm having is that i can't get into postrges as the default/root
user...
You can't get in because "root" isn't a postgresql user.
from a command line as root, do:
su - postgres -c "createuser root"
and follow the prompts.
If you want root to have a database then:
su - postgres -c "createdb -Oroot root"
That should do the trick.
BK
