FATAL 1: SetUserId: user 'postgresql' is not in 'pg_shadow'

From: "Anthony Goubard" <anthony(at)tryllian(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: FATAL 1: SetUserId: user 'postgresql' is not in 'pg_shadow'
Date: 2000-02-22 14:38:01
Message-ID: 00b501bf7d42$6b6bbe80$2400a8c0@tryllian.comintra.tryllian.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I hope you can solve my problem I'm working on for 1 day now.

I did "pg_passwd passwd" and entered postgresql
I succeed to "initdb - u postgresql"
--
When I try to create a
postgresql(at)xxxx:/usr/lib/postgresql/bin$ createuser postgresql
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'postgresql' is not in 'pg_shadow'

createuser: database access failed.
----

I also tried psql
postgresql(at)xxxx:/usr/lib/postgresql/bin$ psql -e template1 -c "CREATE USER
post
gresql"
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'postgresql' is not in 'pg_shadow'
--
I'm running on the same machin as postmaster and changed the pg_hba.conf so
that it can trust everybody
when I look in my pg_shadow file I see : ° °Y ÃB
$¿postgresql`Å.~
and I've a template1 directory
Any ideas? How do I access the database?

I also tried as root but same result : FATAL 1: SetUserId: user 'root' is
not in 'pg_shadow'
and of course "psql template1" give the same error.
I'm using debian.

Best regards,
Anthony Goubard

Browse pgsql-admin by date

  From Date Subject
Next Message Nora Luz Escobar López 2000-02-22 18:02:24 subscription
Previous Message John Reynolds 2000-02-22 12:36:57 Re: [ADMIN] Backup of db with large objects.