Hi Chetan,
here you will have to login as the user 'postgres' if you have created one.
otherwise create a user postgres and you could always login as root and su
postgres.
postgres is the root of PostgreSQL. It does not allow the use of the root.
then read the man pages for initdb and createdb.
To create a posgres user use the command createuser chetan. It will ask you
some questions in which you should use the defaults ( just press enter ).
Hope your queries will be settled soon.
Smiles, :)
Andrew
>From: "chetan dutta" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: [linux-delhi] Postgresql
>Date: Sun, 09 Jul 2000 20:33:11 IST
>
>hi! friends
>
>i need some help configuring postgresql server on my Rh 6.2 system.
>i am using pgsql as backend database for perl DBI in my college project.
>
>please tell me how to create database users, when i try 'psql'
>it shows an error message :
>Connection to database 'root' failed
>Fatal 1 :database root does not exists in pg_database.
>
>when i tried psql as a normal user i got the followin' message:
>connection to database 'chetan' failed
>FATAL 1: Database chetan does not exists in pg_database.
>
>when i tried to create user by using 'createuser' i got this:
>connection to database 'template1' failed
>FATAL 1: SetUserId: user 'root' is not in 'pg_shadow'.
>createuser : database access failed.
>
>even after logging in as a normal user i was not able to create any
>database
>or user, except this time instead of user root it was 'user 'chetan' is not
>in 'pg_shadow''.
>
>i dont know what to do, please help me.
>
>
>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>The mailing list archives are available at
>http://lists.linux-india.org/cgi-bin/wilma/linux-delhi/
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
The mailing list archives are available at
http://lists.linux-india.org/cgi-bin/wilma/linux-delhi/
