Re: PostgreSQL setup and use

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

 



On 07/15/2009 11:43 PM, Brad Pepers wrote:
2. So now I have it installed and I try to create a database using
createdb. I'm logged in as bpepers and just do "createdb foo" on the
command line. I get this error message:

createdb: could not connect to database postgres: FATAL: Ident
authentication failed for user "bpepers"

Anyone know why this is happening?
You need to "createuser" first. Add a "bpepers" user to PostgreSQL with
the right to create new databases. Afterward, you'll be able to
"createdb" as the system user "bpepers".
As root:
su postgres -c "createuser bpepers"

The pg_hba.conf is using "ident
sameuser" for local connections. As far as I know this should allow the
postgresql server to authenticate that I'm me.
It does. The server knows your system user name, but does not have a
user of its own to which you can be mapped. As such, it does not know
what permissions should be given to you.
The first problem means a number of extra steps run as root
and the second seems to mean the user will have to edit PostgreSQL
config files in order to get things running.
No editing should be required.

--
fedora-list mailing list
[email protected]
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines

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

  Powered by Linux