Problem in starting postgresql
Hi All
I am new to pgsql and just now started with it. It is installed on our Linux Machine.
I am referring an online Doc and doing things. Now I have following prblems at my level.
when I issue following command at my prompt It gives me following error
$psql
Connection to database 'amol' failed.
FATAL 1: Database amol does not exist in pg_database
When I issued following command
$createdb mydb
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'amol' is not in 'pg_shadow'
'amol' is my actual user on linux. Now What can be the problem.. Also let me know what are the starting command on Linux for pgsql.
Amol
you will have to create the user Amol in the database if you want to
connect to it using psql.
Otherwise you can connect using the user that you started the db system
normally postgres
then you do
psql -U postgres template1
From here you can create other dbs users etc, or you can go to the bin in
pgsql and use the fnctions there
Hope this helps
Darren
Darren Ferguson
On 9 Jan 2002, Nandu Garg wrote:
Show quoted text
Hi All
I am new to pgsql and just now started with it. It is installed on our Linux Machine.
I am referring an online Doc and doing things. Now I have following prblems at my level.when I issue following command at my prompt It gives me following error
$psql
Connection to database 'amol' failed.
FATAL 1: Database amol does not exist in pg_databaseWhen I issued following command
$createdb mydb
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'amol' is not in 'pg_shadow''amol' is my actual user on linux. Now What can be the problem.. Also let me know what are the starting command on Linux for pgsql.
Amol
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?