Re: Problem with starting up

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Nandu Garg" <focussed(at)rediffmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with starting up
Date: 2002-01-11 11:03:59
Message-ID: NEBBLAAHGLEEPCGOBHDGAEOCECAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Amol-

Answers to your several questions:

> $psql Connection to database 'amol' failed. FATAL 1: Database
> amol does not exist in pg_database

This message simply means the database doesn't exist yet.

> command $createdb mydb Connection to database 'template1' failed.
> FATAL 1: SetUserId: user 'amol' is not in 'pg_shadow'

This looks like the heart of your problem. You need to set your linux user
to postgres ("su - postgres" from root), and do a "createuser amol" if you
want to use the databse from your account.

> do I
> have to connect using 'postgres' user ..what is the password by
> default

Generally, by default the authorization method is "peer sameuser" after
initial install, meaning that if you are logged into linux as a user that
exists in pg_shadow, you are authorized. the user "postgres" is initially
there, so just su to postgres while you create other user accounts using
createuser. Later you may want to choose a more secure auth method. Search
the interactive documentation for "pg_hba.conf" to learn more about
authorization methods & how to set them.

Hope this helps you get started! Welcome to postgresql.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nandu Garg 2002-01-11 11:35:12 Problem with starting up
Previous Message will trillich 2002-01-11 09:35:08 Re: caching subtotals: update vs sum -- aaugh!