PostgreSQL (was: New to LAMP)

[Bruno Wolff III]

On Mon, Oct 10, 2005 at 14:55:44 -0700,
  Kenneth Porter <shiva at sewingwitch.com> wrote:
> --On Tuesday, October 04, 2005 10:39 PM -0700 "Andrew B. Young" 
> <andrew_b_young at earthlink.net> wrote:
> 
> >I am very interested in other's opinions on MySQL v. PostgreSQL.
> 
> I tried firing up PostgreSQL last year and running the equivalent of 
> phpMyAdmin for it but got stuck trying to get the authentication right, and 
> I couldn't find any good web pages or mailing lists to get me over the 
> hump, so I shelved the attempt. Has the situation improved? How hard is it 
> to get a bare-bones web-based admin system up and running?

Normally you will want to use ident access for local users connecting through
domain sockets.
If you need to connect to the database directly from other hosts, then you
probably want to use password based authentication, though with recent
versions there are some other options.