On Thu, Jan 29, 2004 at 23:39:23 -1000, Susemail <[EMAIL PROTECTED]> wrote: > Is this good advice? > > IDENT Authentication failed for user "postgres" > > This error has everything to do with the way distros set up access rights for > postgres. They are way too restrictive and leave you wondering what to do > next. > > Do yourself a favour and change authentication type in pg_hba.conf to > > local all trust > > until you have figured out what all this stuff in pg_hba.conf does. Read about > the different authentication settings and change them as you see fit. It is > all described in detail in pg_hba.conf
If only trusted users have access to the server, this is a reasonable way to start off while learning things. Generally using ident for local access is the way to go unless you are using OS where it doesn't work. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend