Psql fatal database does not exist

# So you do not have to create a database with your role name

psql -U Username DatabaseName

Source: stackoverflow.com

Psql database does not exist

It appears that your package manager failed to create the database named $user for you. The reason that

psql -d template1

works for you is that template1 is a database created by postgres itself, and is present on all installations. You are apparently able to log in to template1, so you must have some rights assigned to you by the database. Try this at a shell prompt:

createdb
and then see if you can log in again with

psql -h localhost

Fatal database postgres does not exist

psql -d template1

Source: stackoverflow.com

Similar codes

1 vote159 views1 answer
Oracle create program if no exists
SQL
-1 vote224 views1 answer
Minus vs except in sql
SQL
0 vote160 views1 answer
Sql where time stamp is in between
SQL
0 vote152 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote240 views1 answer
Sqlalchemy _in array sqlite
SQL
16 votes210 views4 answers
Find duplicates mysql
SQL
0 vote144 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
23 votes125 views3 answers
Mysqldump
SQL
0 vote165 views1 answer
Create dump file mysql workbench
SQL
8 votes150 views1 answer
Sql limit results returned
SQL