Creating DataBases on Suse LINUX Platform - Mailing list pgsql-novice

From Cook, Larry ISC
Subject Creating DataBases on Suse LINUX Platform
Date
Msg-id 9753D79260E9D31181E600508B64CF340B1AEA45@ltexprd01.sliscorp.com
Whole thread Raw
Responses Re: Creating DataBases on Suse LINUX Platform
List 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


pgsql-novice by date:

Previous
From: "jo ."
Date:
Subject: what is command to view data inside the table
Next
From: Tom Lane
Date:
Subject: Re: Selects in Function Return Wrong Value