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.
posted 8 years ago
Login with postgres as the username and create a new user: