Unable to create a new database because the "postgres" user isn't the database administrator

From: Stephane Ouellette <stephane(dot)ouellette(at)tektrend(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Unable to create a new database because the "postgres" user isn't the database administrator
Date: 2000-09-21 14:46:19
Message-ID: 01C023B9.2D907E20.stephane.ouellette@tektrend.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi everyone,

it's the first time I set up a database manager at all. I installed
PostgreSQL v7.0.2 on a RedHat 6.2 computer (Intel platform) using the
binary RPMs that I downloaded from the ftp.postgresql.org FTP site.

I installed the following RPMs (PostgreSQL was not initially installed
on the computer) :

postgres-7.0.2-2
postgres-devel-7.0.2-2
postgres-perl-7.0.2-2
postgres-python-7.0.2-2
postgres-server-7.0.2-2
postgres-test-7.0.2-2

Note: The "postgres" user was created during the installation of the
RPMs.

The "postmaster" process can be started successfully.

My problem is that the "postgres" user isn't registered as the database
superuser. When I tried to create a new database with the command
"createdb myfirstdb" (logged on as the "postgres" user), I received the
following message:

pgsql: FATAL 1: SetUserId: user 'postgres' isn't in 'pg_shadow'

I would like to know how to make the "postgres" user a database
superuser.

Thank you for any clues you may provide me.

Stephane Ouellette

Browse pgsql-novice by date

  From Date Subject
Next Message Gilles DAROLD 2000-09-21 17:43:41 Re: perl2c tool?
Previous Message Vic 2000-09-21 06:53:50 Re: windows ODBC driver for PG7.02