Re: '-U postgres' doesn't authenticate

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Derek Fountain <nospam(at)example(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: '-U postgres' doesn't authenticate
Date: 2004-10-20 15:49:27
Message-ID: 20041020154927.GA20753@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Oct 18, 2004 at 15:27:28 +0800,
Derek Fountain <nospam(at)example(dot)com> wrote:
> I'm using PG-7.4.2 on a SUSE-9.1 box. The docs say that I need to be the
> 'postgres' user in order to do things like create databases, which makes
> sense. If I switch to that user (using 'su') it works fine, but if I use
> the -U switch from my own Linux account I get an error:
>
> >createdb -U postgres test
> createdb: could not connect to database template1: FATAL: IDENT
> authentication failed for user "postgres"
>
> My understanding is that this should work, and it would be a useful shortcut
> for me if it did. Do I misunderstand or have SUSE set something in the
> config to disable this feature?

You need to say that it is OK for your linux account to connect as postgres.
You do this by changing pg_ident.conf. I think just doing a SIGHUP after
the change is enough to get the file reread.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ruediger Herrmann 2004-10-20 17:07:25 Re: Validate for PL/pgSQL functions
Previous Message Hari Bhanujan 2004-10-20 05:37:13 Re: Postgresql for Dummies?