Re: [SOLVED] pg_hba.conf + all + trust = Ident authentication failed

From: "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk>
To: "'ow'" <oneway_111(at)yahoo(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [SOLVED] pg_hba.conf + all + trust = Ident authentication failed
Date: 2006-03-06 15:52:20
Message-ID: !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAAAT2W0TeMjdSZg87hCrFUlgAQAAAAA=@mailnetwork.co.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You could always symlink the debian config files to your correct ones.

Andy

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of ow
Sent: Monday, 06 March, 2006 3:46 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust = Ident
authentication failed

--- Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

> Are you sure you're using the configuration below (ie, you're editing the

I was sure... :-)

> correct file and have at least used sighup after the change)? It sure
> looks like the server thinks the method is ident which would be the
> default for the debian packages I think.
>

But now I looked and, yes, in debian, the server uses config files from
/etc/postgresql/8.1/main/, where it has "ident sameuser" and I was editing
the
files in /var/lib/postgresql/8.1/main/, my data directory.

Now it works. Thanks to everyone who responded.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

!DSPAM:14,440c595e49411415720386!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabrice.Sznajderman 2006-03-07 08:47:43 VACUUM Error?
Previous Message ow 2006-03-06 15:45:58 Re: [SOLVED] pg_hba.conf + all + trust = Ident authentication failed