createused + createdb problems with passwords

From: <ogjunk-pg(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: createused + createdb problems with passwords
Date: 2004-03-24 00:00:22
Message-ID: 20040324000022.74790.qmail@web12705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have created PostgreSQL databases and users a number of times, but
I'm having trouble with that on a new server with Postgresql 7.3.4.

I am trying to create a DB user (createuser) and a database itself
(createdb):

bash-2.05b$ whoami
postgres

bash-2.05b$ tail -5 ~postgres/data/pg_hba.conf
host all all MY.IP.IS.HERE 255.255.255.255 md5

bash-2.05b$ createuser -h MY.IP.IS.HERE otis
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
Password:
psql: FATAL: Password authentication failed for user "postgres"

createuser: creation of user "otis" failed

-- Question: what password am I supposed to enter here?
-- I suppose it's the postgres user's _DB_ password - but how do I know
what it is? I didn't set it.

bash-2.05b$ createdb -h MY.IP.IS.HERE simpydev
Password:
psql: FATAL: Password authentication failed for user "postgres"

createdb: database creation failed

-- Question: what password am I supposed to enter here?

Thank you,
Otis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-03-24 00:00:59 Re: linked list rewrite
Previous Message Vanole, Mike 2004-03-23 23:54:18 Another date / time question