quasar accounting on ubuntu??

Shot - Piotr Szotkowski shot at hot.pl
Wed Jul 20 10:04:45 UTC 2005


Brian Walker:

> brian at ubuntu:~$ psql -h localhost -U xxx template1
> psql: FATAL: IDENT authentication failed for user "xxx"

By default, PostgreSQL accepts only the user that tries to establish
the connection - in your case you should be able to log in as brian
(provided that you created the brian user in PostgreSQL before).

If you want to allow local connections as other users, you have to
sudoedit the /etc/postgresql/pg_hba.conf file and change the "ident
sameuser" method to "md5" for "All other connections by UNIX sockets"
(and, possibly, for "All IPv4 connections from localhost" as well).

Remember to reload the settings afterwards
with `sudo /etc/init.d/postgresql reload`.

-- Shot
The vast majority of Iraqis want to live in a peaceful, free world. And we will
find these people and we will bring them to justice.          -- George W. Bush
========================= http://shot.pl/wycinki/ === http://shot.pl/1/125/ ===
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20050720/dbfa144d/attachment.pgp>

More information about the ubuntu-users mailing list