Am Montag, 27. März 2006 03:10 schrieb Anand Kumria: > While debugging a failed installation of drupal, I had cause to look > into wwwconfig-common. It (eventually) executes something like: > > ++++ psql -U drupal -d drupal -f /usr/share/drupal/database/database.pgsql > psql: FATAL: Ident authentication failed for user "drupal" > > Basically it would be very handy to be able to say in pg_hba.conf, > something like: > > #TYPE DB DB USER ADDRESS METH METH-ARGS > local all all ident user=postgres > > Which is, if the operating system user is 'postgres' allow that user to > pretend to be any database user.
While this might be an interesting feature, a more straightforward way to get your installation working would be to let psql connect as user postgres and stick a SET SESSION AUTHORIZATION 'drupal'; at the top of the script.
