Postgresql Help

[arogya guragain]

hello! I configured the postgresql and created a couple of tables in a database db1 earlier. Now, i m not being able to access those tables. While executing command psql db1 where db1 is tha name of my database it gives me the error "database db1 does not exit" while executing psql template1 it gives me the error "psql: FATAL: role "ssharma" does not exist where ssharma is the default username.
What can I do? Plese suggest me.

[Jeff Rummings]

Login with postgres as the username and create a new user:

$ psql -d template1 -U postgres
 
# CREATE USER myUsername WITH PASSWORD �myPassword�;

This page will help if you get stuck.