Creating DataBases on Suse LINUX Platform

From: "Cook, Larry ISC" <Larry(dot)Cook(at)isc(dot)ca>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Creating DataBases on Suse LINUX Platform
Date: 2005-04-05 20:57:56
Message-ID: 9753D79260E9D31181E600508B64CF340B1AEA45@ltexprd01.sliscorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi...

I have SuSe LINUX 9.1 running on a Compaq P4; the sys admin people installed
PostgreSQL 7.4.2.

I am trying to work my way through the on-line documentation but; I have a
problem right at the start. I cannot
figure out how to create databases or users. The documentation suggests :
You will need to become the
operating system user under which PostgreSQL was installed (usually
postgres) to create the first
user account.
According to the sys people it was installed over the network; presumably as
the "root" user. As a result,
I have tried to create db's and users as my LINUX login name; root & as the
user postgres....
they all give me the same error message : could not connect to database
template1: FATAL: IDENT
authentication failed for user "postgres"; and there does not seem to be any
explanation in the documentation.
I am running out of user accounts to try; any help in this regard would be
greatly appreciated; as well as any
other things I should "look-out" for at the beginning.
Thanking you in advance,
Larry Cook
Geodetic Surveys Branch
Information Services Corp of Sask
tel (306) 787-2828

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-04-05 21:39:57 Re: plpgsql - can't get a simple block to execute
Previous Message Michael Fuhr 2005-04-05 20:48:39 Re: plpgsql - can't get a simple block to execute