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?
pgsql-novice by date
|Next:||From: Chris Mair||Date: 2004-10-18 08:38:04|
|Subject: Re: Getting Started|
|Previous:||From: Ruediger Herrmann||Date: 2004-10-17 19:27:39|
|Subject: Validate for PL/pgSQL functions|