Re: setting up default user for postgres db access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux