Adventures in Linux
ACPI administration advocacy advocacy opinion apache audio authentication bash calendar commandline cron database debian desktop development disk dvd emacs email exim files firefox firewall ftp fun grub hardware hardware html images installation ipod kde knoppix laptop latex mplayer multimedia mysql network nfs openoffice opinion opinion pdf perl php postgresql printing scripting scsi security shell sitenews slackware spam ssh subversion svk t23 t43 text thinkpad thunderbird time users windows wine wordpress xwindows xwindows
One of the most annoying things is the way that postgres is first installed. IDENT authentication requires your unix and postgres identities to be the same. It's very frustrating and means we often end up with this error: FATAL: IDENT authentication failed for user
.A way to fix this, at least on development machines is to tell postgres to trust all local users. In pg_hba.conf put something like this. It is apparently the "upstream" default and allows unrestricted access to any database by any user on the local machine:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
#
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
