Re: Best starter book - Mailing list pgsql-novice

As Tom explained in his post the error results from the way
authentication is configured in PG's data directory.
I think OpenSuse sets it here  /var/lib/pgsql

In pg_hba.conf you can define how a client has to authenticate devided
in 3 zones coming through local (default) or via network port 5432
either on localhost or on the external interface.

You created the database "mydb". In Suse's default setting only the unix
user "mydb" or a db-superuser can access this db and there has to be a
db-usere "mydb", too.


You might install pgAdmin as managing tool. It's a binary application
available for Linux and Windows.
It should be in the OpenSuse repository.
http://www.pgadmin.org/

Then there is a web-application phpPgAdmin if you like that better.



Am 21.05.2010 19:36, schrieb Donn Washburn:
> This is an example of the problem.
>
> I went to http://www.postgresql.org/docs/current/static/ and started
> looking at everything until  /tutorial-createdb.html.  Where it states
> createdb.
>
> I get as a (system user)donn@m1l-suse:~> createdb mydb
> createdb: could not connect to database postgres: FATAL:  Ident
> authentication failed for user "donn"
>
> The attached file show postmaster is working.  I assume this is a
> security/ issue with a lack of password.  Or maybe a /etc/groups problem
>
>
>
> On 05/21/2010 10:48 AM, Michael Gould wrote:
>> Donn,
>>
>> There are not a lot of books available and most of them just rehash
>> for the
>> most part what is in he documentation.  You can get the "standard"
>> doc's in
>> printed format.  I've found that between the documentaton which on a
>> scale
>> of 1-10 I would rate about a 7 and the answers in the email groups,
>> you'll
>> find that overall support is many times better than a commerical
>> software.
>> They have a robot named Tom Lane who isin the groups.  I say robot
>> because I
>> see that he answers items what seems like 24 hours a day so I know he
>> can't
>> be a real person as he can't sleep. :)
>>
>> Best Regards
>>
>> Mike Gould
>>
>> "Donn Washburn"<n5xwb@comcast.net>  wrote:
>>> Hey Group;
>>>
>>> I have openSuSE 11.3 M7 version pf 8.4.  What would be a good starter
>> book.
>>> I will be using pgsql as a small business DB.
>>>
>>> --
>>> 73 de Donn Washburn
>>> 307 Savoy Street     Email:" n5xwb@comcast.net "
>>> Sugar Land, TX 77478 LL# 1.281.242.3256
>>> Ham Callsign N5XWB   HAMs : " n5xwb@arrl.net "
>>> VoIP via Gizmo: bmw_87kbike / via Skype: n5xwbg
>>> BMW MOA #: 4146 - Ambassador
>>>         " http://counter.li.org " #279316
>>>
>>>
>>
>
>
>
>
>